{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["SavedStyles","Journal","REPORT","Debug","SavedSettings"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":561,"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":"SavedStyles","index":0,"n_rows":54,"n_cols":1,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
["QSP_TITLE"]
["Currency"]
["Normal"]
["Normal_Background"]
["Normal_Blank"]
["Normal_Options"]
["Percent"]
["QSP_ACCT"]
["QSP_ANAL"]
["QSP_BAL"]
["QSP_BTCH_DATE"]
["QSP_BTCH_REF"]
["QSP_BTCH_TYPE"]
["QSP_CMPY"]
["QSP_COST_SRCE"]
["QSP_COST_SRCE_CMPY"]
["QSP_COST_TRGT"]
["QSP_COST_TRGT_CMPY"]
["QSP_CURR"]
["QSP_CURR_VAL"]
["QSP_DATE"]
["QSP_DEFAULT"]
["QSP_DESCR"]
["QSP_DEST_CMPY"]
["QSP_DETL_LABEL"]
["QSP_DETL_LABEL_HIDE"]
["QSP_DETL_RATE_TYPE"]
["QSP_DETL_TOTAL_COLMN"]
["QSP_ELEM"]
["QSP_ERR"]
["QSP_ERR_DATE"]
["QSP_ERR_VAL"]
["QSP_EXCH_RATE"]
["QSP_FNCL_VAL"]
["QSP_HDR_EXCH_RATE"]
["QSP_HDR_FNCL_VAL"]
["QSP_HDR_LABEL"]
["QSP_HDR_RATE_TYPE"]
["QSP_MCA"]
["QSP_NUM_OF_TRANS"]
["QSP_PER"]
["QSP_PROT_CURR_VAL"]
["QSP_PROT_VAL"]
["QSP_QTY"]
["QSP_RECON"]
["QSP_REF_NUM"]
["QSP_REPORT"]
["QSP_TAX_CODE"]
["QSP_TAX_LOCTN"]
["QSP_TAX_TYPE"]
["Comma"]
["QSP_TRGT_SCTY_GRP"]
["QSP_UOM"]
["QSP_YY_IND"]

{"sheet":"Journal","index":1,"n_rows":2018,"n_cols":247,"rows_kept":2018,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Advanced - Journal Upload"]
[]
["Company:","CU -  Cumberland Council                     "]
["Batch Type:","","Batch Ref:"]
["Description:"]
["Batch Date:",null,"Period:"]
["Year:","THIS","No of Periods:"]
["BTZ Element:","",null,null," No Trans:"]
[]
["Currency Code:","","Rate Type:",""]
["Effective Date:",null,null,null,null," Debits"," Credits"]
["Value Date:",null,"Accrual Period:",null," Base:"]
["Security Group:","","Accrual Year:","THIS"," Foreign:"]
["Balance Class:",""]
[]
[null,"COST CEN","NOMINAL","FUND","PROJECT","EMPLOYEE","DETAIL","Financial Value","Currency","Description","Quantity","Unit of Measure","Reference Number","Tax Code","Tax Type","Tax Location","Reconciliation code","Rate Type","Effective Date","Exchange Rate","Transaction Date","Destination Cmpy","Cost Source Company","Cost Source","Cost Target Company","Cost Target","MCA","Project"]
[null,"QSP_ACCT","QSP_ACCT","QSP_ACCT","QSP_ACCT","QSP_ANAL","QSP_ANAL","QSP_FNCL_VAL","QSP_CURR_VAL","QSP_DESCR","QSP_QTY","QSP_UOM","QSP_REF_NUM","QSP_TAX_CODE","QSP_TAX_TYPE","QSP_TAX_LOCTN","QSP_RECON","QSP_DETL_RATE_TYPE","QSP_DATE","QSP_EXCH_RATE","QSP_DATE","QSP_DEST_CMPY","QSP_COST_SRCE_CMPY","QSP_COST_SRCE","QSP_COST_TRGT_CMPY","QSP_COST_TRGT","QSP_MCA","QSP_DEFAULT"]
[null,7,5,4,9,8,12,{"$f":"SUM( $H$19:$H$2018)","v":0},{"$f":"SUM( $I$19:$I$2018)","v":0},40,15,4,9,3,3,10,12,2,10,15,10,2,2,4,2,4,6,20]
[1]
[2]
[3]
[4]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Originator:"]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[259]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[323]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[387]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[447]
[448]
[449]
[450]
[451]
[452]
[453]
[454]
[455]
[456]
[457]
[458]
[459]
[460]
[461]
[462]
[463]
[464]
[465]
[466]
[467]
[468]
[469]
[470]
[471]
[472]
[473]
[474]
[475]
[476]
[477]
[478]
[479]
[480]
[481]
[482]
[483]
[484]
[485]
[486]
[487]
[488]
[489]
[490]
[491]
[492]
[493]
[494]
[495]
[496]
[497]
[498]
[499]
[500]
[501]
[502]
[503]
[504]
[505]
[506]
[507]
[508]
[509]
[510]
[511]
[512]
[513]
[514]
[515]
[516]
[517]
[518]
[519]
[520]
[521]
[522]
[523]
[524]
[525]
[526]
[527]
[528]
[529]
[530]
[531]
[532]
[533]
[534]
[535]
[536]
[537]
[538]
[539]
[540]
[541]
[542]
[543]
[544]
[545]
[546]
[547]
[548]
[549]
[550]
[551]
[552]
[553]
[554]
[555]
[556]
[557]
[558]
[559]
[560]
[561]
[562]
[563]
[564]
[565]
[566]
[567]
[568]
[569]
[570]
[571]
[572]
[573]
[574]
[575]
[576]
[577]
[578]
[579]
[580]
[581]
[582]
[583]
[584]
[585]
[586]
[587]
[588]
[589]
[590]
[591]
[592]
[593]
[594]
[595]
[596]
[597]
[598]
[599]
[600]
[601]
[602]
[603]
[604]
[605]
[606]
[607]
[608]
[609]
[610]
[611]
[612]
[613]
[614]
[615]
[616]
[617]
[618]
[619]
[620]
[621]
[622]
[623]
[624]
[625]
[626]
[627]
[628]
[629]
[630]
[631]
[632]
[633]
[634]
[635]
[636]
[637]
[638]
[639]
[640]
[641]
[642]
[643]
[644]
[645]
[646]
[647]
[648]
[649]
[650]
[651]
[652]
[653]
[654]
[655]
[656]
[657]
[658]
[659]
[660]
[661]
[662]
[663]
[664]
[665]
[666]
[667]
[668]
[669]
[670]
[671]
[672]
[673]
[674]
[675]
[676]
[677]
[678]
[679]
[680]
[681]
[682]
[683]
[684]
[685]
[686]
[687]
[688]
[689]
[690]
[691]
[692]
[693]
[694]
[695]
[696]
[697]
[698]
[699]
[700]
[701]
[702]
[703]
[704]
[705]
[706]
[707]
[708]
[709]
[710]
[711]
[712]
[713]
[714]
[715]
[716]
[717]
[718]
[719]
[720]
[721]
[722]
[723]
[724]
[725]
[726]
[727]
[728]
[729]
[730]
[731]
[732]
[733]
[734]
[735]
[736]
[737]
[738]
[739]
[740]
[741]
[742]
[743]
[744]
[745]
[746]
[747]
[748]
[749]
[750]
[751]
[752]
[753]
[754]
[755]
[756]
[757]
[758]
[759]
[760]
[761]
[762]
[763]
[764]
[765]
[766]
[767]
[768]
[769]
[770]
[771]
[772]
[773]
[774]
[775]
[776]
[777]
[778]
[779]
[780]
[781]
[782]
[783]
[784]
[785]
[786]
[787]
[788]
[789]
[790]
[791]
[792]
[793]
[794]
[795]
[796]
[797]
[798]
[799]
[800]
[801]
[802]
[803]
[804]
[805]
[806]
[807]
[808]
[809]
[810]
[811]
[812]
[813]
[814]
[815]
[816]
[817]
[818]
[819]
[820]
[821]
[822]
[823]
[824]
[825]
[826]
[827]
[828]
[829]
[830]
[831]
[832]
[833]
[834]
[835]
[836]
[837]
[838]
[839]
[840]
[841]
[842]
[843]
[844]
[845]
[846]
[847]
[848]
[849]
[850]
[851]
[852]
[853]
[854]
[855]
[856]
[857]
[858]
[859]
[860]
[861]
[862]
[863]
[864]
[865]
[866]
[867]
[868]
[869]
[870]
[871]
[872]
[873]
[874]
[875]
[876]
[877]
[878]
[879]
[880]
[881]
[882]
[883]
[884]
[885]
[886]
[887]
[888]
[889]
[890]
[891]
[892]
[893]
[894]
[895]
[896]
[897]
[898]
[899]
[900]
[901]
[902]
[903]
[904]
[905]
[906]
[907]
[908]
[909]
[910]
[911]
[912]
[913]
[914]
[915]
[916]
[917]
[918]
[919]
[920]
[921]
[922]
[923]
[924]
[925]
[926]
[927]
[928]
[929]
[930]
[931]
[932]
[933]
[934]
[935]
[936]
[937]
[938]
[939]
[940]
[941]
[942]
[943]
[944]
[945]
[946]
[947]
[948]
[949]
[950]
[951]
[952]
[953]
[954]
[955]
[956]
[957]
[958]
[959]
[960]
[961]
[962]
[963]
[964]
[965]
[966]
[967]
[968]
[969]
[970]
[971]
[972]
[973]
[974]
[975]
[976]
[977]
[978]
[979]
[980]
[981]
[982]
[983]
[984]
[985]
[986]
[987]
[988]
[989]
[990]
[991]
[992]
[993]
[994]
[995]
[996]
[997]
[998]
[999]
[1000]
[1001]
[1002]
[1003]
[1004]
[1005]
[1006]
[1007]
[1008]
[1009]
[1010]
[1011]
[1012]
[1013]
[1014]
[1015]
[1016]
[1017]
[1018]
[1019]
[1020]
[1021]
[1022]
[1023]
[1024]
[1025]
[1026]
[1027]
[1028]
[1029]
[1030]
[1031]
[1032]
[1033]
[1034]
[1035]
[1036]
[1037]
[1038]
[1039]
[1040]
[1041]
[1042]
[1043]
[1044]
[1045]
[1046]
[1047]
[1048]
[1049]
[1050]
[1051]
[1052]
[1053]
[1054]
[1055]
[1056]
[1057]
[1058]
[1059]
[1060]
[1061]
[1062]
[1063]
[1064]
[1065]
[1066]
[1067]
[1068]
[1069]
[1070]
[1071]
[1072]
[1073]
[1074]
[1075]
[1076]
[1077]
[1078]
[1079]
[1080]
[1081]
[1082]
[1083]
[1084]
[1085]
[1086]
[1087]
[1088]
[1089]
[1090]
[1091]
[1092]
[1093]
[1094]
[1095]
[1096]
[1097]
[1098]
[1099]
[1100]
[1101]
[1102]
[1103]
[1104]
[1105]
[1106]
[1107]
[1108]
[1109]
[1110]
[1111]
[1112]
[1113]
[1114]
[1115]
[1116]
[1117]
[1118]
[1119]
[1120]
[1121]
[1122]
[1123]
[1124]
[1125]
[1126]
[1127]
[1128]
[1129]
[1130]
[1131]
[1132]
[1133]
[1134]
[1135]
[1136]
[1137]
[1138]
[1139]
[1140]
[1141]
[1142]
[1143]
[1144]
[1145]
[1146]
[1147]
[1148]
[1149]
[1150]
[1151]
[1152]
[1153]
[1154]
[1155]
[1156]
[1157]
[1158]
[1159]
[1160]
[1161]
[1162]
[1163]
[1164]
[1165]
[1166]
[1167]
[1168]
[1169]
[1170]
[1171]
[1172]
[1173]
[1174]
[1175]
[1176]
[1177]
[1178]
[1179]
[1180]
[1181]
[1182]
[1183]
[1184]
[1185]
[1186]
[1187]
[1188]
[1189]
[1190]
[1191]
[1192]
[1193]
[1194]
[1195]
[1196]
[1197]
[1198]
[1199]
[1200]
[1201]
[1202]
[1203]
[1204]
[1205]
[1206]
[1207]
[1208]
[1209]
[1210]
[1211]
[1212]
[1213]
[1214]
[1215]
[1216]
[1217]
[1218]
[1219]
[1220]
[1221]
[1222]
[1223]
[1224]
[1225]
[1226]
[1227]
[1228]
[1229]
[1230]
[1231]
[1232]
[1233]
[1234]
[1235]
[1236]
[1237]
[1238]
[1239]
[1240]
[1241]
[1242]
[1243]
[1244]
[1245]
[1246]
[1247]
[1248]
[1249]
[1250]
[1251]
[1252]
[1253]
[1254]
[1255]
[1256]
[1257]
[1258]
[1259]
[1260]
[1261]
[1262]
[1263]
[1264]
[1265]
[1266]
[1267]
[1268]
[1269]
[1270]
[1271]
[1272]
[1273]
[1274]
[1275]
[1276]
[1277]
[1278]
[1279]
[1280]
[1281]
[1282]
[1283]
[1284]
[1285]
[1286]
[1287]
[1288]
[1289]
[1290]
[1291]
[1292]
[1293]
[1294]
[1295]
[1296]
[1297]
[1298]
[1299]
[1300]
[1301]
[1302]
[1303]
[1304]
[1305]
[1306]
[1307]
[1308]
[1309]
[1310]
[1311]
[1312]
[1313]
[1314]
[1315]
[1316]
[1317]
[1318]
[1319]
[1320]
[1321]
[1322]
[1323]
[1324]
[1325]
[1326]
[1327]
[1328]
[1329]
[1330]
[1331]
[1332]
[1333]
[1334]
[1335]
[1336]
[1337]
[1338]
[1339]
[1340]
[1341]
[1342]
[1343]
[1344]
[1345]
[1346]
[1347]
[1348]
[1349]
[1350]
[1351]
[1352]
[1353]
[1354]
[1355]
[1356]
[1357]
[1358]
[1359]
[1360]
[1361]
[1362]
[1363]
[1364]
[1365]
[1366]
[1367]
[1368]
[1369]
[1370]
[1371]
[1372]
[1373]
[1374]
[1375]
[1376]
[1377]
[1378]
[1379]
[1380]
[1381]
[1382]
[1383]
[1384]
[1385]
[1386]
[1387]
[1388]
[1389]
[1390]
[1391]
[1392]
[1393]
[1394]
[1395]
[1396]
[1397]
[1398]
[1399]
[1400]
[1401]
[1402]
[1403]
[1404]
[1405]
[1406]
[1407]
[1408]
[1409]
[1410]
[1411]
[1412]
[1413]
[1414]
[1415]
[1416]
[1417]
[1418]
[1419]
[1420]
[1421]
[1422]
[1423]
[1424]
[1425]
[1426]
[1427]
[1428]
[1429]
[1430]
[1431]
[1432]
[1433]
[1434]
[1435]
[1436]
[1437]
[1438]
[1439]
[1440]
[1441]
[1442]
[1443]
[1444]
[1445]
[1446]
[1447]
[1448]
[1449]
[1450]
[1451]
[1452]
[1453]
[1454]
[1455]
[1456]
[1457]
[1458]
[1459]
[1460]
[1461]
[1462]
[1463]
[1464]
[1465]
[1466]
[1467]
[1468]
[1469]
[1470]
[1471]
[1472]
[1473]
[1474]
[1475]
[1476]
[1477]
[1478]
[1479]
[1480]
[1481]
[1482]
[1483]
[1484]
[1485]
[1486]
[1487]
[1488]
[1489]
[1490]
[1491]
[1492]
[1493]
[1494]
[1495]
[1496]
[1497]
[1498]
[1499]
[1500]
[1501]
[1502]
[1503]
[1504]
[1505]
[1506]
[1507]
[1508]
[1509]
[1510]
[1511]
[1512]
[1513]
[1514]
[1515]
[1516]
[1517]
[1518]
[1519]
[1520]
[1521]
[1522]
[1523]
[1524]
[1525]
[1526]
[1527]
[1528]
[1529]
[1530]
[1531]
[1532]
[1533]
[1534]
[1535]
[1536]
[1537]
[1538]
[1539]
[1540]
[1541]
[1542]
[1543]
[1544]
[1545]
[1546]
[1547]
[1548]
[1549]
[1550]
[1551]
[1552]
[1553]
[1554]
[1555]
[1556]
[1557]
[1558]
[1559]
[1560]
[1561]
[1562]
[1563]
[1564]
[1565]
[1566]
[1567]
[1568]
[1569]
[1570]
[1571]
[1572]
[1573]
[1574]
[1575]
[1576]
[1577]
[1578]
[1579]
[1580]
[1581]
[1582]
[1583]
[1584]
[1585]
[1586]
[1587]
[1588]
[1589]
[1590]
[1591]
[1592]
[1593]
[1594]
[1595]
[1596]
[1597]
[1598]
[1599]
[1600]
[1601]
[1602]
[1603]
[1604]
[1605]
[1606]
[1607]
[1608]
[1609]
[1610]
[1611]
[1612]
[1613]
[1614]
[1615]
[1616]
[1617]
[1618]
[1619]
[1620]
[1621]
[1622]
[1623]
[1624]
[1625]
[1626]
[1627]
[1628]
[1629]
[1630]
[1631]
[1632]
[1633]
[1634]
[1635]
[1636]
[1637]
[1638]
[1639]
[1640]
[1641]
[1642]
[1643]
[1644]
[1645]
[1646]
[1647]
[1648]
[1649]
[1650]
[1651]
[1652]
[1653]
[1654]
[1655]
[1656]
[1657]
[1658]
[1659]
[1660]
[1661]
[1662]
[1663]
[1664]
[1665]
[1666]
[1667]
[1668]
[1669]
[1670]
[1671]
[1672]
[1673]
[1674]
[1675]
[1676]
[1677]
[1678]
[1679]
[1680]
[1681]
[1682]
[1683]
[1684]
[1685]
[1686]
[1687]
[1688]
[1689]
[1690]
[1691]
[1692]
[1693]
[1694]
[1695]
[1696]
[1697]
[1698]
[1699]
[1700]
[1701]
[1702]
[1703]
[1704]
[1705]
[1706]
[1707]
[1708]
[1709]
[1710]
[1711]
[1712]
[1713]
[1714]
[1715]
[1716]
[1717]
[1718]
[1719]
[1720]
[1721]
[1722]
[1723]
[1724]
[1725]
[1726]
[1727]
[1728]
[1729]
[1730]
[1731]
[1732]
[1733]
[1734]
[1735]
[1736]
[1737]
[1738]
[1739]
[1740]
[1741]
[1742]
[1743]
[1744]
[1745]
[1746]
[1747]
[1748]
[1749]
[1750]
[1751]
[1752]
[1753]
[1754]
[1755]
[1756]
[1757]
[1758]
[1759]
[1760]
[1761]
[1762]
[1763]
[1764]
[1765]
[1766]
[1767]
[1768]
[1769]
[1770]
[1771]
[1772]
[1773]
[1774]
[1775]
[1776]
[1777]
[1778]
[1779]
[1780]
[1781]
[1782]
[1783]
[1784]
[1785]
[1786]
[1787]
[1788]
[1789]
[1790]
[1791]
[1792]
[1793]
[1794]
[1795]
[1796]
[1797]
[1798]
[1799]
[1800]
[1801]
[1802]
[1803]
[1804]
[1805]
[1806]
[1807]
[1808]
[1809]
[1810]
[1811]
[1812]
[1813]
[1814]
[1815]
[1816]
[1817]
[1818]
[1819]
[1820]
[1821]
[1822]
[1823]
[1824]
[1825]
[1826]
[1827]
[1828]
[1829]
[1830]
[1831]
[1832]
[1833]
[1834]
[1835]
[1836]
[1837]
[1838]
[1839]
[1840]
[1841]
[1842]
[1843]
[1844]
[1845]
[1846]
[1847]
[1848]
[1849]
[1850]
[1851]
[1852]
[1853]
[1854]
[1855]
[1856]
[1857]
[1858]
[1859]
[1860]
[1861]
[1862]
[1863]
[1864]
[1865]
[1866]
[1867]
[1868]
[1869]
[1870]
[1871]
[1872]
[1873]
[1874]
[1875]
[1876]
[1877]
[1878]
[1879]
[1880]
[1881]
[1882]
[1883]
[1884]
[1885]
[1886]
[1887]
[1888]
[1889]
[1890]
[1891]
[1892]
[1893]
[1894]
[1895]
[1896]
[1897]
[1898]
[1899]
[1900]
[1901]
[1902]
[1903]
[1904]
[1905]
[1906]
[1907]
[1908]
[1909]
[1910]
[1911]
[1912]
[1913]
[1914]
[1915]
[1916]
[1917]
[1918]
[1919]
[1920]
[1921]
[1922]
[1923]
[1924]
[1925]
[1926]
[1927]
[1928]
[1929]
[1930]
[1931]
[1932]
[1933]
[1934]
[1935]
[1936]
[1937]
[1938]
[1939]
[1940]
[1941]
[1942]
[1943]
[1944]
[1945]
[1946]
[1947]
[1948]
[1949]
[1950]
[1951]
[1952]
[1953]
[1954]
[1955]
[1956]
[1957]
[1958]
[1959]
[1960]
[1961]
[1962]
[1963]
[1964]
[1965]
[1966]
[1967]
[1968]
[1969]
[1970]
[1971]
[1972]
[1973]
[1974]
[1975]
[1976]
[1977]
[1978]
[1979]
[1980]
[1981]
[1982]
[1983]
[1984]
[1985]
[1986]
[1987]
[1988]
[1989]
[1990]
[1991]
[1992]
[1993]
[1994]
[1995]
[1996]
[1997]
[1998]
[1999]
[2000]

{"sheet":"REPORT","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Debug","index":3,"n_rows":230,"n_cols":1,"rows_kept":230,"cut":false,"hidden":false,"merged":[]}
["08:21:19 26/07/2023 -  - before unprotect: 30079.53"]
["08:21:19 26/07/2023 -  - after unprotect: 30079.59"]
["08:21:20 26/07/2023 -  - before protect: 30080.3"]
["08:21:20 26/07/2023 -  - after protect: 30080.41"]
["08:21:21 26/07/2023 -  - before unprotect: 30081.58"]
["08:21:21 26/07/2023 -  - after unprotect: 30081.67"]
["08:21:21 26/07/2023 -  - before protect: 30081.7"]
["08:21:21 26/07/2023 -  - after protect: 30081.78"]
["08:21:21 26/07/2023 -  - Start:OnCalculating"]
["08:21:21 26/07/2023 -  - OnCalculating:ActiveWorkbook.Application.CutCopyMode=0"]
["08:21:21 26/07/2023 -  - OnCalculating:Rows+Columns=2"]
["08:21:21 26/07/2023 -  - Set_Status_Fnc="]
["08:21:21 26/07/2023 -  - END:OnCalculating"]
["08:21:21 26/07/2023 -  - Start:OnCalculating"]
["08:21:21 26/07/2023 -  - OnCalculating:ActiveWorkbook.Application.CutCopyMode=0"]
["08:21:21 26/07/2023 -  - OnCalculating:Rows+Columns=2"]
["08:21:21 26/07/2023 -  - Set_Status_Fnc="]
["08:21:21 26/07/2023 -  - END:OnCalculating"]
["08:21:50 26/07/2023 -  - Set_Status_Fnc=Unconnected"]
["19:51:07 27/07/2023 -  - debug is On - Workbook Open"]
["19:51:07 27/07/2023 -  - Temp path is set to C:\\Users\\ticknerj\\AppData\\Local\\Temp\\"]
["19:51:07 27/07/2023 -  - Auto_Add Section :Check For Journal Sheet\r\r"]
["19:51:07 27/07/2023 -  - before unprotect: 71467.41"]
["19:51:07 27/07/2023 -  - after unprotect: 71467.46"]
["19:51:07 27/07/2023 -  - before protect: 71467.47"]
["19:51:07 27/07/2023 -  - after protect: 71467.52"]
["19:51:07 27/07/2023 -  - Set_Status_Fnc=Unconnected"]
["19:51:07 27/07/2023 -  - before unprotect: 71467.52"]
["19:51:07 27/07/2023 -  - after unprotect: 71467.59"]
["19:51:07 27/07/2023 -  - before protect: 71467.6"]
["19:51:07 27/07/2023 -  - after protect: 71467.66"]
["19:51:08 27/07/2023 -  - Auto_Add Section :Check For Journal Sheet\r\r"]
["19:51:08 27/07/2023 -  - before unprotect: 71468.01"]
["19:51:08 27/07/2023 -  - after unprotect: 71468.06"]
["19:51:08 27/07/2023 -  - before protect: 71468.06"]
["19:51:08 27/07/2023 -  - after protect: 71468.12"]
["19:51:08 27/07/2023 -  - Set_Status_Fnc=Unconnected"]
["19:51:08 27/07/2023 -  - before unprotect: 71468.12"]
["19:51:08 27/07/2023 -  - after unprotect: 71468.17"]
["19:51:08 27/07/2023 -  - before protect: 71468.19"]
["19:51:08 27/07/2023 -  - after protect: 71468.24"]
["19:51:11 27/07/2023 -  - Start WS_SetGlobalCompany"]
["19:51:11 27/07/2023 -  - RESTGetAction:https://e55dev.cumbria.gov.uk:7521/e5/rest/gl/companies?random=71471.45"]
["19:51:11 27/07/2023 -  - RESTGetAction:<html><head><title>Error</title></head><body>Internal Server Error</body></html>"]
["19:51:13 27/07/2023 -  - End WS_SetGlobalCompany"]
["19:51:13 27/07/2023 -  - Start WS_SetUpUserData"]
["19:51:13 27/07/2023 -  - RESTGetAction:https://e55dev.cumbria.gov.uk:7521/e5/rest/common/userDataControls?random=71473.08"]
["19:51:13 27/07/2023 -  - RESTGetAction:<html><head><title>Error</title></head><body>Internal Server Error</body></html>"]
["19:51:13 27/07/2023 -  - End WS_SetUpUserData"]
["19:51:26 27/07/2023 -  - before unprotect: 71486.56"]
["19:51:26 27/07/2023 -  - after unprotect: 71486.63"]
["19:51:27 27/07/2023 -  - before protect: 71487.48"]
["19:51:27 27/07/2023 -  - after protect: 71487.56"]
["19:51:29 27/07/2023 -  - before unprotect: 71489.13"]
["19:51:29 27/07/2023 -  - after unprotect: 71489.18"]
["19:51:29 27/07/2023 -  - before protect: 71489.2"]
["19:51:29 27/07/2023 -  - after protect: 71489.25"]
["19:51:29 27/07/2023 -  - Start:OnCalculating"]
["19:51:29 27/07/2023 -  - OnCalculating:ActiveWorkbook.Application.CutCopyMode=0"]
["19:51:29 27/07/2023 -  - OnCalculating:Rows+Columns=2"]
["19:51:29 27/07/2023 -  - Set_Status_Fnc="]
["19:51:29 27/07/2023 -  - END:OnCalculating"]
["19:51:29 27/07/2023 -  - Start:OnCalculating"]
["19:51:29 27/07/2023 -  - OnCalculating:ActiveWorkbook.Application.CutCopyMode=0"]
["19:51:29 27/07/2023 -  - OnCalculating:Rows+Columns=2"]
["19:51:29 27/07/2023 -  - Set_Status_Fnc="]
["19:51:29 27/07/2023 -  - END:OnCalculating"]
["19:51:50 27/07/2023 -  - Start WS_SetGlobalCompany"]
["19:51:50 27/07/2023 -  - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/gl/companies?random=71510.84"]
["19:51:51 27/07/2023 -  - RESTGetAction:<html><head><title>Error</title></head><body>Internal Server Error</body></html>"]
["19:51:51 27/07/2023 -  - End WS_SetGlobalCompany"]
["19:51:51 27/07/2023 -  - Start WS_SetUpUserData"]
["19:51:51 27/07/2023 -  - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/common/userDataControls?random=71512"]
["19:51:52 27/07/2023 -  - RESTGetAction:<html><head><title>Error</title></head><body>Internal Server Error</body></html>"]
["19:51:52 27/07/2023 -  - End WS_SetUpUserData"]
["19:52:04 27/07/2023 -  - WS_Gete5UserName:In:cumbria\\ticknerj"]
["19:52:04 27/07/2023 -  - Start WS_Gete5UserName"]
["19:52:04 27/07/2023 -  - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/users/CUMBRIA%5CTICKNERJ/e5?random=71524.58"]
["19:52:04 27/07/2023 -  - RESTGetAction:{\"FeedParticipantResponse\":{\"result\":\"SUCCESS\",\"message\":\"\",\"responseCode\":1,\"data\":\"{\\\"User\\\":{\\\"userName\\\":\\\"TICKNJ  \\\",\\\"defaultRole\\\":\\\"\\\",\\\"roles\\\":[]}}\"}}"]
["19:52:04 27/07/2023 -  - Start WS_CheckIfUserIsDisabled:TICKNJ"]
["19:52:04 27/07/2023 -  - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/users/TICKNJ/authenticateE5?random=71524.66"]
["19:52:04 27/07/2023 -  - RESTGetAction:{\"FeedParticipantResponse\":{\"result\":\"SUCCESS\",\"message\":\"\",\"responseCode\":1,\"data\":null}}"]
["19:52:04 27/07/2023 -  - End WS_CheckIfUserIsDisabled:Provider=MSDASQL.1"]
["19:52:04 27/07/2023 -  - End WS_Gete5UserName:Out:TICKNJ"]
["19:52:04 27/07/2023 - TICKNJ - Set_Status_Fnc=Connected...e5-UserId TICKNJ"]
["19:52:04 27/07/2023 - TICKNJ - Start WS_GetSystemControls"]
["19:52:04 27/07/2023 - TICKNJ - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/systemControls?random=71524.74"]
["19:52:04 27/07/2023 - TICKNJ - RESTGetAction:{\"FeedParticipantResponse\":{\"result\":\"SUCCESS\",\"message\":\"\",\"responseCode\":1,\"data\":\"[{\\\"id\\\":\\\"1\\\",\\\"sys_name\\\":\\\"e5 5.5 E5FS                             \\\",\\\"signon_ind\\\":\\\"4\\\",\\\"enhancedSecurity\\\":\\\" \\\",\\\"passwordMixedCase\\\":\\\" \\\"}]\"}}"]
["19:52:04 27/07/2023 - TICKNJ - Finished running rest action"]
["19:52:04 27/07/2023 - TICKNJ - Found SUCCESS:PswdMixedcase=False"]
["19:52:04 27/07/2023 - TICKNJ - End WS_GetSystemControls"]
["19:52:04 27/07/2023 - TICKNJ - WS_Gete5UserName:In:TICKNJ"]
["19:52:04 27/07/2023 - TICKNJ - Start WS_Gete5UserName"]
["19:52:04 27/07/2023 - TICKNJ - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/users/TICKNJ/e5?random=71524.8"]
["19:52:04 27/07/2023 - TICKNJ - RESTGetAction:{\"FeedParticipantResponse\":{\"result\":\"SUCCESS\",\"message\":\"\",\"responseCode\":1,\"data\":\"{\\\"User\\\":{\\\"userName\\\":\\\"TICKNJ  \\\",\\\"defaultRole\\\":\\\"\\\",\\\"roles\\\":[]}}\"}}"]
["19:52:04 27/07/2023 - TICKNJ - Start WS_CheckIfUserIsDisabled:TICKNJ"]
["19:52:04 27/07/2023 - TICKNJ - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/users/TICKNJ/authenticateE5?random=71524.86"]
["19:52:04 27/07/2023 - TICKNJ - RESTGetAction:{\"FeedParticipantResponse\":{\"result\":\"SUCCESS\",\"message\":\"\",\"responseCode\":1,\"data\":null}}"]
["19:52:04 27/07/2023 - TICKNJ - End WS_CheckIfUserIsDisabled:Provider=MSDASQL.1"]
["19:52:04 27/07/2023 - TICKNJ - End WS_Gete5UserName:Out:TICKNJ"]
["19:52:04 27/07/2023 - TICKNJ - Start WS_GetRolesForUser"]
["19:52:04 27/07/2023 - TICKNJ - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/users/TICKNJ?random=71524.9"]
["19:52:04 27/07/2023 - TICKNJ - RESTGetAction:{\"FeedParticipantResponse\":{\"result\":\"SUCCESS\",\"message\":\"\",\"responseCode\":1,\"data\":\"{\\\"User\\\":{\\\"userName\\\":\\\"TICKNJ\\\",\\\"defaultRole\\\":\\\"\\\",\\\"roles\\\":[]}}\"}}"]
["19:52:05 27/07/2023 - TICKNJ - End WS_GetRolesForUser"]
["19:52:05 27/07/2023 - TICKNJ - Start WS_SetGlobalCompany"]
["19:52:05 27/07/2023 - TICKNJ - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/gl/companies?random=71525.05"]
["19:52:05 27/07/2023 - TICKNJ - RESTGetAction:{\"FeedParticipantResponse\":{\"result\":\"SUCCESS\",\"message\":\"\",\"responseCode\":1,\"data\":\"[{\\\"company\\\":\\\"CC\\\",\\\"description\\\":\\\"CUMBRIA COUNTY COUNCIL\\\"},{\\\"company\\\":\\\"CU\\\",\\\"description\\\":\\\"Cumberland Council\\\"},{\\\"company\\\":\\\"WF\\\",\\\"description\\\":\\\"Westmorland and Furness Council\\\"}]\"}}"]
["19:52:05 27/07/2023 - TICKNJ - End WS_SetGlobalCompany"]
["19:52:05 27/07/2023 - TICKNJ - Start WS_CheckUserSecurity"]
["19:52:05 27/07/2023 - TICKNJ - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/users/TICKNJ?random=71525.1"]
["19:52:05 27/07/2023 - TICKNJ - RESTGetAction:{\"FeedParticipantResponse\":{\"result\":\"SUCCESS\",\"message\":\"\",\"responseCode\":1,\"data\":\"{\\\"User\\\":{\\\"userName\\\":\\\"TICKNJ\\\",\\\"defaultRole\\\":\\\"\\\",\\\"roles\\\":[]}}\"}}"]
["19:52:05 27/07/2023 - TICKNJ - Finished running rest action"]
["19:52:05 27/07/2023 - TICKNJ - Found SUCCESS:SctyGrp="]
["19:52:05 27/07/2023 - TICKNJ - Start WS_SetGlobalCompany"]
["19:52:05 27/07/2023 - TICKNJ - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/gl/companies//securityGroups?ADV_User=TICKNJ&ADV_Role=&random=71525.15"]
["19:52:05 27/07/2023 - TICKNJ - RESTGetAction:"]
["19:52:05 27/07/2023 - TICKNJ - No security group setup using role based security, allow access"]
["19:52:05 27/07/2023 - TICKNJ - Set_Status_Fnc=Connected...e5-UserId TICKNJ"]
["19:52:05 27/07/2023 - TICKNJ - Start WS_GetRolesForUser"]
["19:52:05 27/07/2023 - TICKNJ - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/users/TICKNJ?random=71525.42"]
["19:52:05 27/07/2023 - TICKNJ - RESTGetAction:{\"FeedParticipantResponse\":{\"result\":\"SUCCESS\",\"message\":\"\",\"responseCode\":1,\"data\":\"{\\\"User\\\":{\\\"userName\\\":\\\"TICKNJ\\\",\\\"defaultRole\\\":\\\"\\\",\\\"roles\\\":[]}}\"}}"]
["19:52:05 27/07/2023 - TICKNJ - End WS_GetRolesForUser"]
["19:52:15 27/07/2023 - TICKNJ - Start WS_SetGlobalCompany"]
["19:52:15 27/07/2023 - TICKNJ - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/gl/companies?random=71535.02"]
["19:52:15 27/07/2023 - TICKNJ - RESTGetAction:{\"FeedParticipantResponse\":{\"result\":\"SUCCESS\",\"message\":\"\",\"responseCode\":1,\"data\":\"[{\\\"company\\\":\\\"CC\\\",\\\"description\\\":\\\"CUMBRIA COUNTY COUNCIL\\\"},{\\\"company\\\":\\\"CU\\\",\\\"description\\\":\\\"Cumberland Council\\\"},{\\\"company\\\":\\\"WF\\\",\\\"description\\\":\\\"Westmorland and Furness Council\\\"}]\"}}"]
["19:52:15 27/07/2023 - TICKNJ - End WS_SetGlobalCompany"]
["19:52:15 27/07/2023 - TICKNJ - Start WS_SetUpUserData"]
["19:52:15 27/07/2023 - TICKNJ - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/userDataControls?random=71535.07"]
["19:52:15 27/07/2023 - TICKNJ - RESTGetAction:{\"FeedParticipantResponse\":{\"result\":\"SUCCESS\",\"message\":\"\",\"responseCode\":1,\"data\":\"[{\\\"id\\\":\\\"\\\",\\\"company\\\":\\\"CC\\\",\\\"format\\\":\\\"        \\\",\\\"description\\\":\\\"GL TRANSACTION USERDATA                 \\\",\\\"charLength\\\":38,\\\"numFields\\\":1,\\\"dateFields\\\":1},{\\\"id\\\":\\\"\\\",\\\"company\\\":\\\"CU\\\",\\\"format\\\":\\\"        \\\",\\\"description\\\":\\\"GL TRANSACTION USERDATA                 \\\",\\\"charLength\\\":38,\\\"numFields\\\":1,\\\"dateFields\\\":1},{\\\"id\\\":\\\"\\\",\\\"company\\\":\\\"WF\\\",\\\"format\\\":\\\"        \\\",\\\"description\\\":\\\"GL TRANSACTION USERDATA                 \\\",\\\"charLength\\\":38,\\\"numFields\\\":1,\\\"dateFields\\\":1}]\"}}"]
["19:52:15 27/07/2023 - TICKNJ - End WS_SetUpUserData"]
["19:53:01 27/07/2023 -  - debug is On - Workbook Open"]
["19:53:01 27/07/2023 -  - Temp path is set to C:\\Users\\ticknerj\\AppData\\Local\\Temp\\"]
["19:53:01 27/07/2023 -  - Auto_Add Section :Check For Journal Sheet\r\r"]
["19:53:01 27/07/2023 -  - before unprotect: 71581.81"]
["19:53:01 27/07/2023 -  - after unprotect: 71581.88"]
["19:53:01 27/07/2023 -  - before protect: 71581.88"]
["19:53:01 27/07/2023 -  - after protect: 71581.94"]
["19:53:01 27/07/2023 -  - Set_Status_Fnc=Unconnected"]
["19:53:01 27/07/2023 -  - before unprotect: 71581.94"]
["19:53:01 27/07/2023 -  - after unprotect: 71581.99"]
["19:53:02 27/07/2023 -  - before protect: 71582.01"]
["19:53:02 27/07/2023 -  - after protect: 71582.05"]
["19:53:02 27/07/2023 -  - Auto_Add Section :Check For Journal Sheet\r\r"]
["19:53:02 27/07/2023 -  - before unprotect: 71582.25"]
["19:53:02 27/07/2023 -  - after unprotect: 71582.3"]
["19:53:02 27/07/2023 -  - before protect: 71582.31"]
["19:53:02 27/07/2023 -  - after protect: 71582.36"]
["19:53:02 27/07/2023 -  - Set_Status_Fnc=Unconnected"]
["19:53:02 27/07/2023 -  - before unprotect: 71582.37"]
["19:53:02 27/07/2023 -  - after unprotect: 71582.42"]
["19:53:02 27/07/2023 -  - before protect: 71582.43"]
["19:53:02 27/07/2023 -  - after protect: 71582.48"]
["19:53:06 27/07/2023 -  - WS_Gete5UserName:In:cumbria\\ticknerj"]
["19:53:06 27/07/2023 -  - Start WS_Gete5UserName"]
["19:53:06 27/07/2023 -  - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/users/CUMBRIA%5CTICKNERJ/e5?random=71586.74"]
["19:53:06 27/07/2023 -  - RESTGetAction:{\"FeedParticipantResponse\":{\"result\":\"SUCCESS\",\"message\":\"\",\"responseCode\":1,\"data\":\"{\\\"User\\\":{\\\"userName\\\":\\\"TICKNJ  \\\",\\\"defaultRole\\\":\\\"\\\",\\\"roles\\\":[]}}\"}}"]
["19:53:06 27/07/2023 -  - Start WS_CheckIfUserIsDisabled:TICKNJ"]
["19:53:06 27/07/2023 -  - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/users/TICKNJ/authenticateE5?random=71586.8"]
["19:53:06 27/07/2023 -  - RESTGetAction:{\"FeedParticipantResponse\":{\"result\":\"SUCCESS\",\"message\":\"\",\"responseCode\":1,\"data\":null}}"]
["19:53:06 27/07/2023 -  - End WS_CheckIfUserIsDisabled:"]
["19:53:06 27/07/2023 -  - End WS_Gete5UserName:Out:TICKNJ"]
["19:53:06 27/07/2023 - TICKNJ - Set_Status_Fnc=Connected...e5-UserId TICKNJ"]
["19:53:06 27/07/2023 - TICKNJ - Start WS_GetSystemControls"]
["19:53:06 27/07/2023 - TICKNJ - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/systemControls?random=71586.85"]
["19:53:06 27/07/2023 - TICKNJ - RESTGetAction:{\"FeedParticipantResponse\":{\"result\":\"SUCCESS\",\"message\":\"\",\"responseCode\":1,\"data\":\"[{\\\"id\\\":\\\"1\\\",\\\"sys_name\\\":\\\"e5 5.5 E5FS                             \\\",\\\"signon_ind\\\":\\\"4\\\",\\\"enhancedSecurity\\\":\\\" \\\",\\\"passwordMixedCase\\\":\\\" \\\"}]\"}}"]
["19:53:06 27/07/2023 - TICKNJ - Finished running rest action"]
["19:53:06 27/07/2023 - TICKNJ - Found SUCCESS:PswdMixedcase=False"]
["19:53:06 27/07/2023 - TICKNJ - End WS_GetSystemControls"]
["19:53:06 27/07/2023 - TICKNJ - WS_Gete5UserName:In:TICKNJ"]
["19:53:06 27/07/2023 - TICKNJ - Start WS_Gete5UserName"]
["19:53:06 27/07/2023 - TICKNJ - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/users/TICKNJ/e5?random=71586.9"]
["19:53:06 27/07/2023 - TICKNJ - RESTGetAction:{\"FeedParticipantResponse\":{\"result\":\"SUCCESS\",\"message\":\"\",\"responseCode\":1,\"data\":\"{\\\"User\\\":{\\\"userName\\\":\\\"TICKNJ  \\\",\\\"defaultRole\\\":\\\"\\\",\\\"roles\\\":[]}}\"}}"]
["19:53:06 27/07/2023 - TICKNJ - Start WS_CheckIfUserIsDisabled:TICKNJ"]
["19:53:06 27/07/2023 - TICKNJ - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/users/TICKNJ/authenticateE5?random=71586.95"]
["19:53:06 27/07/2023 - TICKNJ - RESTGetAction:{\"FeedParticipantResponse\":{\"result\":\"SUCCESS\",\"message\":\"\",\"responseCode\":1,\"data\":null}}"]
["19:53:06 27/07/2023 - TICKNJ - End WS_CheckIfUserIsDisabled:"]
["19:53:06 27/07/2023 - TICKNJ - End WS_Gete5UserName:Out:TICKNJ"]
["19:53:06 27/07/2023 - TICKNJ - Start WS_GetRolesForUser"]
["19:53:06 27/07/2023 - TICKNJ - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/users/TICKNJ?random=71586.98"]
["19:53:07 27/07/2023 - TICKNJ - RESTGetAction:{\"FeedParticipantResponse\":{\"result\":\"SUCCESS\",\"message\":\"\",\"responseCode\":1,\"data\":\"{\\\"User\\\":{\\\"userName\\\":\\\"TICKNJ\\\",\\\"defaultRole\\\":\\\"\\\",\\\"roles\\\":[]}}\"}}"]
["19:53:07 27/07/2023 - TICKNJ - End WS_GetRolesForUser"]
["19:53:07 27/07/2023 - TICKNJ - Start WS_SetGlobalCompany"]
["19:53:07 27/07/2023 - TICKNJ - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/gl/companies?random=71587.03"]
["19:53:07 27/07/2023 - TICKNJ - RESTGetAction:{\"FeedParticipantResponse\":{\"result\":\"SUCCESS\",\"message\":\"\",\"responseCode\":1,\"data\":\"[{\\\"company\\\":\\\"CC\\\",\\\"description\\\":\\\"CUMBRIA COUNTY COUNCIL\\\"},{\\\"company\\\":\\\"CU\\\",\\\"description\\\":\\\"Cumberland Council\\\"},{\\\"company\\\":\\\"WF\\\",\\\"description\\\":\\\"Westmorland and Furness Council\\\"}]\"}}"]
["19:53:07 27/07/2023 - TICKNJ - End WS_SetGlobalCompany"]
["19:53:07 27/07/2023 - TICKNJ - Start WS_CheckUserSecurity"]
["19:53:07 27/07/2023 - TICKNJ - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/users/TICKNJ?random=71587.06"]
["19:53:07 27/07/2023 - TICKNJ - RESTGetAction:{\"FeedParticipantResponse\":{\"result\":\"SUCCESS\",\"message\":\"\",\"responseCode\":1,\"data\":\"{\\\"User\\\":{\\\"userName\\\":\\\"TICKNJ\\\",\\\"defaultRole\\\":\\\"\\\",\\\"roles\\\":[]}}\"}}"]
["19:53:07 27/07/2023 - TICKNJ - Finished running rest action"]
["19:53:07 27/07/2023 - TICKNJ - Found SUCCESS:SctyGrp="]
["19:53:07 27/07/2023 - TICKNJ - Start WS_SetGlobalCompany"]
["19:53:07 27/07/2023 - TICKNJ - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/gl/companies//securityGroups?ADV_User=TICKNJ&ADV_Role=&random=71587.11"]
["19:53:07 27/07/2023 - TICKNJ - RESTGetAction:"]
["19:53:07 27/07/2023 - TICKNJ - No security group setup using role based security, allow access"]
["19:53:07 27/07/2023 - TICKNJ - Set_Status_Fnc=Connected...e5-UserId TICKNJ"]
["19:53:07 27/07/2023 - TICKNJ - Start WS_GetRolesForUser"]
["19:53:07 27/07/2023 - TICKNJ - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/users/TICKNJ?random=71587.14"]
["19:53:07 27/07/2023 - TICKNJ - RESTGetAction:{\"FeedParticipantResponse\":{\"result\":\"SUCCESS\",\"message\":\"\",\"responseCode\":1,\"data\":\"{\\\"User\\\":{\\\"userName\\\":\\\"TICKNJ\\\",\\\"defaultRole\\\":\\\"\\\",\\\"roles\\\":[]}}\"}}"]
["19:53:07 27/07/2023 - TICKNJ - End WS_GetRolesForUser"]
["19:53:14 27/07/2023 - TICKNJ - Start WS_CheckUserSecurity"]
["19:53:14 27/07/2023 - TICKNJ - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/users/TICKNJ?random=71594.43"]
["19:53:14 27/07/2023 - TICKNJ - RESTGetAction:{\"FeedParticipantResponse\":{\"result\":\"SUCCESS\",\"message\":\"\",\"responseCode\":1,\"data\":\"{\\\"User\\\":{\\\"userName\\\":\\\"TICKNJ\\\",\\\"defaultRole\\\":\\\"\\\",\\\"roles\\\":[]}}\"}}"]
["19:53:14 27/07/2023 - TICKNJ - Finished running rest action"]
["19:53:14 27/07/2023 - TICKNJ - Found SUCCESS:SctyGrp="]
["19:53:14 27/07/2023 - TICKNJ - Start WS_SetGlobalCompany"]
["19:53:14 27/07/2023 - TICKNJ - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/gl/companies//securityGroups?ADV_User=TICKNJ&ADV_Role=&random=71594.48"]
["19:53:14 27/07/2023 - TICKNJ - RESTGetAction:"]
["19:53:14 27/07/2023 - TICKNJ - No security group setup using role based security, allow access"]
["19:53:15 27/07/2023 - TICKNJ - before unprotect: 71595.8"]
["19:53:15 27/07/2023 - TICKNJ - after unprotect: 71595.86"]
["19:53:17 27/07/2023 - TICKNJ - Start WS_GetAccountDef"]
["19:53:17 27/07/2023 - TICKNJ - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/gl/companies/CU/accountDefinitions?random=71597.88"]
["19:53:17 27/07/2023 - TICKNJ - RESTGetAction:{\"FeedParticipantResponse\":{\"result\":\"SUCCESS\",\"message\":\"\",\"responseCode\":1,\"data\":\"[{\\\"company\\\":\\\"CU\\\",\\\"codeId\\\":\\\"0\\\",\\\"codeSize\\\":8,\\\"description\\\":\\\"EMPLOYEE\\\",\\\"heading\\\":\\\"EMPLOYEE\\\",\\\"nominal\\\":false},{\\\"company\\\":\\\"CU\\\",\\\"codeId\\\":\\\"1\\\",\\\"codeSize\\\":12,\\\"description\\\":\\\"DETAIL\\\",\\\"heading\\\":\\\"DETAIL\\\",\\\"nominal\\\":false},{\\\"company\\\":\\\"CU\\\",\\\"codeId\\\":\\\"A\\\",\\\"codeSize\\\":7,\\\"description\\\":\\\"COST CENTRE\\\",\\\"heading\\\":\\\"COST CEN\\\",\\\"nominal\\\":false},{\\\"company\\\":\\\"CU\\\",\\\"codeId\\\":\\\"B\\\",\\\"codeSize\\\":5,\\\"description\\\":\\\"NOMINAL\\\",\\\"heading\\\":\\\"NOMINAL\\\",\\\"nominal\\\":true},{\\\"company\\\":\\\"CU\\\",\\\"codeId\\\":\\\"C\\\",\\\"codeSize\\\":4,\\\"description\\\":\\\"FUNDING SOURCE\\\",\\\"heading\\\":\\\"FUND\\\",\\\"nominal\\\":false},{\\\"company\\\":\\\"CU\\\",\\\"codeId\\\":\\\"D\\\",\\\"codeSize\\\":9,\\\"description\\\":\\\"PROJECT\\\",\\\"heading\\\":\\\"PROJECT\\\",\\\"nominal\\\":false}]\"}}"]
["19:53:17 27/07/2023 - TICKNJ - End WS_GetAccountDef"]
["19:53:18 27/07/2023 - TICKNJ - Start WS_GetAnalDef"]
["19:53:18 27/07/2023 - TICKNJ - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/gl/companies/CU/accountDefinitions?random=71598.02"]
["19:53:18 27/07/2023 - TICKNJ - RESTGetAction:{\"FeedParticipantResponse\":{\"result\":\"SUCCESS\",\"message\":\"\",\"responseCode\":1,\"data\":\"[{\\\"company\\\":\\\"CU\\\",\\\"codeId\\\":\\\"0\\\",\\\"codeSize\\\":8,\\\"description\\\":\\\"EMPLOYEE\\\",\\\"heading\\\":\\\"EMPLOYEE\\\",\\\"nominal\\\":false},{\\\"company\\\":\\\"CU\\\",\\\"codeId\\\":\\\"1\\\",\\\"codeSize\\\":12,\\\"description\\\":\\\"DETAIL\\\",\\\"heading\\\":\\\"DETAIL\\\",\\\"nominal\\\":false},{\\\"company\\\":\\\"CU\\\",\\\"codeId\\\":\\\"A\\\",\\\"codeSize\\\":7,\\\"description\\\":\\\"COST CENTRE\\\",\\\"heading\\\":\\\"COST CEN\\\",\\\"nominal\\\":false},{\\\"company\\\":\\\"CU\\\",\\\"codeId\\\":\\\"B\\\",\\\"codeSize\\\":5,\\\"description\\\":\\\"NOMINAL\\\",\\\"heading\\\":\\\"NOMINAL\\\",\\\"nominal\\\":true},{\\\"company\\\":\\\"CU\\\",\\\"codeId\\\":\\\"C\\\",\\\"codeSize\\\":4,\\\"description\\\":\\\"FUNDING SOURCE\\\",\\\"heading\\\":\\\"FUND\\\",\\\"nominal\\\":false},{\\\"company\\\":\\\"CU\\\",\\\"codeId\\\":\\\"D\\\",\\\"codeSize\\\":9,\\\"description\\\":\\\"PROJECT\\\",\\\"heading\\\":\\\"PROJECT\\\",\\\"nominal\\\":false}]\"}}"]
["19:53:18 27/07/2023 - TICKNJ - End WS_GetAnalDef"]
["19:53:18 27/07/2023 - TICKNJ - Start WS_GetProjectDef"]
["19:53:18 27/07/2023 - TICKNJ - RESTGetAction:https://e55live.cumbria.gov.uk:7521/e5/rest/secured/gl/companies/CU/projectDefinitions?random=71598.45"]
["19:53:18 27/07/2023 - TICKNJ - RESTGetAction:{\"FeedParticipantResponse\":{\"result\":\"SUCCESS\",\"message\":\"\",\"responseCode\":1,\"data\":\"[]\"}}"]
["19:53:18 27/07/2023 - TICKNJ - End WS_GetProjectDef"]
["19:53:18 27/07/2023 - TICKNJ - before protect: 71598.53"]
["19:53:18 27/07/2023 - TICKNJ - after protect: 71598.59"]
["19:53:18 27/07/2023 - TICKNJ - before unprotect: 71598.61"]
["19:53:18 27/07/2023 - TICKNJ - after unprotect: 71598.68"]
["19:53:18 27/07/2023 - TICKNJ - before protect: 71598.8"]
["19:53:18 27/07/2023 - TICKNJ - after protect: 71598.87"]
["19:53:30 27/07/2023 - TICKNJ - Set_Status_Fnc=Unconnected"]
["19:53:42 27/07/2023 - TICKNJ - Set_Status_Fnc=Unconnected"]

{"sheet":"SavedSettings","index":4,"n_rows":56,"n_cols":24,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
[0]
[null,"General Settings",null,null,null,"Formatting"]
[null,"Password Protect",0,null,"This","Header Fields","Cell Ref",null,"Available Fields","Cell Ref",null,"Available Fields","Cell Ref",null,"Batch Types","Balance Classes","Elements","Col Widths",null,"User Data Settings","Available","Used","Remaining"]
[null,"Password","0F67589B",null,"Next","Company:","A3",null,"ACCT",1,null,"ACCT",1,null,null,null,null,15,null,"Number of Characters",38,{"$f":"SUMIF(U51:U73,\"Text\",W51:W73)","v":0},{"$f":"U4-V4","v":38}]
[null,"Allow Mixed Case Passwords",0,null,"Last","Batch Type:","A4",null,"ANAL",2,null,"ANAL",2,null,null,null,null,20,null,"Number of Dates",1,{"$f":"COUNTIF(U51:U73,\"Date\")","v":0},{"$f":"U5-V5","v":1}]
[null,"Login Information",null,null,null,"Description:","A5",null,"FNCL_VAL",3,null,"FNCL_VAL",3,null,null,null,null,20,null,"Number of Numerics",1,{"$f":"COUNTIF(U51:U73,\"Numeric\")","v":0},{"$f":"U6-V6","v":1}]
[null,"Init to spaces",0,null,null,"Batch Date:","A6",null,"CURR_VAL",4,null,"CURR_VAL",4,null,null,null,null,20,null,"User Data Company","36EE144B3C9684817412726A9387B0E5CC6E2EBFA6BF48"]
[null,"DB2 Support",0,null,null,"Year:","A7",null,"DETL_DESCR",5,null,"DETL_DESCR",5,null,null,null,null,20,"Company","Description","Type","Start Pos","Length","IDX"]
[null,"DB2 Lookup Qual",0,null,null,"BTZ Element:","A8",null,"QTY",6,null,"QTY",6,null,null,null,null,20]
[null,"Logon Type SSO/LDAP/e5",85,null,null,"Currency Code:","A10",null,"UOM",7,null,"UOM",7,null,null,null,null,20]
[null,"e5 Type","C4",null,null,"Effective Date:","A11",null,"REF_NUM",8,null,"REF_NUM",8,null,null,null,null,20]
[null,"WebService URL","DA618D75B34AD1B6A1445FFCC1766AF42B8BD37AE5D0B1ED93515B2AD6498C336091ACE7C93948B27E3AC4",null,null,"Value Date:","A12",null,"TAX_CODE",9,null,"TAX_CODE",9,null,null,null,null,20]
[null,"WebService UserId",null,null,null,"Security Group:","A13",null,"TAX_TYPE",10,null,"TAX_TYPE",10,null,null,null,null,20]
[null,"WebService Password",null,null,null,"Balance Class:","A14",null,"TAX_LOCTN",11,null,"TAX_LOCTN",11,null,null,null,null,20]
[null,"ODBC or DBS Connection",0,null,null,"Batch Ref:","C4",null,"RECON",12,null,"RECON",12,null,null,null,null,20]
[null,"e5 User","AB8668B95656",null,null,"Period:","C6",null,"DETL_RATE_TYPE",13,null,"DETL_RATE_TYPE",13,null,null,null,null,20]
[null,"ODBC Datasource",null,null,null,"No of Periods:","C7",null,"DETL_EFF_DATE",14,null,"DETL_EFF_DATE",14,null,null,null,null,20]
[null,"ODBCDRIVEROpt",42,null,null,"Rate Type:","C10",null,"DETL_EXCH_RATE",15,null,"DETL_EXCH_RATE",15,null,null,null,null,20]
[null,"ODBC Server",null,null,null,"Accrual Reversal:","C13",null,"TRAN_DATE",16,null,"TRAN_DATE",16,null,null,null,null,20]
[null,"ODBC Database",null,null,null,"Accrual Period:","C12",null,"DEST_CMPY",17,null,"DEST_CMPY",17,null,null,null,null,20]
[null,"ODBC Driver",null,null,null,"No Trans:","E8",null,"COST_SRCE_CMPY",18,null,"COST_SRCE_CMPY",18,null,null,null,null,20]
[null,"ODBC Dll",null,null,null,"Base:","E12",null,"COST_SRCE",19,null,"COST_SRCE",19,null,null,null,null,20]
[null,"qualifier",null,null,null,"Foreign:","E13",null,"COST_TRGT_CMPY",20,null,"COST_TRGT_CMPY",20,null,null,null,null,20]
[null,"dbsUser",null,null,null,"Originator:",null,null,"COST_TRGT",21,null,"COST_TRGT",21,null,null,null,null,20]
[null,"dbsPassword","AA",null,null,null,null,null,"MCA",22,null,"MCA",22,null,null,null,null,20]
[null,"LDAP Root",null,null,null,null,null,null,"PROJ",23,null,"PROJ",23,null,null,null,null,20]
[null,"LDAP Param",null,null,null,null,null,null,"USR_DATA",24,null,"USR_DATA",24,null,null,null,null,20]
[null,"LDAP Serach","26093A37",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"OpenAM URL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"KeyCloakADFS",0]
[null,"KeyCloak IP Alias"]
[null,"Init Lock Cmpy","CF"]
[null,"Show ODBC on logon",0]
[null,"Debug","F2"]
[null,"DB2"]
[null,"Ebcidc Conversion","CF"]
[null,"Report Conversion",1]
[null,"Timeout","33AF"]
[null,"ValidateOnUpdate",33]
[null,"Max Rows","02A13A74"]
[null,"Reporting",66]
[null,"Poll Task Queue"]
[null,"Initilise CMPY","37735076CBCAC9C8DEDF8D64B8A192534E3237421FF820"]
[null,"Debit/Credit Style","F1","Qual"]
[null,"Screen Updating"]
[null,"Y Pos"]
[null,"X Pos"]
[null,"e5 User"]
[null,"Detail Report String","  Detail Seq Num"]
[null,"ValidateOnPaste","D3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Company","Description","Type","Start Pos","Length","IDX"]
[null,"DisableCustomPaste",90]
[null,"Autosave On Upload",0]
[null,"Autosave Path"]
[null,"ContentListIndex","DF"]
[null,"MessageListIndex","1E"]
[null,"Lookup Qual","Data Source"]