{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Settings","Budgets","Budget Menu","Budget Detail","Lookup Accounts","Lookup Departments","Lookup Branches"],"not_rendered":{"images":5,"macros":1,"defined_names":46,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Settings","index":0,"n_rows":16,"n_cols":6,"rows_kept":16,"merged":[[14,5,16,11]]}
[null,null,"ID40 Budget Export, Import and Update Utility version 2022.10.27"]
[]
[null,null,"eAuto Production DB Name","Server",null,"When clicking on export to import buttons on other sheets user will be prompted to log in with user name and password."]
[null,null,"coLIVE","eAuto Server Name"]
[{"$nulls":5},"Note: the user name and password are for a valid SQL Server login"]
[]
[]
[null,null,"Filters:"]
[null,null,"Column"]
[{"$nulls":5},"We can add some filters here to limit the amount of data exported  in addition to the budget name"]
[]
[]
[]
[]
[null,null,"Other Settings:",null,null,"leave blank to process all records regardless of local change detection, or change to YES to only process rows where Excel detected a possible local change to one of the row values."]
[null,null,"Process Locally Dectected Changes Only","YES"]

{"sheet":"Budgets","index":1,"n_rows":8,"n_cols":9,"rows_kept":8}
[{"$f":"Settings!C1","v":"ID40 Budget Export, Import and Update Utility version 2022.10.27"}]
["List of existing Budgets in e-automate"]
[]
[]
[]
[]
[]
["BudgetID","BudgetName","Remarks","BudgetNumber","Active","CreatorID","UpdatorID","CreateDate","LastUpdate"]

{"sheet":"Budget Menu","index":2,"n_rows":13,"n_cols":11,"rows_kept":13}
[null,{"$f":"Settings!C1","v":"ID40 Budget Export, Import and Update Utility version 2022.10.27"}]
[null,"Selected Budget:",{"$f":"IF(BUDGET_NAME=0,\"\",BUDGET_NAME)","v":""}]
[]
[]
[]
["Description","Number","Name","Source Year","Budget Year","Revenue %","COGS %","Expense %","Options"]
[{"$nulls":10},"create a new blank budget w/o details"]
[]
[{"$nulls":10},"create new budget w/details based on financials"]
[]
[{"$nulls":10},"edit previously created budget on Budget Details worksheet"]
[]
[{"$nulls":10},"this option will overwrite existing budget"]

{"sheet":"Budget Detail","index":3,"n_rows":8,"n_cols":33,"rows_kept":8}
[{"$f":"Settings!C1","v":"ID40 Budget Export, Import and Update Utility version 2022.10.27"},{"$nulls":3},"Selected Budget:",{"$f":"BUDGET_NAME","v":0}]
[{"$nulls":4},"Period Year:",2020]
[null,"Process Locally Dectected Changes Only",{"$f":"IF(LOCAL_EDITS_ONLY=\"YES\",1,0)","v":1}]
[null,"THESE COLUMNS CANNOT BE UPDATED","*EXCEPT FOR NEW INSERTS"]
[null,"THESE COLUMNS CAN BE UPDATED",null,"Visible Row Multiplier %"]
[null,"THESE COLUMNS ARE REQUIRED FOR NEW BUDGET DETAIL RECORDS"]
[{"$nulls":5},"* required for new insert",null,null,"* optional for new insert",null,"* required for new insert"]
["Status","Error Message","Post Action","Local Edits Detected","BudgetName","AccountNumber","AccountName","AccountType","DeptNumber","DeptName","BranchNumber","BranchName","PeriodYear","Period01","Period02","Period03","Period04","Period05","Period06","Period07","Period08","Period09","Period10","Period11","Period12","Period13","AllPeriods","MinBudgetDetailID","BudgetID","GLID","DeptID","BranchID","DivisionID"]

