{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["DisAgg SUT","LayoutFields","Municipalities","Instructions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"DisAgg SUT","index":0,"n_rows":170,"n_cols":33,"rows_kept":170,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,2,3,3]]}
["Disaggregated Sales Tax"," File Creator for CSV Upload",{"$f":"COUNT(F8:F5305)& \"  record(s)\"","v":"0  record(s)"},null,null,null,null,null,null,null,"1099-Misc","1099-R","W-2G",null,null,null,null,null,"H:\\CTW3.xlsx",null,null,null,null,null,null,null,null,null,null,null,null,"P:\\PerOper\\OperSharedSvcs\\ECU\\Public\\WO#2954\\TSC\\TPBF\\SpreadSheet_Solutions\\DisAggSUTjay dog.xlsx"]
[" Enter company name or a unique identifier here ►►","Enter Name",null,null,null,{"$f":"IF(F1=0,\"\",IF(MOD(F1,1)>0,\"Round To Whole Numbers DO NOT INCLUDE CENTS\",\"\"))","v":""},null,null,null,"Y","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MONTH(B4) & DAY(B4)","v":{"$error":"#VALUE!"}}]
["CT Reg Number","Enter CT Tax Reg #",{"$f":"IF(B3=\"Enter CT Tax Reg #\",\"\",IF(AG3=\"TRUE\",\"\",\"CT Tax Registration Number must end in 901, 902, or 903\"))","v":""},null,null,null,null,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":"VALUE(RIGHT(B3,3))","v":{"$error":"#VALUE!"}},{"$f":"IF(AF3>900,\"TRUE\",\"FALSE\")","v":{"$error":"#VALUE!"}}]
["Period End","Enter Period End",{"$f":"IF(B4=\"Enter Period End\",\"\",IF(AF2=\"630\",\"\",\"Period end must be June 30 of the fiscal year\"))","v":""}]
[null,"totals:",{"$f":"SUM(E8:E200)","v":0},{"$f":"SUM(F8:F200)","v":0},0,0]
[null,null,{"$f":"IF($B$4=\"Enter Period End\",\"ENTER PERIOD END\",\"Period:  \nJul 1 \"& YEAR(B4) -1& \" -Sep 30 \"&YEAR(B4)-1)","v":"ENTER PERIOD END"},{"$f":"IF($B$4=\"Enter Period End\",\"ENTER PERIOD END\",\"Period:  \nOct 1 \"& YEAR($B$4) -1& \" -Dec 31 \"&YEAR($B$4)-1)","v":"ENTER PERIOD END"},{"$f":"IF($B$4=\"Enter Period End\",\"ENTER PERIOD END\",\"Period:  \nJan 1 \"& YEAR($B$4)& \" -Mar 31 \"&YEAR($B$4))","v":"ENTER PERIOD END"},{"$f":"IF($B$4=\"Enter Period End\",\"ENTER PERIOD END\",\"Period:  \nApr 1 \"& YEAR($B$4)& \" -Jun 30 \"&YEAR($B$4))","v":"ENTER PERIOD END"}]
["Municipality Code\n(value 001-170, See Municipalities tab)","Municipality Description\n(Value looked up by Municippal code)","Gross amount tax due","Gross amount tax due","Gross amount tax due","Gross amount tax due"]
[null,{"$f":"IF(A8=\"\",\"\",VLOOKUP(A8,Municipalities!A2:B171,2))","v":""}]
[null,{"$f":"IF(A9=\"\",\"\",VLOOKUP(A9,Municipalities!A3:B172,2))","v":""}]
[null,{"$f":"IF(A10=\"\",\"\",VLOOKUP(A10,Municipalities!A4:B173,2))","v":""}]
[null,{"$f":"IF(A11=\"\",\"\",VLOOKUP(A11,Municipalities!A5:B174,2))","v":""}]
[null,{"$f":"IF(A12=\"\",\"\",VLOOKUP(A12,Municipalities!A6:B175,2))","v":""}]
[null,{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,Municipalities!A7:B176,2))","v":""}]
[null,{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,Municipalities!A8:B177,2))","v":""}]
[null,{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,Municipalities!A9:B178,2))","v":""}]
[null,{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,Municipalities!A10:B179,2))","v":""}]
[null,{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,Municipalities!A11:B180,2))","v":""}]
[null,{"$f":"IF(A18=\"\",\"\",VLOOKUP(A18,Municipalities!A12:B181,2))","v":""}]
[null,{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,Municipalities!A13:B182,2))","v":""}]
[null,{"$f":"IF(A20=\"\",\"\",VLOOKUP(A20,Municipalities!A14:B183,2))","v":""}]
[null,{"$f":"IF(A21=\"\",\"\",VLOOKUP(A21,Municipalities!A15:B184,2))","v":""}]
[null,{"$f":"IF(A22=\"\",\"\",VLOOKUP(A22,Municipalities!A16:B185,2))","v":""}]
[null,{"$f":"IF(A23=\"\",\"\",VLOOKUP(A23,Municipalities!A17:B186,2))","v":""}]
[null,{"$f":"IF(A24=\"\",\"\",VLOOKUP(A24,Municipalities!A18:B187,2))","v":""}]
[null,{"$f":"IF(A25=\"\",\"\",VLOOKUP(A25,Municipalities!A19:B188,2))","v":""}]
[null,{"$f":"IF(A26=\"\",\"\",VLOOKUP(A26,Municipalities!A20:B189,2))","v":""}]
[null,{"$f":"IF(A27=\"\",\"\",VLOOKUP(A27,Municipalities!A21:B190,2))","v":""}]
[null,{"$f":"IF(A28=\"\",\"\",VLOOKUP(A28,Municipalities!A22:B191,2))","v":""}]
[null,{"$f":"IF(A29=\"\",\"\",VLOOKUP(A29,Municipalities!A23:B192,2))","v":""}]
[null,{"$f":"IF(A30=\"\",\"\",VLOOKUP(A30,Municipalities!A24:B193,2))","v":""}]
[null,{"$f":"IF(A31=\"\",\"\",VLOOKUP(A31,Municipalities!A25:B194,2))","v":""}]
[null,{"$f":"IF(A32=\"\",\"\",VLOOKUP(A32,Municipalities!A26:B195,2))","v":""}]
[null,{"$f":"IF(A33=\"\",\"\",VLOOKUP(A33,Municipalities!A27:B196,2))","v":""}]
[null,{"$f":"IF(A34=\"\",\"\",VLOOKUP(A34,Municipalities!A28:B197,2))","v":""}]
[null,{"$f":"IF(A35=\"\",\"\",VLOOKUP(A35,Municipalities!A29:B198,2))","v":""}]
[null,{"$f":"IF(A36=\"\",\"\",VLOOKUP(A36,Municipalities!A30:B199,2))","v":""}]
[null,{"$f":"IF(A37=\"\",\"\",VLOOKUP(A37,Municipalities!A31:B200,2))","v":""}]
[null,{"$f":"IF(A38=\"\",\"\",VLOOKUP(A38,Municipalities!A32:B201,2))","v":""}]
[null,{"$f":"IF(A39=\"\",\"\",VLOOKUP(A39,Municipalities!A33:B202,2))","v":""}]
[null,{"$f":"IF(A40=\"\",\"\",VLOOKUP(A40,Municipalities!A34:B203,2))","v":""}]
[null,{"$f":"IF(A41=\"\",\"\",VLOOKUP(A41,Municipalities!A35:B204,2))","v":""}]
[null,{"$f":"IF(A42=\"\",\"\",VLOOKUP(A42,Municipalities!A36:B205,2))","v":""}]
[null,{"$f":"IF(A43=\"\",\"\",VLOOKUP(A43,Municipalities!A37:B206,2))","v":""}]
[null,{"$f":"IF(A44=\"\",\"\",VLOOKUP(A44,Municipalities!A38:B207,2))","v":""}]
[null,{"$f":"IF(A45=\"\",\"\",VLOOKUP(A45,Municipalities!A39:B208,2))","v":""}]
[null,{"$f":"IF(A46=\"\",\"\",VLOOKUP(A46,Municipalities!A40:B209,2))","v":""}]
[null,{"$f":"IF(A47=\"\",\"\",VLOOKUP(A47,Municipalities!A41:B210,2))","v":""}]
[null,{"$f":"IF(A48=\"\",\"\",VLOOKUP(A48,Municipalities!A42:B211,2))","v":""}]
[null,{"$f":"IF(A49=\"\",\"\",VLOOKUP(A49,Municipalities!A43:B212,2))","v":""}]
[null,{"$f":"IF(A50=\"\",\"\",VLOOKUP(A50,Municipalities!A44:B213,2))","v":""}]
[null,{"$f":"IF(A51=\"\",\"\",VLOOKUP(A51,Municipalities!A45:B214,2))","v":""}]
[null,{"$f":"IF(A52=\"\",\"\",VLOOKUP(A52,Municipalities!A46:B215,2))","v":""}]
[null,{"$f":"IF(A53=\"\",\"\",VLOOKUP(A53,Municipalities!A47:B216,2))","v":""}]
[null,{"$f":"IF(A54=\"\",\"\",VLOOKUP(A54,Municipalities!A48:B217,2))","v":""}]
[null,{"$f":"IF(A55=\"\",\"\",VLOOKUP(A55,Municipalities!A49:B218,2))","v":""}]
[null,{"$f":"IF(A56=\"\",\"\",VLOOKUP(A56,Municipalities!A50:B219,2))","v":""}]
[null,{"$f":"IF(A57=\"\",\"\",VLOOKUP(A57,Municipalities!A51:B220,2))","v":""}]
[null,{"$f":"IF(A58=\"\",\"\",VLOOKUP(A58,Municipalities!A52:B221,2))","v":""}]
[null,{"$f":"IF(A59=\"\",\"\",VLOOKUP(A59,Municipalities!A53:B222,2))","v":""}]
[null,{"$f":"IF(A60=\"\",\"\",VLOOKUP(A60,Municipalities!A54:B223,2))","v":""}]
[null,{"$f":"IF(A61=\"\",\"\",VLOOKUP(A61,Municipalities!A55:B224,2))","v":""}]
[null,{"$f":"IF(A62=\"\",\"\",VLOOKUP(A62,Municipalities!A56:B225,2))","v":""}]
[null,{"$f":"IF(A63=\"\",\"\",VLOOKUP(A63,Municipalities!A57:B226,2))","v":""}]
[null,{"$f":"IF(A64=\"\",\"\",VLOOKUP(A64,Municipalities!A58:B227,2))","v":""}]
[null,{"$f":"IF(A65=\"\",\"\",VLOOKUP(A65,Municipalities!A59:B228,2))","v":""}]
[null,{"$f":"IF(A66=\"\",\"\",VLOOKUP(A66,Municipalities!A60:B229,2))","v":""}]
[null,{"$f":"IF(A67=\"\",\"\",VLOOKUP(A67,Municipalities!A61:B230,2))","v":""}]
[null,{"$f":"IF(A68=\"\",\"\",VLOOKUP(A68,Municipalities!A62:B231,2))","v":""}]
[null,{"$f":"IF(A69=\"\",\"\",VLOOKUP(A69,Municipalities!A63:B232,2))","v":""}]
[null,{"$f":"IF(A70=\"\",\"\",VLOOKUP(A70,Municipalities!A64:B233,2))","v":""}]
[null,{"$f":"IF(A71=\"\",\"\",VLOOKUP(A71,Municipalities!A65:B234,2))","v":""}]
[null,{"$f":"IF(A72=\"\",\"\",VLOOKUP(A72,Municipalities!A66:B235,2))","v":""}]
[null,{"$f":"IF(A73=\"\",\"\",VLOOKUP(A73,Municipalities!A67:B236,2))","v":""}]
[null,{"$f":"IF(A74=\"\",\"\",VLOOKUP(A74,Municipalities!A68:B237,2))","v":""}]
[null,{"$f":"IF(A75=\"\",\"\",VLOOKUP(A75,Municipalities!A69:B238,2))","v":""}]
[null,{"$f":"IF(A76=\"\",\"\",VLOOKUP(A76,Municipalities!A70:B239,2))","v":""}]
[null,{"$f":"IF(A77=\"\",\"\",VLOOKUP(A77,Municipalities!A71:B240,2))","v":""}]
[null,{"$f":"IF(A78=\"\",\"\",VLOOKUP(A78,Municipalities!A72:B241,2))","v":""}]
[null,{"$f":"IF(A79=\"\",\"\",VLOOKUP(A79,Municipalities!A73:B242,2))","v":""}]
[null,{"$f":"IF(A80=\"\",\"\",VLOOKUP(A80,Municipalities!A74:B243,2))","v":""}]
[null,{"$f":"IF(A81=\"\",\"\",VLOOKUP(A81,Municipalities!A75:B244,2))","v":""}]
[null,{"$f":"IF(A82=\"\",\"\",VLOOKUP(A82,Municipalities!A76:B245,2))","v":""}]
[null,{"$f":"IF(A83=\"\",\"\",VLOOKUP(A83,Municipalities!A77:B246,2))","v":""}]
[null,{"$f":"IF(A84=\"\",\"\",VLOOKUP(A84,Municipalities!A78:B247,2))","v":""}]
[null,{"$f":"IF(A85=\"\",\"\",VLOOKUP(A85,Municipalities!A79:B248,2))","v":""}]
[null,{"$f":"IF(A86=\"\",\"\",VLOOKUP(A86,Municipalities!A80:B249,2))","v":""}]
[null,{"$f":"IF(A87=\"\",\"\",VLOOKUP(A87,Municipalities!A81:B250,2))","v":""}]
[null,{"$f":"IF(A88=\"\",\"\",VLOOKUP(A88,Municipalities!A82:B251,2))","v":""}]
[null,{"$f":"IF(A89=\"\",\"\",VLOOKUP(A89,Municipalities!A83:B252,2))","v":""}]
[null,{"$f":"IF(A90=\"\",\"\",VLOOKUP(A90,Municipalities!A84:B253,2))","v":""}]
[null,{"$f":"IF(A91=\"\",\"\",VLOOKUP(A91,Municipalities!A85:B254,2))","v":""}]
[null,{"$f":"IF(A92=\"\",\"\",VLOOKUP(A92,Municipalities!A86:B255,2))","v":""}]
[null,{"$f":"IF(A93=\"\",\"\",VLOOKUP(A93,Municipalities!A87:B256,2))","v":""}]
[null,{"$f":"IF(A94=\"\",\"\",VLOOKUP(A94,Municipalities!A88:B257,2))","v":""}]
[null,{"$f":"IF(A95=\"\",\"\",VLOOKUP(A95,Municipalities!A89:B258,2))","v":""}]
[null,{"$f":"IF(A96=\"\",\"\",VLOOKUP(A96,Municipalities!A90:B259,2))","v":""}]
[null,{"$f":"IF(A97=\"\",\"\",VLOOKUP(A97,Municipalities!A91:B260,2))","v":""}]
[null,{"$f":"IF(A98=\"\",\"\",VLOOKUP(A98,Municipalities!A92:B261,2))","v":""}]
[null,{"$f":"IF(A99=\"\",\"\",VLOOKUP(A99,Municipalities!A93:B262,2))","v":""}]
[null,{"$f":"IF(A100=\"\",\"\",VLOOKUP(A100,Municipalities!A94:B263,2))","v":""}]
[null,{"$f":"IF(A101=\"\",\"\",VLOOKUP(A101,Municipalities!A95:B264,2))","v":""}]
[null,{"$f":"IF(A102=\"\",\"\",VLOOKUP(A102,Municipalities!A96:B265,2))","v":""}]
[null,{"$f":"IF(A103=\"\",\"\",VLOOKUP(A103,Municipalities!A97:B266,2))","v":""}]
[null,{"$f":"IF(A104=\"\",\"\",VLOOKUP(A104,Municipalities!A98:B267,2))","v":""}]
[null,{"$f":"IF(A105=\"\",\"\",VLOOKUP(A105,Municipalities!A99:B268,2))","v":""}]
[null,{"$f":"IF(A106=\"\",\"\",VLOOKUP(A106,Municipalities!A100:B269,2))","v":""}]
[null,{"$f":"IF(A107=\"\",\"\",VLOOKUP(A107,Municipalities!A101:B270,2))","v":""}]
[null,{"$f":"IF(A108=\"\",\"\",VLOOKUP(A108,Municipalities!A102:B271,2))","v":""}]
[null,{"$f":"IF(A109=\"\",\"\",VLOOKUP(A109,Municipalities!A103:B272,2))","v":""}]
[null,{"$f":"IF(A110=\"\",\"\",VLOOKUP(A110,Municipalities!A104:B273,2))","v":""}]
[null,{"$f":"IF(A111=\"\",\"\",VLOOKUP(A111,Municipalities!A105:B274,2))","v":""}]
[null,{"$f":"IF(A112=\"\",\"\",VLOOKUP(A112,Municipalities!A106:B275,2))","v":""}]
[null,{"$f":"IF(A113=\"\",\"\",VLOOKUP(A113,Municipalities!A107:B276,2))","v":""}]
[null,{"$f":"IF(A114=\"\",\"\",VLOOKUP(A114,Municipalities!A108:B277,2))","v":""}]
[null,{"$f":"IF(A115=\"\",\"\",VLOOKUP(A115,Municipalities!A109:B278,2))","v":""}]
[null,{"$f":"IF(A116=\"\",\"\",VLOOKUP(A116,Municipalities!A110:B279,2))","v":""}]
[null,{"$f":"IF(A117=\"\",\"\",VLOOKUP(A117,Municipalities!A111:B280,2))","v":""}]
[null,{"$f":"IF(A118=\"\",\"\",VLOOKUP(A118,Municipalities!A112:B281,2))","v":""}]
[null,{"$f":"IF(A119=\"\",\"\",VLOOKUP(A119,Municipalities!A113:B282,2))","v":""}]
[null,{"$f":"IF(A120=\"\",\"\",VLOOKUP(A120,Municipalities!A114:B283,2))","v":""}]
[null,{"$f":"IF(A121=\"\",\"\",VLOOKUP(A121,Municipalities!A115:B284,2))","v":""}]
[null,{"$f":"IF(A122=\"\",\"\",VLOOKUP(A122,Municipalities!A116:B285,2))","v":""}]
[null,{"$f":"IF(A123=\"\",\"\",VLOOKUP(A123,Municipalities!A117:B286,2))","v":""}]
[null,{"$f":"IF(A124=\"\",\"\",VLOOKUP(A124,Municipalities!A118:B287,2))","v":""}]
[null,{"$f":"IF(A125=\"\",\"\",VLOOKUP(A125,Municipalities!A119:B288,2))","v":""}]
[null,{"$f":"IF(A126=\"\",\"\",VLOOKUP(A126,Municipalities!A120:B289,2))","v":""}]
[null,{"$f":"IF(A127=\"\",\"\",VLOOKUP(A127,Municipalities!A121:B290,2))","v":""}]
[null,{"$f":"IF(A128=\"\",\"\",VLOOKUP(A128,Municipalities!A122:B291,2))","v":""}]
[null,{"$f":"IF(A129=\"\",\"\",VLOOKUP(A129,Municipalities!A123:B292,2))","v":""}]
[null,{"$f":"IF(A130=\"\",\"\",VLOOKUP(A130,Municipalities!A124:B293,2))","v":""}]
[null,{"$f":"IF(A131=\"\",\"\",VLOOKUP(A131,Municipalities!A125:B294,2))","v":""}]
[null,{"$f":"IF(A132=\"\",\"\",VLOOKUP(A132,Municipalities!A126:B295,2))","v":""}]
[null,{"$f":"IF(A133=\"\",\"\",VLOOKUP(A133,Municipalities!A127:B296,2))","v":""}]
[null,{"$f":"IF(A134=\"\",\"\",VLOOKUP(A134,Municipalities!A128:B297,2))","v":""}]
[null,{"$f":"IF(A135=\"\",\"\",VLOOKUP(A135,Municipalities!A129:B298,2))","v":""}]
[null,{"$f":"IF(A136=\"\",\"\",VLOOKUP(A136,Municipalities!A130:B299,2))","v":""}]
[null,{"$f":"IF(A137=\"\",\"\",VLOOKUP(A137,Municipalities!A131:B300,2))","v":""}]
[null,{"$f":"IF(A138=\"\",\"\",VLOOKUP(A138,Municipalities!A132:B301,2))","v":""}]
[null,{"$f":"IF(A139=\"\",\"\",VLOOKUP(A139,Municipalities!A133:B302,2))","v":""}]
[null,{"$f":"IF(A140=\"\",\"\",VLOOKUP(A140,Municipalities!A134:B303,2))","v":""}]
[null,{"$f":"IF(A141=\"\",\"\",VLOOKUP(A141,Municipalities!A135:B304,2))","v":""}]
[null,{"$f":"IF(A142=\"\",\"\",VLOOKUP(A142,Municipalities!A136:B305,2))","v":""}]
[null,{"$f":"IF(A143=\"\",\"\",VLOOKUP(A143,Municipalities!A137:B306,2))","v":""}]
[null,{"$f":"IF(A144=\"\",\"\",VLOOKUP(A144,Municipalities!A138:B307,2))","v":""}]
[null,{"$f":"IF(A145=\"\",\"\",VLOOKUP(A145,Municipalities!A139:B308,2))","v":""}]
[null,{"$f":"IF(A146=\"\",\"\",VLOOKUP(A146,Municipalities!A140:B309,2))","v":""}]
[null,{"$f":"IF(A147=\"\",\"\",VLOOKUP(A147,Municipalities!A141:B310,2))","v":""}]
[null,{"$f":"IF(A148=\"\",\"\",VLOOKUP(A148,Municipalities!A142:B311,2))","v":""}]
[null,{"$f":"IF(A149=\"\",\"\",VLOOKUP(A149,Municipalities!A143:B312,2))","v":""}]
[null,{"$f":"IF(A150=\"\",\"\",VLOOKUP(A150,Municipalities!A144:B313,2))","v":""}]
[null,{"$f":"IF(A151=\"\",\"\",VLOOKUP(A151,Municipalities!A145:B314,2))","v":""}]
[null,{"$f":"IF(A152=\"\",\"\",VLOOKUP(A152,Municipalities!A146:B315,2))","v":""}]
[null,{"$f":"IF(A153=\"\",\"\",VLOOKUP(A153,Municipalities!A147:B316,2))","v":""}]
[null,{"$f":"IF(A154=\"\",\"\",VLOOKUP(A154,Municipalities!A148:B317,2))","v":""}]
[null,{"$f":"IF(A155=\"\",\"\",VLOOKUP(A155,Municipalities!A149:B318,2))","v":""}]
[null,{"$f":"IF(A156=\"\",\"\",VLOOKUP(A156,Municipalities!A150:B319,2))","v":""}]
[null,{"$f":"IF(A157=\"\",\"\",VLOOKUP(A157,Municipalities!A151:B320,2))","v":""}]
[null,{"$f":"IF(A158=\"\",\"\",VLOOKUP(A158,Municipalities!A152:B321,2))","v":""}]
[null,{"$f":"IF(A159=\"\",\"\",VLOOKUP(A159,Municipalities!A153:B322,2))","v":""}]
[null,{"$f":"IF(A160=\"\",\"\",VLOOKUP(A160,Municipalities!A154:B323,2))","v":""}]
[null,{"$f":"IF(A161=\"\",\"\",VLOOKUP(A161,Municipalities!A155:B324,2))","v":""}]
[null,{"$f":"IF(A162=\"\",\"\",VLOOKUP(A162,Municipalities!A156:B325,2))","v":""}]
[null,{"$f":"IF(A163=\"\",\"\",VLOOKUP(A163,Municipalities!A157:B326,2))","v":""}]
[null,{"$f":"IF(A164=\"\",\"\",VLOOKUP(A164,Municipalities!A158:B327,2))","v":""}]
[null,{"$f":"IF(A165=\"\",\"\",VLOOKUP(A165,Municipalities!A159:B328,2))","v":""}]
[null,{"$f":"IF(A166=\"\",\"\",VLOOKUP(A166,Municipalities!A160:B329,2))","v":""}]
[null,{"$f":"IF(A167=\"\",\"\",VLOOKUP(A167,Municipalities!A161:B330,2))","v":""}]
[null,{"$f":"IF(A168=\"\",\"\",VLOOKUP(A168,Municipalities!A162:B331,2))","v":""}]
[null,{"$f":"IF(A169=\"\",\"\",VLOOKUP(A169,Municipalities!A163:B332,2))","v":""}]
[null,{"$f":"IF(A170=\"\",\"\",VLOOKUP(A170,Municipalities!A164:B333,2))","v":""}]

{"sheet":"LayoutFields","index":1,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["DEFAULT LAYOUT- DISAGGREGATED SALE AND USE TAX\nCOMMA SEPARATED VALUE FILE"]
["FIELD","MAX LENGTH","DESCRIPTION"]
["CT TAX REG NUMBER",13,"NUMERIC"]
["PERIOD END",10,"FORMAT MM/DD/YYYY"]
["MUNICIPALITY CODE",3,"NUMERIC"]
["MUNICIPALITY CODE DESCRIPTION",25,"TEXT"]
["PERIOD 1 TAX REPORTED (JUL 1-SEPT 30)",13,"NUMERIC"]
["PERIOD 2 TAX REPORTED (OCT 1-DEC 31)",13,"NUMERIC"]
["PERIOD 3 TAX REPORTED (JAN 1-MAR 31)",13,"NUMERIC"]
["PERIOD 4 TAX REPORTED (APR 1-JUN 30)",13,"NUMERIC"]

{"sheet":"Municipalities","index":2,"n_rows":171,"n_cols":2,"rows_kept":171,"cut":false,"hidden":false,"merged":[]}
["MUNICIPALITYCODE","MUNICIPALITYDESCRIPTION"]
["001","ANDOVER"]
["002","ANSONIA"]
["003","ASHFORD"]
["004","AVON"]
["005","BARKHAMSTED"]
["006","BEACON FALLS"]
["007","BERLIN"]
["008","BETHANY"]
["009","BETHEL"]
["010","BETHLEHEM"]
["011","BLOOMFIELD"]
["012","BOLTON"]
["013","BOZRAH"]
["014","BRANFORD"]
["015","BRIDGEPORT"]
["016","BRIDGEWATER"]
["017","BRISTOL"]
["018","BROOKFIELD"]
["019","BROOKLYN"]
["020","BURLINGTON"]
["021","CANAAN"]
["022","CANTERBURY"]
["023","CANTON"]
["024","CHAPLIN"]
["025","CHESHIRE"]
["026","CHESTER"]
["027","CLINTON"]
["028","COLCHESTER"]
["029","COLEBROOK"]
["030","COLUMBIA"]
["031","CORNWALL"]
["032","COVENTRY"]
["033","CROMWELL"]
["034","DANBURY"]
["035","DARIEN"]
["036","DEEP RIVER"]
["037","DERBY"]
["038","DURHAM"]
["039","EASTFORD"]
["040","EAST GRANBY"]
["041","EAST HADDAM"]
["042","EAST HAMPTON"]
["043","EAST HARTFORD"]
["044","EAST HAVEN"]
["045","EAST LYME"]
["046","EASTON"]
["047","EAST WINDSOR"]
["048","ELLINGTON"]
["049","ENFIELD"]
["050","ESSEX"]
["051","FAIRFIELD"]
["052","FARMINGTON"]
["053","FRANKLIN"]
["054","GLASTONBURY"]
["055","GOSHEN"]
["056","GRANBY"]
["057","GREENWICH"]
["058","GRISWOLD"]
["059","GROTON"]
["060","GUILFORD"]
["061","HADDAM"]
["062","HAMDEN"]
["063","HAMPTON"]
["064","HARTFORD"]
["065","HARTLAND"]
["066","HARWINTON"]
["067","HEBRON"]
["068","KENT"]
["069","KILLINGLY"]
["070","KILLINGWORTH"]
["071","LEBANON"]
["072","LEDYARD"]
["073","LISBON"]
["074","LITCHFIELD"]
["075","LYME"]
["076","MADISON"]
["077","MANCHESTER"]
["078","MANSFIELD"]
["079","MARLBOROUGH"]
["080","MERIDEN"]
["081","MIDDLEBURY"]
["082","MIDDLEFIELD"]
["083","MIDDLETOWN"]
["084","MILFORD"]
["085","MONROE"]
["086","MONTVILLE"]
["087","MORRIS"]
["088","NAUGATUCK"]
["089","NEW BRITAIN"]
["090","NEW CANAAN"]
["091","NEW FAIRFIELD"]
["092","NEW HARTFORD"]
["093","NEW HAVEN"]
["094","NEWINGTON"]
["095","NEW LONDON"]
["096","NEW MILFORD"]
["097","NEWTOWN"]
["098","NORFOLK"]
["099","NORTH BRANFORD"]
["100","NORTH CANAAN"]
["101","NORTH HAVEN"]
["102","NORTH STONINGTON"]
["103","NORWALK"]
["104","NORWICH"]
["105","OLD LYME"]
["106","OLD SAYBROOK"]
["107","ORANGE"]
["108","OXFORD"]
["109","PLAINFIELD"]
["110","PLAINVILLE"]
["111","PLYMOUTH"]
["112","POMFRET"]
["113","PORTLAND"]
["114","PRESTON"]
["115","PROSPECT"]
["116","PUTNAM"]
["117","REDDING"]
["118","RIDGEFIELD"]
["119","ROCKY HILL"]
["120","ROXBURY"]
["121","SALEM"]
["122","SALISBURY"]
["123","SCOTLAND"]
["124","SEYMOUR"]
["125","SHARON"]
["126","SHELTON"]
["127","SHERMAN"]
["128","SIMSBURY"]
["129","SOMERS"]
["130","SOUTHBURY"]
["131","SOUTHINGTON"]
["132","SOUTH WINDSOR"]
["133","SPRAGUE"]
["134","STAFFORD"]
["135","STAMFORD"]
["136","STERLING"]
["137","STONINGTON"]
["138","STRATFORD"]
["139","SUFFIELD"]
["140","THOMASTON"]
["141","THOMPSON"]
["142","TOLLAND"]
["143","TORRINGTON"]
["144","TRUMBULL"]
["145","UNION"]
["146","VERNON"]
["147","VOLUNTOWN"]
["148","WALLINGFORD"]
["149","WARREN"]
["150","WASHINGTON"]
["151","WATERBURY"]
["152","WATERFORD"]
["153","WATERTOWN"]
["154","WESTBROOK"]
["155","WEST HARTFORD"]
["156","WEST HAVEN"]
["157","WESTON"]
["158","WESTPORT"]
["159","WETHERSFIELD"]
["160","WILLINGTON"]
["161","WILTON"]
["162","WINCHESTER"]
["163","WINDHAM"]
["164","WINDSOR"]
["165","WINDSOR LOCKS"]
["166","WOLCOTT"]
["167","WOODBRIDGE"]
["168","WOODBURY"]
["169","WOODSTOCK"]
["170","OUT OF STATE"]

{"sheet":"Instructions","index":3,"n_rows":24,"n_cols":1,"rows_kept":24,"cut":false,"hidden":false,"merged":[[16,0,17,0]]}
["The below instructions are for creating your file(s) in the required Excel format using the default \"Delimited File\" option that utilizes a common separated value (.csv ) file layout."]
[]
["Disaggregated sales tax is the separately stated amount of sales tax collected by a retailer in each municipality where the business maintains a location.\n\nConsolidated sales tax filer is a retail business that:\n•Has two or more establishments for which a Connecticut Sales and Use Tax Permit (seller’s permit) is required;\n•Has been issued two or more seller’s permits; and\n•Files a single OS-114, Sales and Use Tax Return, to report and pay any sales tax to DRS.\n\nFiling a Disaggregated Sales Tax Report: Consolidated sales tax filers are required to annually file a Disaggregated Sales Tax Report with DRS, with the first such report due by October 1 following the fiscal year end.\n"]
[]
[]
["When you click on cell, an \"informational\" box may pop up. You can click and drag the box anywhere on the screen."]
[]
["Do not use special characters such as commas ( , ) and pound signs ( # ) when entering information in the worksheet. "]
[]
["1.  Enter company name or a unique identifier here- this will be part of the file name being created."]
["On line 3 (cell B2) enter the Company name for your file. Do not use special characters, commas or periods.  This will later be part of the file name when the .csv file is created."]
[]
["2.  Enter your CT Registration Number in Cell B3"]
[]
["3.  Enter the Period End of this filing in Cell B4.  All period end should be fiscal year ending in June"]
[]
["4. ENTER YOUR DISAGGREGATED SALES TAX INFO.  Starting in cell A8 enter your Municipality information."]
[]
[]
["5. SAVE YOUR WORK.  Save this Excel spreadsheet. If there are any issues with the file upload, you will need  to return to this spreadsheet for ANY updates.\n\n*** If there are errors in the .csv file, make corrections to the excel spreadsheet and recreate a new .csv file."]
[]
["Once you have completed entering all your Disaggregates Sales Tax into the Excel spreadsheet you will then need to create an uploadable .csv file that the TSC will be able to process.  "]
[]
["6. CREATE THE CSV FILE.  Click the \"Create Uploadable CSV \" button. This will automatically create the .csv file.  Choose a file location for this file and save. \n***Remember this location so you are able to return to it. Do not change the file name."]