{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Report Information","Header_Template","Financial_Info_Template","Sch1 Entry","Sch1_Data","Sch1_Template","Sch1_Assembly","Sch1_No_Trans","Sch2 Entry","Sch2_Template","Sch2_Assembly","Sch3 Entry","Sch3_Template","Sch3_Assembly","Form 55","Form55_Template","Form55_No_Trans","XML_Data","Instructions"],"not_rendered":{"charts":0,"images":35,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Report Information","index":0,"n_rows":251,"n_cols":36,"rows_kept":251,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paid Preparer Form",null,"Filer Information",null,"Transmission Information",null,"Report Details",null,"Validation",null,"Country Abbrev.","State Abbrev.","Process Type","Filer Type",null,"Software ID:","NE_CIGXML","Financial Information",null,"Sale to Fed Gov","Schedule Types"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Business Name:","","Business Name:",null,"Transmission ID:",{"$f":"CONCATENATE(S10,TEXT(U14,\"mmddyyyyhhmm\"))","v":"103120191315"},"Amended Ret:",false,"Report Info Valid:",{"$f":"IF(SUM(COUNT(Header_Template!F:F),COUNT(Financial_Info_Template!F:F)=0),TRUE,FALSE)","v":true},null,null,"Test","Resident Wholesaler",null,"Version:","Ver. 1.0t","Account Type:","","Y","Tax Paid Purchases"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact Name:",null,"In Care Of:",null,"Process Type:","","Disaster Relief:",false,"Schedule 1 Valid:",true,"AD","AK","Production","Non-Resident Wholesaler",null,"Save File Dir:",null,"Routing Transit Number:",null,null,"Tax Paid Sales"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Address Line1:",null,"Address Line1:",null,"Agent Identifier:",null,"Return Type:",{"$f":"IF(W8<>\"\",IF(W8=\"PACT ACT filer\",\"ScheduleI\",\"Form55\"),\"\")","v":""},"Schedule 2 Valid:",true,"AE","AL",null,"PACT ACT Filer",null,"File Name:",{"$f":"CONCATENATE(\"CIG_REP\",TEXT(W5,\"yyyy-mm-dd \"),TEXT(NOW(),\"yyyymmdd s\"),\".xml\")","v":"CIG_REP1900-01-00 20191031 10.xml"},"Bank Account Number:",null,null,"Tax Paid Credits"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Address Line2:",null,"Address Line2:",null,"(t)ETIN:",null,"Tax Pd Begin:",null,"Schedule 3 Valid:",true,"AF","AR","Suffix List",null,null,null,null,"Payment Amount:",null,null,"Untaxed Credits"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City:",null,"City:",null,"(t)EFIN:",null,"Tax Pd End:",{"$f":"IF(W12=\"valid date\",IF(LEN(W5)=10,TEXT(EOMONTH(W5,0),\"mm/dd/yyyy\"),\"\"),\"\")","v":""},null,null,"AG","AZ",null,"Account Type",null,"Version","Date","Identification Number:","",null,"Untaxed Sales"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State:",null,"State:",null,"(t)State EIN:",null,"Exp of Disaster Relief:",null,null,null,"AI","CA","JR","Checking",null,1,"2012-12-18","Account Holder Name:",null,null,"Untaxed Purchases"]
[null,null,null,null,null,null,null,null,null,null,"Save File Path:",null,"C:",null,null,"Zip:",null,"Zip:",null,"(o)EFIN",null,"Filer Type:",null,null,null,"AL","CO","SR","Savings",null,null,null,"Account Holder Type:",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E-Mail:",null,"EIN:",null,"(o)typecd",null,"TxPdBeg-TxPdEnd",{"$f":"IF(W12=\"valid date\",IFERROR(IF(W6<>\"\",\"Tax Period:   \"&TEXT(W5,\"mm/dd/yyyy\")&\" - \"&W6,\"Tax Period:\"),\"Tax Period:\"),\"Tax Period\")","v":"Tax Period"},null,null,"AM","CT","I",null,null,null,null,"Requested Payment Date:",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SSN:",null,"State EIN:",null,"(p)EFIN",null,"Amended Ret Indicator:",{"$f":"IF(W2=TRUE,\"X\",\"\")","v":""},null,null,"AO","DC","II","Account Holder Type",null,null,null,"Checking Type Indicator:",{"$f":"IF(AH2 = \"Checking\",\"X\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State ID:",null,"rep First Name:",null,null,null,"No Transactions Indicator:",{"$f":"IF(W14=TRUE,\"X\",\"\")","v":""},null,null,"AQ","DE","III","Business",null,null,null,"Savings Type Indicator:",{"$f":"IF(AH2 = \"Savings\",\"X\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Firm ID:",null,"rep MI:",null,"Record Count:",1,"Tax Pd Begin Valid:",{"$f":"IF(NOT(ISERROR(DATEVALUE(TEXT(W5,\"mm/dd/yyyy\")))),\"valid date\",\"invalid date\")","v":"invalid date"},null,null,"AR","FL","IV","Personal",null,null,null,"Acct Holder Type Number:",{"$f":"IF(AH8<>\"\",IF(AH8=\"Personal\",2,1),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone:",null,"rep Last Name:",null,"Jurisdiction:","NE","Tax Pd Begin FDOM:",{"$f":"IF(W12=\"valid date\",TEXT(DATE(YEAR(W5),MONTH(W5),1),\"mm/dd/yyyy\"),\"\")","v":""},null,null,"AS","GA","V"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(f)Address Line1:",null,"rep Suffix:",null,"Timestamp:",{"$f":"NOW()","v":"2019-10-31T13:15:09.630"},"No Transactions:",false,null,null,"AT","HI","VI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(f)Address Line2:",null,"rep Title:",null,null,null,null,null,null,null,"AU","IA","VII"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(f)City:",null,"rep E-Mail:",null,"State Schema Version:",null,null,null,null,null,"AW","ID","VIII"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(f)Province or State:",null,"rep Phone:",null,"Submission ID:",{"$f":"IF(AND(Header_Template!F95<>1,Header_Template!G95<>1),CONCATENATE(Header_Template!C95,TEXT(NOW(),\"yyyy\"),TEXT((TODAY()-DATEVALUE(\"1/1/\"&TEXT(TODAY(),\"yy\"))+1),\"000\"),U12),\"\")","v":""},null,null,null,null,"AX","IL","IX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(f)Country:",null,null,null,null,null,null,null,null,null,"AZ","IN","X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(f)Postal Code:",null,"(f)Address Line1:",null,"Process Type Modified:",{"$f":"IF(U3=\"Test\",\"T\",IF(U3=\"Production\",\"P\",\"\"))","v":""},null,null,null,null,"BA","KL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(f)Phone:",null,"(f)Address Line2:",null,null,null,null,null,null,null,"BB","KS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(f)City:",null,null,null,null,null,null,null,"BD","KY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Foreign Address:",false,"(f)Province or State:",null,null,null,null,null,null,null,"BE","LA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Self Employed:",false,"(f)Country:",null,null,null,null,null,null,null,"BF","MA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(f)Postal Code:",null,null,null,null,null,null,null,"BG","MD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(f)Phone:",null,null,null,null,null,null,null,"BH","ME"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BI","MI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Foreign Address:",false,null,null,null,null,null,null,"BJ","MN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BL","MO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BM","MS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BN","MT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BO","NC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BQ","ND"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BR","NE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BS","NH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BT","NJ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BV","NM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW","NV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BY","NY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BZ","OH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CA","OK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CC","OR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CD","PA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CF","RI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CG","SC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CH","SD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CI","TN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CK","TX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CL","UT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CM","VA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CN","VT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CO","WA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CR","WI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CU","WV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CV","WY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CW","AE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CX","AA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CY","AP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"`",null,null,null,null,null,null,null,null,null,null,null,"CZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DJ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ET"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FJ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GQ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ID"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IQ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ME"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ML"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MQ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SJ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TJ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZW"]

{"sheet":"Header_Template","index":1,"n_rows":136,"n_cols":8,"rows_kept":136,"cut":false,"hidden":true,"merged":[]}
["XML Code","Tag","Data","Display Line","Indent","Syntax Validate ","Required Validate","Type"]
["<?xml version=\"1.0\" encoding=\"UTF-8\" ?> ",null,null,"Y",1]
["<Transmission xmlns=\"http://www.irs.gov/efile\"> ",null,null,"Y",1]
[{"$f":"CONCATENATE(\"<TransmissionHeader recordCount=\"\"\",C4,\"\"\">\")","v":"<TransmissionHeader recordCount=\"1\">"},null,{"$f":"IF('Report Information'!U12<>\"\",'Report Information'!U12,\"1\")","v":1},"Y",2,{"$f":"IF(C4<>\"\",IF(ISERR(INT(C4)),1,IF(C4-INT(C4)>0,1,\"\")),\"\")","v":""},null,"Int"]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<Jurisdiction>NE</Jurisdiction>"},"Jurisdiction",{"$f":"IF('Report Information'!U13<>\"\",'Report Information'!U13,\"\")","v":"NE"},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"Y"},3,null,{"$f":"IF(INDIRECT(\"C\"&ROW())=\"\",\"1\",\"\")","v":""}]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<TransmissionId>103120191315</TransmissionId>"},"TransmissionId",{"$f":"IF('Report Information'!U2<>\"\",'Report Information'!U2,\"\")","v":"103120191315"},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"Y"},3,null,{"$f":"IF(INDIRECT(\"C\"&ROW())=\"\",1,\"\")","v":""}]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",TEXT(INDIRECT(\"C\"&ROW()),\"yyyy-mm-ddTmm:HH:SS-\"\"05:00\"\"\"),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<Timestamp>2019-10-31T10:13:10-05:00</Timestamp>"},"Timestamp",{"$f":"IF('Report Information'!U14<>\"\",'Report Information'!U14,\"\")","v":"2019-10-31T13:15:09.630"},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"Y"},3,null,{"$f":"IF(INDIRECT(\"C\"&ROW())=\"\",\"1\",\"\")","v":""}]
["<Transmitter>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+3),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},3,null,{"$f":"IF(COUNTIF(D9:D11,\"Y\")>0,\"\",1)","v":1}]
["<ETIN></ETIN>","ETIN",{"$f":"IF('Report Information'!U5<>\"\",'Report Information'!U5,\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4,{"$f":"IF(C9<>\"\",IF(ISERR(INT(C9)),1,IF(C9-INT(C9)>0,1,\"\")),\"\")","v":""},null,"Int"]
["<EFIN></EFIN>","EFIN",{"$f":"IF('Report Information'!U6<>\"\",'Report Information'!U6,\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4,{"$f":"IF(C10<>\"\",IF(ISERR(INT(C10)),1,IF(C10-INT(C10)>0,1,\"\")),\"\")","v":""},null,"Int"]
["<StateEIN></StateEIN>","StateEIN",{"$f":"IF('Report Information'!S10<>\"\",'Report Information'!S10,\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4,{"$f":"IF(C11<>\"\",IF(ISERR(INT(C11)),1,IF(C11-INT(C11)>0,1,\"\")),\"\")","v":""},null,"Int"]
["</Transmitter>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-3),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},3]
["<ProcessType></ProcessType>","ProcessType",{"$f":"IF('Report Information'!U19<>\"\",'Report Information'!U19,\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},3,null,{"$f":"IF(INDIRECT(\"C\"&ROW())=\"\",1,\"\")","v":1}]
["<AgentIdentifier></AgentIdentifier>","AgentIdentifier",{"$f":"IF('Report Information'!U4<>\"\",'Report Information'!U4,\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},3]
["<ReportingAgentSignature></ReportingAgentSignature>","ReportingAgentSignature",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},3]
["<AckAddress></AckAddress>","AckAddress",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},3]
["</TransmissionHeader>",null,null,"Y",2]
["<ReturnState>",null,{"$f":"IF('Report Information'!U16<>\"\",'Report Information'!U16,\"\")","v":""},"Y",2]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<SubmissionId></SubmissionId>"},"SubmissionId",{"$f":"IF('Report Information'!U17<>\"\",'Report Information'!U17,\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},3,null,{"$f":"IF(INDIRECT(\"C\"&ROW())=\"\",1,\"\")","v":1}]
["<ReturnHeaderState>",null,null,"Y",3]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<binaryAttachmentCount></binaryAttachmentCount>"},"binaryAttachmentCount",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
["<Jurisdiction>NE</Jurisdiction>","Jurisdiction",{"$f":"IF('Report Information'!U13<>\"\",'Report Information'!U13,\"\")","v":"NE"},"Y",4,null,{"$f":"IF(INDIRECT(\"C\"&ROW())=\"\",\"1\",\"\")","v":""}]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",TEXT(INDIRECT(\"C\"&ROW()),\"yyyy-mm-ddTmm:HH:SS-\"\"05:00\"\"\"),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<Timestamp>2019-10-31T10:13:10-05:00</Timestamp>"},"Timestamp",{"$f":"IF('Report Information'!U14<>\"\",'Report Information'!U14,\"\")","v":"2019-10-31T13:15:09.630"},"Y",4,null,{"$f":"IF(INDIRECT(\"C\"&ROW())=\"\",\"1\",\"\")","v":""}]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",TEXT(INDIRECT(\"C\"&ROW()),\"yyyy-mm-dd\"),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<TaxPeriodBeginDate></TaxPeriodBeginDate>"},"TaxPeriodBeginDate",{"$f":"IF('Report Information'!W5<>\"\",'Report Information'!W5,\"\")","v":""},"N",4,null,{"$f":"IF(INDIRECT(\"C\"&ROW())=\"\",1,\"\")","v":1}]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",TEXT(INDIRECT(\"C\"&ROW()),\"yyyy-mm-dd\"),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<TaxPeriodEndDate></TaxPeriodEndDate>"},"TaxPeriodEndDate",{"$f":"IF('Report Information'!W6<>\"\",'Report Information'!W6,\"\")","v":""},"N",4,null,{"$f":"IF(INDIRECT(\"C\"&ROW())=\"\",1,\"\")","v":1}]
["<TaxYear></TaxYear>","TaxYear",null,"N",4]
["<Quarter></Quarter>","Quarter",null,"N",4]
["<DisasterRelief></DisasterRelief>","DisasterRelief",{"$f":"IF('Report Information'!W7<>\"\",'Report Information'!W7,\"\")","v":""},"N",4]
["<ISPNumber></ISPNumber>","ISPNumber",null,"N",4]
["<PaidPreparerInformation>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+30),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},4]
["<DateSigned></DateSigned>","DateSigned",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},5]
["<SelfEmployed></SelfEmployed>","SelfEmployed",{"$f":"IF('Report Information'!Q23=TRUE,\"X\",\"\")","v":""},"N",5]
["<SSN></SSN>","SSN",{"$f":"IF('Report Information'!Q10<>\"\",SUBSTITUTE('Report Information'!Q10,\"-\",\"\"),\"\")","v":""},"N",5,{"$f":"IF(C33<>\"\",IF(ISERR(INT(C33)),1,IF(C33-INT(C33)>0,1,\"\")),\"\")","v":""},{"$f":"IF(D30=\"Y\",IF(COUNTIF(D33:D35,\"Y\")<1,1,\"\"),\"\")","v":""},"Int"]
["<PTIN></PTIN>","PTIN",null,"N",5,null,{"$f":"IF(D30=\"Y\",IF(COUNTIF(D33:D35,\"Y\")<1,1,\"\"),\"\")","v":""}]
["<StateID></StateID>","StateID",{"$f":"IF('Report Information'!Q11<>\"\",'Report Information'!Q11,\"\")","v":""},"N",5,null,{"$f":"IF(D30=\"Y\",IF(COUNTIF(D33:D35,\"Y\")<1,1,\"\"),\"\")","v":""}]
["<PreparerFirmIDNumber></PreparerFirmIDNumber>","PreparerFirmIDNumber",{"$f":"IF('Report Information'!Q12<>\"\",'Report Information'!Q12,\"\")","v":""},"N",5,null,{"$f":"IF(D30=\"Y\",IF(COUNTA(C36:C37)<1,1,\"\"),\"\")","v":""}]
["<StateEIN></StateEIN>","StateEIN",null,"N",5,null,{"$f":"IF(D30=\"Y\",IF(COUNTA(C36:C37)<1,1,\"\"),\"\")","v":""}]
["<PreparerBusinessName>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+2),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},5]
["<BusinessNameLine1></BusinessNameLine1>","BusinessNameLine1",{"$f":"IF('Report Information'!Q2<>\"\",remsym('Report Information'!Q2),\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6,null,{"$f":"IF(AND(D40=\"Y\",D39=\"N\"),1,\"\")","v":""}]
["<BusinessNameLine2></BusinessNameLine2>","BusinessNameLine2",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6]
["</PreparerBusinessName>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-2),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},5]
["<PreparerPersonName></PreparerPersonName>","PreparerPersonName",{"$f":"IF('Report Information'!Q3<>\"\",'Report Information'!Q3,\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},5,null,{"$f":"IF(AND(D30=\"Y\",D42=\"N\"),1,\"\")","v":""}]
["<PreparerUSAddress>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+5),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},5]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<AddressLine1></AddressLine1>"},"AddressLine1",{"$f":"IF('Report Information'!Q4<>\"\",remsym('Report Information'!Q4),\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6,null,{"$f":"IF(AND(D30=\"Y\",D43=\"Y\",D44=\"N\"),1,\"\")","v":""}]
["<AddressLine2></AddressLine2>","AddressLine2",{"$f":"IF('Report Information'!Q5<>\"\",remsym('Report Information'!Q5),\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6]
["<City></City>","City",{"$f":"IF('Report Information'!Q6<>\"\",'Report Information'!Q6,\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6,null,{"$f":"IF(AND(D30=\"Y\",D43=\"Y\",D46=\"N\"),1,\"\")","v":""}]
["<State></State>","State",{"$f":"IF('Report Information'!Q7<>\"\",'Report Information'!Q7,\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6,null,{"$f":"IF(AND(D30=\"Y\",D43=\"Y\",D47=\"N\"),1,\"\")","v":""}]
["<ZIPCode></ZIPCode>","ZIPCode",{"$f":"IF('Report Information'!Q8<>\"\",'Report Information'!Q8,\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6,{"$f":"IF(C48<>\"\",IF(ISERR(INT(C48)),1,IF(C48-INT(C48)>0,1,\"\")),\"\")","v":""},{"$f":"IF(AND(D30=\"Y\",D43=\"Y\",D48=\"N\"),1,\"\")","v":""},"Int"]
["</PreparerUSAddress>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-5),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},5]
["<PreparerForeignAddress>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+6),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},5]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<AddressLine1></AddressLine1>"},"AddressLine1",{"$f":"IF('Report Information'!Q14<>\"\",remsym('Report Information'!Q14),\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6,null,{"$f":"IF(AND(D30=\"Y\",D50=\"Y\",D51=\"N\"),1,\"\")","v":""}]
["<AddressLine2></AddressLine2>","AddressLine2",{"$f":"IF('Report Information'!Q15<>\"\",remsym('Report Information'!Q15),\"\")","v":""},"N",6]
["<City></City>","City",{"$f":"IF('Report Information'!Q16<>\"\",'Report Information'!Q16,\"\")","v":""},"N",6,null,{"$f":"IF(AND(D30=\"Y\",D50=\"Y\",D53=\"N\"),1,\"\")","v":""}]
["<ProvinceOrState></ProvinceOrState>","ProvinceOrState",{"$f":"IF('Report Information'!Q17<>\"\",'Report Information'!Q17,\"\")","v":""},"N",6]
["<Country></Country>","Country",{"$f":"IF('Report Information'!Q18<>\"\",'Report Information'!Q18,\"\")","v":""},"N",6,null,{"$f":"IF(AND(D30=\"Y\",D50=\"Y\",D55=\"N\"),1,\"\")","v":""}]
["<PostalCode></PostalCode>","PostalCode",{"$f":"IF('Report Information'!Q19<>\"\",'Report Information'!Q19,\"\")","v":""},"N",6]
["</PreparerForeignAddress>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-6),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},5]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<Phone></Phone>"},"Phone",{"$f":"IF('Report Information'!Q13<>\"\",SUBSTITUTE('Report Information'!Q13,\"-\",\"\"),\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},5,{"$f":"IF(C58<>\"\",IF(ISERR(INT(C58)),1,IF(C58-INT(C58)>0,1,\"\")),\"\")","v":""},{"$f":"IF(AND(D30=\"Y\",D58=\"N\",D59=\"N\"),1,\"\")","v":""},"Int"]
["<ForeignPhone></ForeignPhone>","ForeignPhone",{"$f":"IF('Report Information'!Q20<>\"\",'Report Information'!Q20,\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},5]
["<EmailAddress></EmailAddress>","EmailAddress",{"$f":"IF('Report Information'!Q9<>\"\",'Report Information'!Q9,\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},5,null,{"$f":"IF(AND(D30=\"Y\",D60=\"N\"),1,\"\")","v":""}]
["</PaidPreparerInformation>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-30),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},4]
["<Originator>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+8),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},4,null,{"$f":"IF(COUNT(G63:G65)>0,1,\"\")","v":""}]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<EFIN></EFIN>"},"EFIN",{"$f":"IF('Report Information'!U8<>\"\",'Report Information'!U8,\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},5,{"$f":"IF(C63<>\"\",IF(ISERR(INT(C63)),1,IF(C63-INT(C63)>0,1,\"\")),\"\")","v":""},{"$f":"IF(AND(D63=\"N\",D65=\"Y\"),1,\"\")","v":""},"Int"]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<AgentIdentifier></AgentIdentifier>"},"AgentIdentifier",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},5]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<OriginatorTypeCd></OriginatorTypeCd>"},"OriginatorTypeCd",{"$f":"IF('Report Information'!U9<>\"\",'Report Information'!U9,\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},5,null,{"$f":"IF(AND(D65=\"N\",D63=\"Y\"),1,\"\")","v":""}]
["<PractitionerPIN>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+3),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},5]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<EFIN></EFIN>"},"EFIN",{"$f":"IF('Report Information'!U10<>\"\",'Report Information'!U10,\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6,{"$f":"IF(C67<>\"\",IF(ISERR(INT(C67)),1,IF(C67-INT(C67)>0,1,\"\")),\"\")","v":""}]
["<PIN></PIN>","PIN",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6]
["<ReportingAgentSignature></ReportingAgentSignature>","ReportingAgentSignature",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6]
["</PractitionerPIN>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-3),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},5]
["</Originator>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-8),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},4]
["<SoftwareId>NE_CIGXML</SoftwareId>","SoftwareId",{"$f":"IF('Report Information'!AF1<>\"\",'Report Information'!AF1,\"\")","v":"NE_CIGXML"},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"Y"},4]
["<SoftwareVersion>Ver. 1.0t</SoftwareVersion>","SoftwareVersion",{"$f":"IF('Report Information'!AF2<>\"\",'Report Information'!AF2,\"\")","v":"Ver. 1.0t"},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"Y"},4]
["<InternetProtocol>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+2),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},4,null,{"$f":"IF(COUNTA(C75:C76)=1,1,\"\")","v":""}]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<IPAddress></IPAddress>"},"IPAddress",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},5]
["<IPTimestamp></IPTimestamp>","IPTimestamp",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},5]
["</InternetProtocol>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-2),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},4]
["<SignatureOption>",null,null,{"$f":"IF(COUNTA(INDIRECT(\"C\"&ROW()&\":C\"&ROW()+9))>0,\"Y\",\"N\")","v":"N"},4]
["<SignatureDocument>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+2),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},5]
["<Value></Value>","Value",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6]
["<referenceDocumentId></referenceDocumentId>","referenceDocumentId",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6]
["</SignatureDocument>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-2),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},5]
["<SignaturePIN>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+3),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},5]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<Signature></Signature>"},"Signature",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<PrimaryPINEnteredBy></PrimaryPINEnteredBy>"},"PrimaryPINEnteredBy",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<SecondaryPINEnteredBy></SecondaryPINEnteredBy>"},"SecondaryPINEnteredBy",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6]
["</SignaturePIN>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-3),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},5]
["</SignatureOption>",null,null,{"$f":"IF(COUNTA(INDIRECT(\"C\"&ROW()&\":C\"&ROW()-9))>0,\"Y\",\"N\")","v":"N"},4]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<AmendedReturnIndicator></AmendedReturnIndicator>"},"AmendedReturnIndicator",{"$f":"'Report Information'!W10","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<OriginalSubmissionId></OriginalSubmissionId>"},"OriginalSubmissionId",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",TEXT(INDIRECT(\"C\"&ROW()),\"yyyy-mm-dd\"),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<OriginalSubmissionDate>1900-01-00</OriginalSubmissionDate>"},"OriginalSubmissionDate",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<ReturnType></ReturnType>"},"ReturnType",{"$f":"IF('Report Information'!W4<>\"\",'Report Information'!W4,\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4,null,{"$f":"IF(INDIRECT(\"C\"&ROW())=\"\",1,\"\")","v":1}]
["<Filer>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+23),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"Y"},4]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<EIN></EIN>"},"EIN",{"$f":"IF('Report Information'!S9<>\"\",'Report Information'!S9,\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},5,{"$f":"IF(C94<>\"\",IF(LEN(C94)=9,IF(ISERR(INT(C94)),1,IF(C94-INT(C94)>0,1,\"\")),1),\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())=\"\",1,\"\")","v":1},"Int"]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<StateEIN>0</StateEIN>"},"StateEIN",{"$f":"IF(ISERR('Report Information'!S10*1),\"\",'Report Information'!S10*1)","v":0},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"Y"},5,{"$f":"IF(C95<>\"\",IF(ISERR(INT(C95)),1,IF(C95-INT(C95)>0,1,\"\")),\"\")","v":""},{"$f":"IF(OR(INDIRECT(\"C\"&ROW())=\"\",INDIRECT(\"C\"&ROW())=0),1,\"\")","v":1},"Int"]
["<Name>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+2),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},5]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<BusinessNameLine1></BusinessNameLine1>"},"BusinessNameLine1",{"$f":"IF('Report Information'!S2<>\"\",rem_espace('Report Information'!S2),\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6,null,{"$f":"IF(INDIRECT(\"C\"&ROW())=\"\",1,\"\")","v":1}]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<BusisnessNameLine2></BusisnessNameLine2>"},"BusisnessNameLine2",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6]
["</Name>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-2),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},5]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<InCareOfName></InCareOfName>"},"InCareOfName",{"$f":"IF('Report Information'!S3<>\"\",rem_espace(CONCATENATE(\"% \",SUBSTITUTE('Report Information'!S3,\"%\",\"\"))),\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},5]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<NameControl></NameControl>"},"NameControl",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},5]
["<USAddress>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+5),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},5]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<AddressLine1></AddressLine1>"},"AddressLine1",{"$f":"IF('Report Information'!S4<>\"\",remsym('Report Information'!S4),\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6,null,{"$f":"IF(AND(D103=\"N\",D110=\"N\"),1,\"\")","v":1}]
["<AddressLine2></AddressLine2>","AddressLine2",{"$f":"IF('Report Information'!S5<>\"\",remsym('Report Information'!S5),\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6]
["<City></City>","City",{"$f":"IF('Report Information'!S6<>\"\",'Report Information'!S6,\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6,null,{"$f":"IF(AND(D105=\"N\",D109=\"N\"),1,\"\")","v":1}]
["<State></State>","State",{"$f":"IF('Report Information'!S7<>\"\",'Report Information'!S7,\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6,null,{"$f":"IF(AND(D106=\"N\",D110=\"N\"),1,\"\")","v":1}]
["<ZIPCode></ZIPCode>","ZIPCode",{"$f":"IF('Report Information'!S8<>\"\",'Report Information'!S8,\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6,{"$f":"IF(C107<>\"\",IF(ISERR(INT(C107)),1,IF(C107-INT(C107)>0,1,\"\")),\"\")","v":""},{"$f":"IF(AND(D107=\"N\",D110=\"N\"),1,\"\")","v":1},"Int"]
["</USAddress>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-5),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},5]
["<ForeignAddress>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+6),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},5]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<AddressLine1></AddressLine1>"},"AddressLine1",{"$f":"IF('Report Information'!S19<>\"\",remsym('Report Information'!S19),\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6,null,{"$f":"IF(AND(D103=\"N\",D110=\"N\"),1,\"\")","v":1}]
["<AddressLine2></AddressLine2>","AddressLine2",{"$f":"IF('Report Information'!S20<>\"\",remsym('Report Information'!S20),\"\")","v":""},"N",6]
["<City></City>","City",{"$f":"IF('Report Information'!S21<>\"\",'Report Information'!S21,\"\")","v":""},"N",6]
["<ProvinceOrState></ProvinceOrState>","ProvinceOrState",{"$f":"IF('Report Information'!S22<>\"\",'Report Information'!S22,\"\")","v":""},"N",6]
["<Country></Country>","Country",{"$f":"IF('Report Information'!S23<>\"\",'Report Information'!S23,\"\")","v":""},"N",6,null,{"$f":"IF(AND(D103=\"N\",D114=\"N\"),1,\"\")","v":1}]
["<PostalCode></PostalCode>","PostalCode",{"$f":"IF('Report Information'!S24<>\"\",'Report Information'!S24,\"\")","v":""},"N",6]
["</ForeignAddress>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-6),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},5]
["</Filer>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-23),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"Y"},4]
["<BusinessRepresentative>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+12),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},4]
["<Name>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+4),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},5]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<FirstName></FirstName>"},"FirstName",{"$f":"IF('Report Information'!S11<>\"\",rem_espace('Report Information'!S11),\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6,null,{"$f":"IF(INDIRECT(\"C\"&ROW())=\"\",1,\"\")","v":1}]
["<MiddleInitial></MiddleInitial>","MiddleInitial",{"$f":"IF('Report Information'!S12<>\"\",rem_espace('Report Information'!S12),\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6]
["<LastName></LastName>","LastName",{"$f":"IF('Report Information'!S13<>\"\",rem_espace('Report Information'!S13),\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6,null,{"$f":"IF(INDIRECT(\"C\"&ROW())=\"\",1,\"\")","v":1}]
["<NameSuffix></NameSuffix>","NameSuffix",{"$f":"IF('Report Information'!S14<>\"\",'Report Information'!S14,\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},6]
["</Name>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-4),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},5]
["<Title></Title>","Title",{"$f":"IF('Report Information'!S15<>\"\",rem_espace('Report Information'!S15),\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},5,null,{"$f":"IF(INDIRECT(\"C\"&ROW())=\"\",1,\"\")","v":1}]
["<TaxpayerPIN></TaxpayerPIN>","TaxpayerPIN",null,"N",5]
["<Phone></Phone>","Phone",{"$f":"IF('Report Information'!S17<>\"\",SUBSTITUTE('Report Information'!S17,\"-\",\"\"),\"\")","v":""},"N",5,null,{"$f":"IF(AND(D127=\"N\",D128=\"N\"),1,\"\")","v":1}]
["<ForeignPhone></ForeignPhone>","ForeignPhone",{"$f":"IF('Report Information'!S25<>\"\",'Report Information'!S25,\"\")","v":""},"N",5,null,{"$f":"IF(AND(D127=\"N\",D128=\"N\"),1,\"\")","v":1}]
["<EmailAddress></EmailAddress>","EmailAddress",{"$f":"IF('Report Information'!S16<>\"\",'Report Information'!S16,\"\")","v":""},"N",5]
["<DateSigned></DateSigned>","DateSigned",null,"N",5]
["</BusinessRepresentative>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-12),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},4]
["</ReturnHeaderState>",null,null,"Y",3]
["<ReturnDataState>",null,null,"Y",3]
["</ReturnDataState>",null,null,"Y",3]
["</ReturnState>",null,null,"Y",2]
["</Transmission>",null,null,"Y",1]

{"sheet":"Financial_Info_Template","index":2,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["XML Code","Tag","Data","Display Line","Indent","Syntax Validate","Required Validate"]
["<FinancialTransaction>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+11),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},1]
["<StatePayment>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+9),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},2]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<Checking></Checking>"},"Checking",{"$f":"'Report Information'!AH10","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},3,null,{"$f":"IF(AND(D2=\"Y\",D4=\"N\",D5=\"N\"),1,\"\")","v":""}]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<Savings></Savings>"},"Savings",{"$f":"'Report Information'!AH11","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},3,null,{"$f":"IF(AND(D2=\"Y\",D4=\"N\",D5=\"N\"),1,\"\")","v":""}]
["<RoutingTransitNumber></RoutingTransitNumber>","RoutingTransitNumber",{"$f":"IF('Report Information'!AH3<>\"\",'Report Information'!AH3,\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},3,null,{"$f":"IF(AND(D2=\"Y\",D6=\"N\"),1,\"\")","v":""}]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<BankAccountNumber></BankAccountNumber>"},"BankAccountNumber",{"$f":"IF('Report Information'!AH4<>\"\",'Report Information'!AH4,\"\")","v":""},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},3,null,{"$f":"IF(AND(D2=\"Y\",D7=\"N\"),1,\"\")","v":""}]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",TEXT(INDIRECT(\"C\"&ROW()),\"0.00\"),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<PaymentAmount></PaymentAmount>"},"PaymentAmount",{"$f":"IF('Report Information'!AH5<>\"\",'Report Information'!AH5,\"\")","v":""},"N",3,null,{"$f":"IF(AND(D2=\"Y\",D8=\"N\"),1,\"\")","v":""}]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<IdentificationNumber></IdentificationNumber>"},"IdentificationNumber",{"$f":"IF('Report Information'!AH6<>\"\",'Report Information'!AH6,\"\")","v":""},"N",3,null,{"$f":"IF(AND(D2=\"Y\",D9=\"N\"),1,\"\")","v":""}]
["<AccountHolderName></AccountHolderName>","AccountHolderName",{"$f":"IF('Report Information'!AH7<>\"\",'Report Information'!AH7,\"\")","v":""},"N",3]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",TEXT(INDIRECT(\"C\"&ROW()),\"0\"),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<AccountHolderType></AccountHolderType>"},"AccountHolderType",{"$f":"IF('Report Information'!AH12<>\"\",'Report Information'!AH12,\"\")","v":""},"N",3,null,{"$f":"IF(AND(D2=\"Y\",D11=\"N\"),1,\"\")","v":""}]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",TEXT(INDIRECT(\"C\"&ROW()),\"yyyy-mm-dd\"),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<RequestedPaymentDate></RequestedPaymentDate>"},"RequestedPaymentDate",{"$f":"IF('Report Information'!AH9<>\"\",'Report Information'!AH9,\"\")","v":""},"N",3,null,{"$f":"IF(AND(D2=\"Y\",D12=\"N\"),1,\"\")","v":""}]
["</StatePayment>",null,null,{"$f":"INDIRECT(\"D\"&ROW()-10)","v":"N"},2]
["</FinancialTransaction>",null,null,{"$f":"INDIRECT(\"D\"&ROW()-12)","v":"N"},1]

{"sheet":"Sch1 Entry","index":3,"n_rows":51,"n_cols":47,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Show Foreign Fields:",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Available Rows:  ",{"$f":"COUNTA(Sch1_Table[[#All],[Column41]])","v":41}]
[]
[]
[]
[]
[]
[]
[null,"Type Of Cigarette Schedule","Invoice Date","Invoice Number","Name","Address Line 1","Address Line 2","City","State","ZIP Code","In Care Of Name","Sale to                                       Fed Govt","EIN","Price","Tax       Juris","UPC Number","Manufacturer","Brand Family","Total Cigarettes","Deliverer Name"," Deliverer                                       Address Line 1"," Deliverer                                       Address Line 2"," Deliverer                                       City","Del   State","Del             Zip Code","Deliverer                                        In Care Of Name","Deliverer                                        Phone","(f) Deliverer                                       Address Line 1","(f) Deliverer                                       Address Line 2","(f) Deliverer                                       City","(f) Deliverer ProvinceOrState","(f) Del                 Country","(f) Del              PostalCode","(f) InCareOfName","(f) Name                        AddressLine1","(f) Name                           AddressLine2","(f) Name                                             City","(f) Name ProvinceOrState","(f) Name                            Country","(f) Name PostalCode","(f) Name                     InCareOfName","Req Field  Validation","Req DelivererField  Validation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column1]:[Column40]])>0,\"Yes\",\"No\")","v":"No"},{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Sch1_Table[[#This Row],[Column19]:[Column40]])>0,\"Yes\",\"No\")","v":"Yes"}]

{"sheet":"Sch1_Data","index":4,"n_rows":3,"n_cols":63,"rows_kept":3,"cut":false,"hidden":true,"merged":[[1,29,1,38]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Repeating"]
["Line Type:","<SchI>","<InvoiceHeader>","TypeOfCigSchI","InvoiceDate","InvoiceNumber","Name","<Address>","<USAddress>","AddressLine1","AddressLine2","City","State","ZIPCode","InCareOfName","</USAddress>","<ForeignAddress>","(f) AddressLine1","(f) AddressLine2","(f) City","(f) ProvinceOrState","(f) Country","(f) PostalCode","(f) InCareOfName","</ForeignAddress>","</Address>","SaletoFederalGovt","EIN","</InvoiceHeader>","<InvoiceDetail>","Price","<BrandDetail>","TaxJuristion","UPCNumber","Manufacturer","BrandFamily","TotalCigarettes","</BrandDetail>","</InvoiceDetail>","<Deliverer>","DelivererName","<DelivererAddress>","<USAddress>","AddressLine1","AddressLine2","City","State","ZIPCode","InCareOfName","</USAddress>","<ForeignAddress>","(f) AddressLine1","(f) AddressLine2","(f) City","(f) ProvinceOrState","(f) Country","(f) PostalCode","(f) InCareOfName","</ForeignAddress>","</DelivererAddress>","DelivererPhone","</Deliverer>","</SchI>"]

{"sheet":"Sch1_Template","index":5,"n_rows":63,"n_cols":8,"rows_kept":63,"cut":false,"hidden":true,"merged":[]}
["XML Code","Tag","Data","Display Line","Indent",null,"#Invoice:",{"$f":"SUM(COUNTIF(Sch1_Data!A:A,\"Beg\"),COUNTIF(Sch1_Data!A:A,\"Single\"))","v":0}]
["<SchI>",null,null,"Y",1]
["<InvoiceHeader>",null,null,{"$f":"IF(COUNTA(INDIRECT(\"C\"&ROW()&\":C\"&ROW()+26))>0,\"Y\",\"N\")","v":"N"},2]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<TypeOfCigSchI></TypeOfCigSchI>"},"TypeOfCigSchI",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},3]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",TEXT(INDIRECT(\"C\"&ROW()),\"YYYY-MM-DD\"),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<InvoiceDate>1900-01-00</InvoiceDate>"},"InvoiceDate",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},3]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<InvoiceNumber></InvoiceNumber>"},"InvoiceNumber",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},3]
["<Name></Name>","Name",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},3]
["<Address>",null,null,{"$f":"IF(COUNTA(INDIRECT(\"C\"&ROW()&\":C\"&ROW()+18))>0,\"Y\",\"N\")","v":"N"},3]
["<USAddress>",null,null,{"$f":"IF(COUNTA(INDIRECT(\"C\"&ROW()&\":C\"&ROW()+7))>0,\"Y\",\"N\")","v":"N"},4]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<AddressLine1></AddressLine1>"},"AddressLine1",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},5]
["<AddressLine2></AddressLine2>","AddressLine2",null,"N",5]
["<City></City>","City",null,"N",5]
["<State></State>","State",null,"N",5]
["<ZIPCode></ZIPCode>","ZIPCode",null,"N",5]
["<InCareOfName></InCareOfName>","InCareOfName",null,"N",5]
["</USAddress>",null,null,{"$f":"INDIRECT(\"D\"&ROW()-7)","v":"N"},4]
["<ForeignAddress>",null,null,{"$f":"IF(COUNTA(INDIRECT(\"C\"&ROW()&\":C\"&ROW()+8))>0,\"Y\",\"N\")","v":"N"},4]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<AddressLine1></AddressLine1>"},"AddressLine1",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},5]
["<AddressLine2></AddressLine2>","AddressLine2",null,"N",5]
["<City></City>","City",null,"N",5]
["<ProvinceOrState></ProvinceOrState>","ProvinceOrState",null,"N",5]
["<Country></Country>","Country",null,"N",5]
["<PostalCode></PostalCode>","PostalCode",null,"N",5]
["<InCareOfName></InCareOfName>","InCareOfName",null,"N",5]
["</ForeignAddress>",null,null,{"$f":"INDIRECT(\"D\"&ROW()-8)","v":"N"},4]
["</Address>",null,null,{"$f":"INDIRECT(\"D\"&ROW()-18)","v":"N"},3]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<SaletoFederalGovt></SaletoFederalGovt>"},"SaletoFederalGovt",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},3]
["<EIN></EIN>","EIN",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},3]
["</InvoiceHeader>",null,null,{"$f":"INDIRECT(\"D\"&ROW()-26)","v":"N"},2]
["<InvoiceDetail>",null,null,{"$f":"IF(COUNTA(INDIRECT(\"C\"&ROW()&\":C\"&ROW()+9))>0,\"Y\",\"N\")","v":"N"},2]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<Price></Price>"},"Price",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},3]
["<BrandDetail>",null,null,{"$f":"IF(COUNTA(INDIRECT(\"C\"&ROW()&\":C\"&ROW()+6))>0,\"Y\",\"N\")","v":"N"},3]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<TaxJurisdiction></TaxJurisdiction>"},"TaxJurisdiction",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
["<UPCNumber></UPCNumber>","UPCNumber",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
["<Manufacturer></Manufacturer>","Manufacturer",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
["<BrandFamily></BrandFamily>","BrandFamily",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
["<TotalCigarettes></TotalCigarettes>","TotalCigarettes",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
["</BrandDetail>",null,null,{"$f":"INDIRECT(\"D\"&ROW()-6)","v":"N"},3]
["</InvoiceDetail>",null,null,{"$f":"INDIRECT(\"D\"&ROW()-9)","v":"N"},2]
["<Deliverer>",null,null,{"$f":"IF(COUNTA(INDIRECT(\"C\"&ROW()&\":C\"&ROW()+22))>0,\"Y\",\"N\")","v":"N"},2]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<DelivererName></DelivererName>"},"DelivererName",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},3]
["<DelivererAddress>",null,null,{"$f":"IF(COUNTA(INDIRECT(\"C\"&ROW()&\":C\"&ROW()+18))>0,\"Y\",\"N\")","v":"N"},3]
["<USAddress>",null,null,{"$f":"IF(COUNTA(INDIRECT(\"C\"&ROW()&\":C\"&ROW()+7))>0,\"Y\",\"N\")","v":"N"},4]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<AddressLine1></AddressLine1>"},"AddressLine1",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},5]
["<AddressLine2></AddressLine2>","AddressLine2",null,"N",5]
["<City></City>","City",null,"N",5]
["<State></State>","State",null,"N",5]
["<ZIPCode></ZIPCode>","ZIPCode",null,"N",5]
["<InCareOfName></InCareOfName>","InCareOfName",null,"N",5]
["</USAddress>",null,null,{"$f":"INDIRECT(\"D\"&ROW()-7)","v":"N"},4]
["<ForeignAddress>",null,null,{"$f":"IF(COUNTA(INDIRECT(\"C\"&ROW()&\":C\"&ROW()+8))>0,\"Y\",\"N\")","v":"N"},4]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<AddressLine1></AddressLine1>"},"AddressLine1",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},5]
["<AddressLine2></AddressLine2>","AddressLine2",null,"N",5]
["<City></City>","City",null,"N",5]
["<ProvinceOrState></ProvinceOrState>","ProvinceOrState",null,"N",5]
["<Country></Country>","Country",null,"N",5]
["<PostalCode></PostalCode>","PostalCode",null,"N",5]
["<InCareOfName></InCareOfName>","InCareOfName",null,"N",5]
["</ForeignAddress>",null,null,{"$f":"INDIRECT(\"D\"&ROW()-8)","v":"N"},4]
["</DelivererAddress>",null,null,{"$f":"INDIRECT(\"D\"&ROW()-18)","v":"N"},4]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<DelivererPhone></DelivererPhone>"},"DelivererPhone",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},3]
["</Deliverer>",null,null,{"$f":"INDIRECT(\"D\"&ROW()-22)","v":"N"},2]
["</SchI>",null,null,"Y",1]

{"sheet":"Sch1_Assembly","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sch1_No_Trans","index":7,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["XML Code","Tag","Data","Display Line","Indent"]
["<SchI>",null,null,"Y",1]
["<NoTransactions>X</NoTransactions>",null,null,"Y"]
["</SchI>",null,null,"Y",1]

{"sheet":"Sch2 Entry","index":8,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[27,1,27,2],[8,3,8,5],[32,1,32,2],[10,1,10,2],[11,1,11,2],[28,1,28,2],[29,1,29,2]]}
[]
[]
[]
[null,null,null,null,null,"`"]
[]
[]
[]
[]
[null,null,null,"Stamp Denominations (number of stamps)"]
[null,null,null,"Packs of 20","Packs of 25","Gross Value ","Req Field Validation"]
[null,"Beginning Inventory (Last month Ending Inventory):",null,null,null,{"$f":"SUM((INDIRECT(\"D\"&ROW())*0.64),(INDIRECT(\"E\"&ROW())*0.8))","v":0},{"$f":"IF(COUNTA(D11:E11)>0,\"Yes\",\"No\")","v":"No"}]
[null,"Purchases"]
[null,"Date Received","Purchase Order Number","Packs of 20","Packs of 25"]
[null,null,null,null,null,{"$f":"IF((INDIRECT(\"D\"&ROW())*0.64)+(INDIRECT(\"E\"&ROW())*0.8)>0,(INDIRECT(\"D\"&ROW())*0.64)+(INDIRECT(\"E\"&ROW())*0.8),\"\")","v":""},{"$f":"IF(COUNTA(Table1[[#This Row],[Column1]:[Column4]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,{"$f":"IF((INDIRECT(\"D\"&ROW())*0.64)+(INDIRECT(\"E\"&ROW())*0.8)>0,(INDIRECT(\"D\"&ROW())*0.64)+(INDIRECT(\"E\"&ROW())*0.8),\"\")","v":""},{"$f":"IF(COUNTA(Table1[[#This Row],[Column1]:[Column4]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,"",{"$f":"IF(COUNTA(Table1[[#This Row],[Column1]:[Column4]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,"",{"$f":"IF(COUNTA(Table1[[#This Row],[Column1]:[Column4]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,"",{"$f":"IF(COUNTA(Table1[[#This Row],[Column1]:[Column4]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,"",{"$f":"IF(COUNTA(Table1[[#This Row],[Column1]:[Column4]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,"",{"$f":"IF(COUNTA(Table1[[#This Row],[Column1]:[Column4]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,"",{"$f":"IF(COUNTA(Table1[[#This Row],[Column1]:[Column4]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,"",{"$f":"IF(COUNTA(Table1[[#This Row],[Column1]:[Column4]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,"",{"$f":"IF(COUNTA(Table1[[#This Row],[Column1]:[Column4]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,"",{"$f":"IF(COUNTA(Table1[[#This Row],[Column1]:[Column4]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,"",{"$f":"IF(COUNTA(Table1[[#This Row],[Column1]:[Column4]])>0,\"Yes\",\"No\")","v":"No"}]
[null,{"$f":"\"\"","v":""},null,null,"Total Purchases:",{"$f":"SUM(Table1[[#All],[Column5]])","v":0}]
[null,"                                                         Returns "]
[null,"Explanation of Returned Stamps",null,"Packs of 20","Packs of 25","Gross Value "]
[null,null,null,null,null,{"$f":"IF((INDIRECT(\"D\"&ROW())*0.64)+(INDIRECT(\"E\"&ROW())*0.8)>0,(INDIRECT(\"D\"&ROW())*0.64)+(INDIRECT(\"E\"&ROW())*0.8),\"\")","v":""},{"$f":"IF(COUNTA(B29:E29)>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,"",{"$f":"IF(COUNTA(B30:E30)>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,"Total Returns:",{"$f":"SUM('Sch2 Entry'!$F$29:$F$30)","v":0}]
[]
[null,"Ending Inventory:",null,null,null,{"$f":"(INDIRECT(\"D\"&ROW())*0.64)+(INDIRECT(\"E\"&ROW())*0.8)","v":0}]

{"sheet":"Sch2_Template","index":9,"n_rows":46,"n_cols":5,"rows_kept":46,"cut":false,"hidden":true,"merged":[]}
["XML Code","Tag","Data","Display Line","Indent"]
["<SchII>",null,null,"Y",1]
["<BeginningInventory>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+7),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"Y"},2]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<StampsforPacksof20>0</StampsforPacksof20>"},"StampsforPacksof20",{"$f":"'Sch2 Entry'!D11","v":0},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"Y"},3]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<StampsforPacksof25>0</StampsforPacksof25>"},"StampsforPacksof25",{"$f":"'Sch2 Entry'!E11","v":0},"Y",3]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<TribalStampsforPacksof20></TribalStampsforPacksof20>"},"TribalStampsforPacksof20",null,"N",3]
["<TribalStampsforPacksof25></TribalStampsforPacksof25>","TribalStampsforPacksof25",null,"N",3]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",TEXT(INDIRECT(\"C\"&ROW()),\"0.00\"),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<GrossValue>0.00</GrossValue>"},"GrossValue",{"$f":"IF('Sch2 Entry'!F11<>0,'Sch2 Entry'!F11,\"0\")","v":"0"},"Y",3]
["<PrintingCharges></PrintingCharges>","PrintingCharges",null,"N",3]
["<ShippingCharges></ShippingCharges>","ShippingCharges",null,"N",3]
["</BeginningInventory>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-7),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"Y"},2]
["<StampsPurchfromtheDepartment>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+11),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"Y"},2]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",TEXT(INDIRECT(\"C\"&ROW()),\"YYYY-MM-DD\"),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<DateReceived>1900-01-00</DateReceived>"},"DateReceived",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},3]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<PurchaseOrderNumber></PurchaseOrderNumber>"},"PurchaseOrderNumber",null,"N",3]
["<StampsPurchased>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+7),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"Y"},3]
["<StampsforPacksof20></StampsforPacksof20>","StampsforPacksof20",null,"N",4]
["<StampsforPacksof25></StampsforPacksof25>","StampsforPacksof25",null,"N",4]
["<TribalStampsforPacksof20></TribalStampsforPacksof20>","TribalStampsforPacksof20",null,"N",4]
["<TribalStampsforPacksof25></TribalStampsforPacksof25>","TribalStampsforPacksof25",null,"N",4]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",TEXT(INDIRECT(\"C\"&ROW()),\"0.00\"),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<GrossValue>0.00</GrossValue>"},"GrossValue",null,"Y",4]
["<PrintingCharges></PrintingCharges>","PrintingCharges",null,"N",4]
["<ShippingCharges></ShippingCharges>","ShippingCharges",null,"N",4]
["</StampsPurchased>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-7),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"Y"},3]
["</StampsPurchfromtheDepartment>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-11),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"Y"},2]
["<StampsRetdtotheDepartment>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+10),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},2]
["<StampsReturnedtoDept>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+7),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},3]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<StampsforPacksof20></StampsforPacksof20>"},"StampsforPacksof20",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
["<StampsforPacksof25></StampsforPacksof25>","StampsforPacksof25",null,"N",4]
["<TribalStampsforPacksof20></TribalStampsforPacksof20>","TribalStampsforPacksof20",null,"N",4]
["<TribalStampsforPacksof25></TribalStampsforPacksof25>","TribalStampsforPacksof25",null,"N",4]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",TEXT(INDIRECT(\"C\"&ROW()),\"0.00\"),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<GrossValue>0.00</GrossValue>"},"GrossValue",null,"N",4]
["<PrintingCharges></PrintingCharges>","PrintingCharges",null,"N",4]
["<ShippingCharges></ShippingCharges>","ShippingCharges",null,"N",4]
["</StampsReturnedtoDept>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-7),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},3]
["<ExplanationofStampsRetd></ExplanationofStampsRetd>","ExplanationofStampsRetd",null,"N",3]
["</StampsRetdtotheDepartment>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-10),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},2]
["<EndingInventory>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+7),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},2]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<StampsforPacksof20></StampsforPacksof20>"},"StampsforPacksof20",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},3]
["<StampsforPacksof25></StampsforPacksof25>","StampsforPacksof25",null,"N",3]
["<TribalStampsforPacksof20></TribalStampsforPacksof20>","TribalStampsforPacksof20",null,"N",3]
["<TribalStampsforPacksof25></TribalStampsforPacksof25>","TribalStampsforPacksof25",null,"N",3]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",TEXT(INDIRECT(\"C\"&ROW()),\"0.00\"),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<GrossValue>0.00</GrossValue>"},"GrossValue",null,"N",3]
["<PrintingCharges></PrintingCharges>","PrintingCharges",null,"N",3]
["<ShippingCharges></ShippingCharges>","ShippingCharges",null,"N",3]
["</EndingInventory>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-7),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},2]
["</SchII>",null,null,"Y",1]

{"sheet":"Sch2_Assembly","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sch3 Entry","index":11,"n_rows":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,{"$f":"COUNTA(Table2[[#All],[Column7]])","v":16}]
[null,null,null,null,null,null,null,null,{"$f":"COUNTA(Table3[[#All],[Column7]])","v":10}]
[null,null,null,null,null,null,null,null,{"$f":"COUNTA(Table4[[#All],[Column7]])","v":16}]
[]
[]
[]
[]
[]
[null,"Beginning Inventory"]
[null,"Tax Jurisdiction","UPC Number","Manufacturer","Brand Family","Total Cigarettes"]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table2[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table2[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table2[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table2[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table2[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table2[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table2[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table2[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table2[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table2[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table2[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table2[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table2[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table2[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table2[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table2[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,"Total:",{"$f":"SUM(Table2[[#All],[Column5]])","v":0}]
[]
[null,"Adjustments to Inventory"]
[null,"Tax Jurisdiction","UPC Number","Manufacturer","Brand Family","Total Cigarettes","Explanation of Adjustment"]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table3[[#This Row],[Column1]:[Column6]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table3[[#This Row],[Column1]:[Column6]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table3[[#This Row],[Column1]:[Column6]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table3[[#This Row],[Column1]:[Column6]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table3[[#This Row],[Column1]:[Column6]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table3[[#This Row],[Column1]:[Column6]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table3[[#This Row],[Column1]:[Column6]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table3[[#This Row],[Column1]:[Column6]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table3[[#This Row],[Column1]:[Column6]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table3[[#This Row],[Column1]:[Column6]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,"Total:",{"$f":"SUM(Table3[[#All],[Column5]])","v":0}]
[]
[null,"Ending Inventory"]
[null,"Tax Jurisdiction","UPC Number","Manufacturer","Brand Family","Total Cigarettes"]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table4[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table4[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table4[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table4[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table4[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table4[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table4[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table4[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table4[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table4[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table4[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table4[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table4[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table4[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table4[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTA(Table4[[#This Row],[Column1]:[Column5]])>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,"Total:",{"$f":"SUM(Table4[[#All],[Column5]])","v":0}]

{"sheet":"Sch3_Template","index":12,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["XML Code","Tag","Data","Display Line","Indent"]
["<SchIII>",null,null,"Y",1]
["<BeginningInventory>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+7),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},2]
["<BrandDetail>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+5),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},3]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<TaxJurisdiction></TaxJurisdiction>"},"TaxJurisdiction",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
["<UPCNumber></UPCNumber>","UPCNumber",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
["<Manufacturer></Manufacturer>","Manufacturer",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
["<BrandFamily></BrandFamily>","BrandFamily",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
["<TotalCigarettes></TotalCigarettes>","TotalCigarettes",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
["</BrandDetail>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-5),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},3]
["</BeginningInventory>",null,null,{"$f":"IFERROR(IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-7),\"=\"&\"Y\")>0,\"Y\",\"N\"),\"\")","v":"N"},2]
["<AdjustmentsToInventory>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+8),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},2]
["<BrandDetail>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+5),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},3]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<TaxJurisdiction></TaxJurisdiction>"},"TaxJurisdiction",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
["<UPCNumber></UPCNumber>","UPCNumber",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
["<Manufacturer></Manufacturer>","Manufacturer",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
["<BrandFamily></BrandFamily>","BrandFamily",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
["<TotalCigarettes></TotalCigarettes>","TotalCigarettes",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
["</BrandDetail>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-5),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},3]
["<ExplanationofAdjustment></ExplanationofAdjustment>","ExplanationofAdjustment",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},3]
["</AdjustmentsToInventory>",null,null,{"$f":"IFERROR(IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-8),\"=\"&\"Y\")>0,\"Y\",\"N\"),\"\")","v":"N"},2]
["<EndingInventory>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+7),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},2]
["<BrandDetail>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+5),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},3]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<TaxJurisdiction></TaxJurisdiction>"},"TaxJurisdiction",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
["<UPCNumber></UPCNumber>","UPCNumber",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
["<Manufacturer></Manufacturer>","Manufacturer",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
["<BrandFamily></BrandFamily>","BrandFamily",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
["<TotalCigarettes></TotalCigarettes>","TotalCigarettes",null,{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"N"},4]
["</BrandDetail>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-5),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"N"},3]
["</EndingInventory>",null,null,{"$f":"IFERROR(IF(COUNTIF(INDIRECT(\"D\"&ROW()-1&\":D\"&ROW()-7),\"=\"&\"Y\")>0,\"Y\",\"N\"),\"\")","v":"N"},2]
["</SchIII>",null,null,"Y",1]

{"sheet":"Sch3_Assembly","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Form 55","index":14,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1.","Cigarette Inventory to Account For:"]
[null,null,"   Resident Wholesalers"]
[null,null,"Beginning Inventory (Total from Sch 3)…………………………………………..",{"$f":"IF('Report Information'!W8=\"Resident Wholesaler\",SUM(Table2[[#All],[Column5]]),0)","v":0}]
[null,null,"Untaxed Purchases (Total from Sch 1)……………………………………………",{"$f":"IF('Report Information'!W8=\"Resident Wholesaler\",SUMIF('Sch1 Entry'!B:B,\"Untaxed Purchases\",'Sch1 Entry'!S:S),0)","v":0}]
[null,null,"Tax Paid Purchases (Total from Sch 1)……..……...…….………………………",{"$f":"IF('Report Information'!W8=\"Resident Wholesaler\",SUMIF('Sch1 Entry'!B:B,\"Tax Paid Purchases\",'Sch1 Entry'!S:S),0)","v":0}]
[null,null,"   Nonresident Wholesalers"]
[null,null,"Taxpaid Sales NE Jurisdiction (Total from Sch 1)……………………..…..……",{"$f":"IF('Report Information'!W8<>\"Resident Wholesaler\",SUM(IF(('Sch1 Entry'!B:B=\"Tax Paid Sales\")*('Sch1 Entry'!O:O=\"NE\"),'Sch1 Entry'!S:S,0)),0)","v":0}]
[null,null,"Total","………….………………………………………………………………………",null,null,null,{"$f":"SUM(D13:D17)","v":0}]
[]
[null,"2.","Deductions from Cigarette Inventory"]
[null,null,"   Resident Wholesalers"]
[null,null,"Untaxed Sales (Total from Sch 1)……………………………………………………",{"$f":"IF('Report Information'!W8=\"Resident Wholesaler\",SUMIF('Sch1 Entry'!B:B,\"Untaxed Sales\",'Sch1 Entry'!S:S),0)","v":0}]
[null,null,"Tax paid Sales all but NE Jurisdiction (Total from Sch 1)…………..…….",{"$f":"IF('Report Information'!W8=\"Resident Wholesaler\",SUM(IF(('Sch1 Entry'!B:B=\"Tax Paid Sales\")*('Sch1 Entry'!O:O<>\"NE\"),'Sch1 Entry'!S:S,0)),0)","v":0}]
[null,null,"Untaxed credits (Total from Sch 1)………………………………………………..",{"$f":"IF('Report Information'!W8=\"Resident Wholesaler\",SUMIF('Sch1 Entry'!B:B,\"Untaxed Credits\",'Sch1 Entry'!S:S),0)","v":0}]
[null,null,"Tax paid credits (Total from Sch 1)………………………………………………..",{"$f":"IF('Report Information'!W8=\"Resident Wholesaler\",SUMIF('Sch1 Entry'!B:B,\"Tax Paid Credits\",'Sch1 Entry'!S:S),0)","v":0}]
[null,null,"Adjustments to Inventory (Total from Sch 3)………………………………….",{"$f":"IF('Report Information'!W8=\"Resident Wholesaler\",SUM(Table3[[#All],[Column5]]),0)","v":0}]
[null,null,"Ending Inventory (Total from Sch 3)………………………………………………..",{"$f":"IF('Report Information'!W8=\"Resident Wholesaler\",SUM(Table4[[#All],[Column5]]),0)","v":0}]
[null,null,"Total","………….………………………………………………………………………",null,null,null,{"$f":"SUM(D22:D27)","v":0}]
[]
[null,"3.","Cigarettes Subject to Tax (Subtract 2 from 1)……………………………………………………………………………………………………………….",null,null,null,null,{"$f":"SUM(H18,-H28)","v":0}]
[]
[null,"4.","Cigarette Tax (Multiply 3 by $0.032)……………………………………………………………………………………………………………………………….",null,null,null,null,{"$f":"H30*0.032","v":0}]
[]
[null,"5.","Value of Stamps to Account For"]
[null,null,"Value of Beginning Stamp Inventory (Total from Sch 2)…………...……………………………………………………..",null,null,{"$f":"IF('Sch2 Entry'!F11<>\"\",'Sch2 Entry'!F11,0)","v":0}]
[null,null,"Value of Stamp Purchases (Total from Sch 2)…………………………….……………………..……………...…………….",null,null,{"$f":"SUM(Table1[[#All],[Column5]])","v":0}]
[null,null,"Beginning Inventory only NE Jurisdiction (Total from Sch 3)……………",{"$f":"SUMIF(Table2[Column1],\"NE\",Table2[Column5])","v":0},"x  $0.032",{"$f":"D37*0.032","v":0}]
[null,null,"Taxpaid Purchases only NE Jurisdiction (Total from Sch 1)……………..",{"$f":"SUM(IF(('Sch1 Entry'!B:B=\"Tax Paid Purchases\")*('Sch1 Entry'!O:O=\"NE\"),'Sch1 Entry'!S:S,0))","v":0},"x  $0.032",{"$f":"D38*0.032","v":0}]
[null,null,"Total","………….……………………………………………………………………..",null,null,null,{"$f":"SUM(F35:F38)","v":0}]
[]
[null,"6.","Value of Deductions from Stamp Inventory"]
[null,null,"Value of Stamps Returned to the Department (Total from Sch 2)……….……………………………………………",null,null,{"$f":"SUM('Sch2 Entry'!$F$29:$F$30)","v":0}]
[null,null,"Value of Ending Stamp Inventory (Total from Sch 2)……………………..…………………….……………………………",null,null,{"$f":"'Sch2 Entry'!F33","v":0}]
[null,null,"Tax paid credits  only NE Jurisdiction (Total from Sch 1)……………….…",{"$f":"SUM(IF(('Sch1 Entry'!B:B=\"Tax Paid Credits\")*('Sch1 Entry'!O:O=\"NE\"),'Sch1 Entry'!S:S,0))","v":0},"x  $0.032",{"$f":"D44*0.032","v":0}]
[null,null,"Adjustments to Inventory only NE Jurisdiction (Total from Sch 3)……",{"$f":"SUMIF(Table3[Column1],\"NE\",Table3[Column5])","v":0},"x  $0.032",{"$f":"D45*0.032","v":0}]
[null,null,"Ending Inventory only NE Jurisdiction (Total from Sch 3)…………………",{"$f":"SUMIF(Table4[Column1],\"NE\",Table4[Column5])","v":0},"x  $0.032",{"$f":"D46*0.032","v":0}]
[null,null,"Total","………….……………………………………………………………………..",null,null,null,{"$f":"SUM(F42:F46)","v":0}]
[]
[null,"7.","Value of Stamps Used this Month (Subtract 6 from 5)………………..……………………………………………………………………………..",null,null,null,null,{"$f":"SUM(H39,-H47)","v":0}]
[]
[null,"8.","Cigarette Tax Due (Subtract 7 from 4. )…………..………….…………………………………………………………………….…………………………..",null,null,null,null,{"$f":"SUM(H32,-H49)","v":0}]
[null,null,"           Note:    A negative amount shown on Line 8 will not establish a credit to your account.  Contact the Department for instructions"]

{"sheet":"Form55_Template","index":15,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["XML Code","Tag","Data","Display Line","Indent"]
["<NEForm55>",null,null,{"$f":"IF(COUNTIF(INDIRECT(\"D\"&ROW()+1&\":D\"&ROW()+8),\"=\"&\"Y\")>0,\"Y\",\"N\")","v":"Y"},1]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<CigaretteInvtoAccountfor>0</CigaretteInvtoAccountfor>"},"CigaretteInvtoAccountfor",{"$f":"'Form 55'!H18","v":0},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"Y"},2]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",INDIRECT(\"C\"&ROW()),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<DeductionsfromCigaretteInv>0</DeductionsfromCigaretteInv>"},"DeductionsfromCigaretteInv",{"$f":"'Form 55'!H28","v":0},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"Y"},2]
["<CigarettesSubjecttoTax>0</CigarettesSubjecttoTax>","CigarettesSubjecttoTax",{"$f":"'Form 55'!H30","v":0},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"Y"},2]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",TEXT(INDIRECT(\"C\"&ROW()),\"0.00\"),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<CigaretteTax>0.00</CigaretteTax>"},"CigaretteTax",{"$f":"'Form 55'!H32","v":0},{"$f":"IF(INDIRECT(\"C\"&ROW())<>\"\",\"Y\",\"N\")","v":"Y"},2]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",TEXT(INDIRECT(\"C\"&ROW()),\"0.00\"),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<ValueofStampstoAccountfor>0.00</ValueofStampstoAccountfor>"},"ValueofStampstoAccountfor",{"$f":"'Form 55'!H39","v":0},"Y",2]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",TEXT(INDIRECT(\"C\"&ROW()),\"0.00\"),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<ValueofDeductionsfromStampInv>0.00</ValueofDeductionsfromStampInv>"},"ValueofDeductionsfromStampInv",{"$f":"'Form 55'!H47","v":0},"Y",2]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",TEXT(INDIRECT(\"C\"&ROW()),\"0.00\"),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<ValueofStampsUsedthisMonth>0.00</ValueofStampsUsedthisMonth>"},"ValueofStampsUsedthisMonth",{"$f":"'Form 55'!H49","v":0},"Y",2]
[{"$f":"CONCATENATE(\"<\",INDIRECT(\"B\"&ROW()),\">\",TEXT(INDIRECT(\"C\"&ROW()),\"0.00\"),\"</\",INDIRECT(\"B\"&ROW()),\">\")","v":"<CigaretteTaxDue>0.00</CigaretteTaxDue>"},"CigaretteTaxDue",{"$f":"'Form 55'!H51","v":0},"Y",2]
["</NEForm55>",null,null,{"$f":"INDIRECT(\"D\"&ROW()-9)","v":"Y"},1]

{"sheet":"Form55_No_Trans","index":16,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["XML Code","Tag","Data","Display Line","Indent"]
["<NEForm55>",null,null,"Y",1]
["<NoTransactions>X</NoTransactions>",null,null,"Y"]
["</NEForm55>",null,null,"Y",1]

{"sheet":"XML_Data","index":17,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Instructions","index":18,"n_rows":74,"n_cols":2,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using the Excel Spreadsheet to create an XML file for Cigarette reporting:"]
[]
[null,"Technical Information:"]
[null,"This spreadsheet was designed using Microsoft Excel 2010.  The Nebraska Department of Revenue does not support other "]
[null,"versions of Microsoft Excel or other products."]
[]
[null,"You should download and save a copy of the spreadsheet."]
[null,"You must enable macros to use this spreadsheet."]
[]
[null,"General Information:"]
[null,"The spreadsheet is a tool that may be used to generate an XML file containing the data required for a cigarette tax or PAC Act"]
[null,"filing with Nebraska.  Using this tool is an option, and you may choose another method to generate the file.  "]
[null,"Required fields are highlighted in red. "]
[null,"If a field contains invalid text, the text will be shown in red.   Invalid text includes most special characters.  The LML does not allow for"]
[null,"characters such as decimal points, ampersands, hyphens, pound signs, extra spaces, and other special characters."]
[null,"For additional information refer to the \"Nebraska Cigarette Tax Return Electronic filing Instructions\" document located"]
[null,"on the Department's web page."]
[]
[null,"Report Information Tab:"]
[null,"Report Details:"]
[null,"Use the drop down box to select your filer type."]
[null,"1. Select Resident Wholesaler if you are licensed as a Nebraska stamping agent with a location inside Nebraska."]
[null,"2. Select Non-resident Wholesaler if you are licensed as a Nebraska stamping agent, but do not have a location inside Nebraska."]
[null,"3. Select PACT-Act filer if you are not a Nebraska stamping agent, but import cigarettes into Nebraska."]
[null,"Enter the Tax Period Begin date.  This must be the first day of a calendar month.  The tax period end date will auto-populate based on the begin date."]
[null,"Click the Amended Return, No Transactions, or Disaster Relief boxes only if they apply to this return."]
[null,"Select a process type.  Use “Test” only when filing using our test site. When filing an actual return the process type should be “Production”."]
[]
[null,"Filer Info:"]
[null,"Complete the Filer Information for your organization."]
[]
[null,"Paid Preparer Info:"]
[null,"The Paid Preparer Info should only be completed if you are using a third party to prepare this filing."]
[null,"Financial Info:"]
[null,"The Financial Info should only be completed if this filing shows a balance due and you would like to make payment by electronic funds withdrawal."]
[]
[null,"Schedule I Entry Tab:"]
[null,"1. You may both enter the information on Schedule I; or copy and paste the information from an existing file."]
[null,"2. Additional rows may be added in increments of 3000.  Before copying and pasting add enough available rows to meet or exceed the number of "]
[null,"     rows necessary. If you do not add enough rows, you will receive an error message and will not be allowed to continue."]
[null,"3. Columns must match the Schedule I order before copying and pasting.  Also, it is easier to format the fields correctly before pasting."]
[null,"4. The spreadsheet defaults to a US Address, if you need to enter a foreign address, click the “Display Foreign Fields” box to display the foreign address fields."]
[null,"5. The “Type of Cigarette Schedule is identified on each line.  You may use the drop down box to select the type after copying and pasting, select these before "]
[null,"     copying and pasting, or include this column when pasting data.  If pasting the type of cigarette schedule must be spelled and formatted exactly as shown"]
[null,"     in the drop down boxes.  "]
[null,"6. The deliverer information should only be completed when a delivery seller makes delivery sales to the direct consumer. For "]
[null,"     additional information on element input, refer to the \"Nebraska Cigarette Tax Return Electronic Filing Instructions\" document "]
[null,"     located on the Department's web page."]
[]
[null,"Schedule II Entry Tab:"]
[null,"1. Include only un-affixed stamps in beginning and ending inventory."]
[null,"2. Beginning stamp inventory must match the previous month’s ending inventory."]
[null,"3. Ending inventory should be actual un-affixed stamp inventory at the close of business on the tax period end date."]
[]
[null,"Schedule III Entry Tab:"]
[null,"1. Beginning inventory should match the previous month’s ending inventory."]
[null,"2. Tax Jurisdiction should be completed if the product is tax paid."]
[null,"3. Report all additions and subtractions of cigarettes from inventory not reported as sales, purchases, or credits on Schedule I. "]
[null,"    Allowable adjustments to inventory may include: "]
[]
[null,"a. Stamped and unstamped packs removed from inventory and returned to the cigarette manufacturer. Do not include items reported as"]
[null,"     tax paid credits or untaxed credits on Schedule I. "]
[null,"b. Adjustments to correct brand detail errors on invoices may be made in this section. This must include two entries (a positive and a negative) to recognize the change. "]
[null,"c. If you have other adjustments for losses due to theft, fire, etc., contact the Department of Revenue for special instructions. "]
[]
[null,"Form 55 Tab:"]
[null,"The Form 55 amounts will be brought forward from the Schedule totals.  No entry is allowed on Form 55. Corrections should be made to the Schedules to update Form 55."]
[]
[null,"Generate the XML file:"]
[null,"When all schedules required are complete and correct you may generate an XML file.  From the Report Information tab, you must first click “Set Path” button to "]
[null,"indicate the location to save the XML file that will be generated.  Then click the “Create XML File” button.  If your schedules contain errors a message will appear.  "]
[null,"Correct all errors shown in red and then click “Create XML File” button.  Repeat process until all errors are corrected.  Once you have created the XML file, you must"]
[null,"use the NebFile for Business program to file your return.  "]