{"sheet":"Lookup Accounts","index":4,"n_rows":320,"n_cols":7,"rows_kept":320,"hidden":true}
["AccountID","AccountNumber","AccountTypeID","Locks",null,null,{"$f":"Table_GLAccounts[[#Totals],[Locks]]","v":318}]
[1,"8818101000",3,1]
[2,"8818101020",3,0]
[3,"8818111100",1,3]
[365,"8818111112",1,0]
[6,"8818111115",3,0]
[376,"8818111130",1,0]
[11,"8818111150",1,0]
[13,"8818121200",2,1]
[14,"8818121201",3,0]
[283,"8818121202",2,0]
[15,"8818121206",2,1]
[16,"8818121210",2,1]
[17,"8818141410",3,0]
[18,"8818141420",3,0]
[19,"8818141430",3,0]
[20,"8818141450",3,0]
[21,"8818141460",3,0]
[22,"8818151500",3,0]
[23,"8818151550",3,0]
[24,"8818161600",18,0]
[25,"8818161602",18,0]
[26,"8818161605",18,0]
[314,"8818161607",18,0]
[27,"8818161610",18,0]
[28,"8818161620",18,1]
[398,"8818161700",18,0]
[29,"8818171700",3,0]
[30,"8818181800",3,0]
[31,"8818181850",3,0]
[32,"8828202012",3,0]
[33,"8828212100",4,0]
[345,"8828212101",4,0]
[367,"8828212105",4,0]
[373,"8828212106",4,0]
[394,"8828212107",4,0]
[34,"8828212110",4,0]
[35,"8828212150",4,0]
[36,"8828212170",4,0]
[298,"8828212175",4,0]
[299,"8828212180",4,0]
[300,"8828212185",4,0]
[305,"8828212190",4,0]
[37,"8828222200",4,0]
[354,"8828222205",4,0]
[38,"8828232300",13,0]
[346,"8828232301",13,0]
[369,"8828232305",13,0]
[375,"8828232306",13,0]
[395,"8828232307",13,0]
[355,"8828232310",13,0]
[356,"8828232350",13,0]
[357,"8828232370",13,0]
[358,"8828232375",13,0]
[359,"8828232380",13,0]
[360,"8828232385",13,0]
[361,"8828232391",13,0]
[362,"8828232392",13,0]
[39,"8828242400",4,0]
[40,"8828252500",19,0]
[41,"8828252520",19,0]
[42,"8828252530",19,0]
[43,"8828262600",19,0]
[44,"8838303000",6,0]
[344,"8838303001",6,0]
[45,"8838303050",6,0]
[46,"8838303060",6,0]
[288,"8838303061",6,0]
[49,"8838303075",6,0]
[62,"8838323200",5,1]
[63,"8838323202",5,1]
[64,"8838323203",6,0]
[311,"8838323204",6,0]
[65,"8838323205",6,1]
[66,"8838323206",6,0]
[67,"8838323207",6,0]
[68,"8838323208",6,0]
[307,"8838323209",6,0]
[372,"8838323213",6,0]
[310,"8838323215",6,0]
[371,"8838323216",6,0]
[377,"8838323217",6,0]
[72,"8838323220",6,0]
[73,"8838323221",6,0]
[74,"8838323222",6,0]
[75,"8838323225",6,0]
[76,"8838323227",6,0]
[77,"8838323235",5,1]
[78,"8838333310",6,0]
[79,"8838333320",6,0]
[80,"8838333330",6,3]
[81,"8838333380",6,0]
[82,"8838333381",6,0]
[83,"8838353500",6,0]
[84,"8838353520",6,0]
[85,"8848404000",7,0]
[97,"8858505000",8,0]
[98,"8858505060",8,0]
[99,"8858515100",8,0]
[100,"8858515101",8,0]
[101,"8858515102",8,0]
[102,"8858515103",8,0]
[103,"8858515105",14,0]
[104,"8858515106",14,0]
[105,"8858515110",14,0]
[106,"8858515112",14,0]
[107,"8858515120",14,0]
[108,"8858515130",14,0]
[110,"8868606010",9,1]
[112,"8868606012",9,0]
[113,"8868606013",9,0]
[114,"8868606014",9,0]
[116,"8868606016",9,0]
[117,"8868606017",9,0]
[118,"8868606018",9,0]
[119,"8868606019",9,0]
[120,"8868606020",9,0]
[121,"8868606021",9,0]
[123,"8868606023",9,0]
[126,"8868606026",9,0]
[127,"8868606027",9,0]
[129,"8868606030",9,0]
[133,"8868606035",9,0]
[134,"8868606036",9,0]
[351,"8868606037",9,0]
[136,"8868606040",9,0]
[137,"8868606050",9,0]
[139,"8868606052",9,0]
[140,"8868606055",9,0]
[285,"8868606076",9,0]
[141,"8868606077",9,0]
[142,"8868606078",9,0]
[286,"8868606079",9,0]
[143,"8868606080",9,0]
[144,"8868606081",9,0]
[145,"8868616110",9,0]
[284,"8868616150",9,0]
[146,"8868616160",9,0]
[315,"8868646410",9,0]
[316,"8868646412",9,0]
[317,"8868646413",9,0]
[319,"8868646415",9,0]
[343,"8868646420",9,0]
[364,"8868646421",9,0]
[384,"8868646422",9,0]
[320,"8868646431",9,0]
[321,"8868646433",9,0]
[322,"8868646435",9,0]
[378,"8868646436",9,0]
[379,"8868646437",9,0]
[380,"8868646438",9,0]
[342,"8868646450",9,0]
[323,"8868646451",9,0]
[324,"8868646452",9,0]
[325,"8868646453",9,0]
[326,"8868646454",9,0]
[386,"8868646461",9,0]
[387,"8868646462",9,0]
[388,"8868646463",9,0]
[389,"8868646464",9,0]
[327,"8868646471",9,0]
[328,"8868646472",9,0]
[329,"8868646473",9,0]
[330,"8868646474",9,0]
[340,"8868646490",9,0]
[148,"8878707010",10,0]
[352,"8878707011",10,0]
[150,"8878707012",10,0]
[151,"8878707013",10,0]
[152,"8878707014",10,0]
[295,"8878707016",10,0]
[154,"8878707017",10,0]
[370,"8878707018",10,0]
[155,"8878707019",10,0]
[156,"8878707020",10,0]
[157,"8878707021",10,0]
[159,"8878707023",10,0]
[162,"8878707026",10,0]
[396,"8878707027",10,0]
[374,"8878707029",10,0]
[164,"8878707030",10,0]
[166,"8878707035",10,0]
[353,"8878707037",10,0]
[167,"8878707050",10,0]
[169,"8878707052",10,0]
[170,"8878707055",10,0]
[171,"8878707077",10,0]
[172,"8878707080",10,0]
[302,"8878707081",10,0]
[173,"8878707085",10,0]
[174,"8878707090",10,0]
[175,"8878707091",10,0]
[176,"8878707095",10,0]
[177,"8878717110",10,0]
[183,"8878737305",10,0]
[308,"8878737306",10,0]
[186,"8878737312",10,0]
[191,"8878737318",10,0]
[297,"8878737319",10,0]
[194,"8878737322",10,0]
[313,"8878737330",10,0]
[196,"8878747400",10,0]
[197,"8878747401",10,0]
[198,"8878747402",10,2]
[199,"8878747410",10,0]
[331,"8878747411",10,0]
[332,"8878747412",10,0]
[333,"8878747413",10,0]
[335,"8878747415",10,0]
[200,"8878747420",10,0]
[385,"8878747422",10,0]
[381,"8878747436",10,0]
[382,"8878747437",10,0]
[383,"8878747438",10,0]
[347,"8878747451",10,0]
[348,"8878747452",10,0]
[349,"8878747453",10,0]
[350,"8878747454",10,0]
[390,"8878747461",10,0]
[391,"8878747462",10,0]
[392,"8878747463",10,0]
[393,"8878747464",10,0]
[336,"8878747471",10,0]
[337,"8878747472",10,0]
[338,"8878747473",10,0]
[339,"8878747474",10,0]
[341,"8878747490",10,0]
[202,"8878787806",11,1]
[203,"8878787807",11,1]
[204,"8878797900",10,0]
[301,"8878797901",10,0]
[206,"8888808000",11,0]
[207,"8888808010",11,0]
[208,"8888808011",11,0]
[209,"8888808012",11,0]
[289,"8888808013",11,0]
[210,"8888808015",11,0]
[306,"8888808016",11,0]
[212,"8888808025",11,0]
[213,"8888808030",11,0]
[214,"8888808040",11,0]
[215,"8888808050",11,0]
[216,"8888808060",11,0]
[217,"8888808061",11,0]
[218,"8888808070",11,1]
[290,"8888808071",11,0]
[219,"8888808075",11,0]
[220,"8888808080",11,0]
[291,"8888808081",11,0]
[221,"8888808085",11,0]
[222,"8888808090",11,0]
[223,"8888818100",11,0]
[303,"8888818102",11,0]
[224,"8888818105",11,0]
[225,"8888818108",11,0]
[226,"8888818110",11,1]
[287,"8888818111",11,0]
[363,"8888818112",11,0]
[227,"8888818120",11,0]
[228,"8888818130",11,0]
[229,"8888818134",11,0]
[230,"8888818135",11,0]
[231,"8888818136",11,0]
[292,"8888818137",11,0]
[232,"8888818140",11,0]
[233,"8888818150",11,0]
[293,"8888818155",11,0]
[234,"8888818160",11,0]
[235,"8888818165",11,0]
[236,"8888818170",11,0]
[237,"8888818180",11,0]
[238,"8888818190",11,0]
[304,"8888818191",11,0]
[239,"8888818195",11,0]
[240,"8888818196",11,0]
[241,"8888828200",11,0]
[242,"8888828210",11,0]
[243,"8888828215",11,0]
[244,"8888828216",11,0]
[248,"8888828230",11,0]
[249,"8888828240",11,1]
[366,"8888828245",11,0]
[250,"8888828250",11,0]
[294,"8888828255",11,0]
[251,"8888828260",11,0]
[252,"8888828270",11,0]
[309,"8888828275",11,0]
[253,"8888828280",11,0]
[254,"8888828290",11,0]
[255,"8888828295",11,0]
[256,"8888838300",11,0]
[257,"8888838310",11,0]
[258,"8888838315",11,0]
[259,"8888838320",11,0]
[260,"8888838330",11,0]
[261,"8888838335",11,0]
[262,"8888838340",11,0]
[263,"8888838345",11,0]
[264,"8888838350",11,0]
[265,"8888838355",11,0]
[296,"8888838356",11,0]
[266,"8888838360",11,0]
[267,"8888838370",11,0]
[268,"8888838390",11,0]
[397,"8888848421",10,0]
[269,"8888878700",15,0]
[312,"8888878705",15,0]
[270,"8888878710",15,0]
[271,"8888878711",15,0]
[272,"8888878712",15,0]
[273,"8888878713",15,0]
[274,"8888878715",15,0]
[275,"8888878720",15,1]
[276,"8888878730",15,0]
[277,"8888878740",15,0]
[278,"8888888800",16,0]
[279,"8888888810",16,1]
[280,"8888888820",16,0]
[281,"8898909000",14,0]
["Total",null,null,{"$f":"SUBTOTAL(103,Table_GLAccounts[Locks])","v":318}]

{"sheet":"Lookup Departments","index":5,"n_rows":21,"n_cols":6,"rows_kept":21,"hidden":true}
["DeptID","DeptNumber","Locks",null,null,{"$f":"Table_GLDepts[[#Totals],[Locks]]","v":19}]
[1,"0",0]
[90,"110-00-00-00",0]
[65,"200-00-00-00",0]
[89,"300-00-00-00",0]
[14,"300-00-10-10",0]
[15,"300-00-10-20",0]
[16,"300-00-20-10",0]
[17,"300-00-30-10",0]
[18,"300-00-40-10",0]
[19,"300-00-40-20",0]
[20,"300-00-50-40",0]
[21,"300-00-50-50",0]
[75,"400-00-00-00",0]
[125,"400-00-10-10",0]
[91,"500-00-50-50",0]
[126,"500-00-60-60",0]
[123,"800-00-00-00",0]
[42,"900-00-00-00",0]
[124,"970-00-00-00",0]
["Total",null,{"$f":"SUBTOTAL(103,Table_GLDepts[Locks])","v":19}]

{"sheet":"Lookup Branches","index":6,"n_rows":6,"n_cols":6,"rows_kept":6,"hidden":true}
["BranchID","BranchNumber","MainBranch",null,null,{"$f":"Table_GLBranches[[#Totals],[MainBranch]]","v":4}]
[2,"<Split>",false]
[1,"Branch 1",true]
[101,"Branch 101",false]
[102,"Branch 102",false]
["Total",null,{"$f":"SUBTOTAL(103,Table_GLBranches[MainBranch])","v":4}]