{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Menu","tmpscrapsheet","Payroll","HR","PHRExport","Sales Contact","SCExport","Purchase Contact","PCExport","People Profiles","PPExport","CRMEE","CRMEEExport","CRMContact","CRMCActions","CRMContactExport","Ls_XLB_WorkbookFile","Ls_AgXLB_WorkbookFile"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":1,"defined_names":30,"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":"Menu","index":0,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,"GDPR Reporting"]

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

{"sheet":"Payroll","index":2,"n_rows":63,"n_cols":18,"rows_kept":63,"cut":false,"hidden":false,"merged":[[2,15,3,17]]}
[]
[]
[null,"Company ID: ",null,"Z",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H23=\"\",\"Current Employee\", \"Leaver\")","v":"Current Employee"}]
[null,"Employee Ref: ",null,1001]
[]
[null,"Employee Information",null,null,null,null,null,null,null,"Pay Information",null,null,null,null,null,"AE Information"]
[]
[null,"Name : ",null,{"$f":"[1]!AG_DTLK(\"0,3,PEGASUS,WN,F={P}1,K=CoID,F={P}2,K=/WN/1,E=9,O=Full Name{Fmt}=8{Cm}0{DefVal}={Formula}={/WN/29} & {Qt} {Qt} & {/WN/3} & {Qt} {Qt} & {/WN/2},C={P}3,E=21,O=/WN/11,C={P}4,E=0,O=/WN/12,C={P}5,E=21,O=/WN/13,C={P}6,E=0,O=/WN/9,C={P}7,E=0,O=/WN/WA/2,C={P}8,E=\",\"0,O=/WN/22,C={P}9,E=0,O=/WN/23,C={P}10,E=0,O=/WN/31,C={P}11,E=0,O=/WN/32,C={P}12,E=0,O=/WN/33,C={P}13,E=0,O=/WN/34,C={P}14,E=0,O=/WN/35,C={P}15,E=0,O=/WN/36,C={P}16,E=0,O=/WN/f19,C={P}17,E=0,O=/WN/174,\",Payroll!D8,$D$3,D$4,D$14,D$15,D$12,D$16,$H$9,D$9,D$10,D$20,D$21,D$22,D$23,D$24,D$25,$H$18,D$18)","v":"Mr Richard Godson"},null,"Group : ",null,"Monthly",null,null,null,"This Period",null,"Year To Date",null,"Category : ",null,{"$f":"[1]!AG_DTLK(\"0,3,PEGASUS,WN,F={P}1,K=CoID,F={P}2,K=/WN/1,E=21,O=/WN/WEN*1/WC,C={P}3,E=21,O=/WN/WEN*1/WC1,C={P}4,E=0,O=/WN/WEN*1/WA,C={P}5,E=0,O=/WN/WEN*1/WA1,C={P}6,E=0,O=/WN/WEN*1/WC8,C={P}7,E=0,O=/WN/WEN*1/f8,C={P}8,E=0,O=/WN/WEN*1/f9,C={P}9,E=0,O=/WN/WEN*1/WO1,C={P\",\"}10,E=0,O=/WN/WEN*1/WO3,C={P}11,E=0,O=/WN/WEN*1/WO2,C={P}12,E=0,O=/WN/WEN*1/WJ1,C={P}13,E=0,O=/WN/WEN*1/WJ,C={P}14,E=0,O=/WN/WEN*1/WQ,C={P}15,E=0,O=/WN/WEN*1/WA2,C={P}16,E=0,O=/WN/WEN*1/WO6,\",Payroll!R8,$D$3,$D$4,R$9,R$11,R$12,R$13,R$14,R$15,R$18,R$17,R$16,R$19,R$20,R$21,R$22,R$23)","v":"EJ"}]
[null,"Date Of Birth : ",null,"1971-06-03",null,"Department : ",null,"Administration",null,null,null,null,null,null,null,"Status : ",null,"AutoEnrolled"]
[null,"Start Date : ",null,"2012-07-01",null,"Position : ",null,{"$f":"[1]!AG_DTLK(\"0,2,PEGASUS,WN,F={P}1,K=CoID,F={P}2,K=/WN/1,E=0,O=/WN/HR/4,C={P}3,E=0,O=/WN/HR/5,C={P}4,E=0,O=/WN/HR/111,C={P}5,E=0,O=/WN/HR/123,C={P}6,E=0,O=/WN/HR/124,C={P}7,E=0,O=/WN/HR/11,C={P}8,E=0,O=/WN/103,C={P}9,E=0,O=/WN/21,C={P}10,E=0,O=/WN/24,\",Payroll!H10,$D$3,$D$4,H$21,H$22,H$8,H$12,H$13,H$16,H$17,H$23)","v":"Managing Director"},null,"Gross Pay : ",null,{"$f":"[1]!AG_DTLK(\"0,3,PEGASUS,WN,F={P}1,K=CoID,F={P}2,K=/WN/1,E=0,O=/WN/55,C={P}3,E=0,O=/WN/73,C={P}4,E=0,O=/WN/74,C={P}5,E=0,O=/WN/75,C={P}6,E=0,O=/WN/79,C={P}7,E=0,O=/WN/84,C={P}8,E=0,O=/WN/76,C={P}9,E=0,O=/WN/77,C={P}10,E=0,O=/WN/129,C={P}11,E=0,O=/WN/60,C={P}12,E=0,O=/\",\"WN/61,C={P}13,E=0,O=/WN/172,C={P}14,E=0,O=/WN/170,C={P}15,E=0,O=/WN/169,C={P}16,E=0,O=/WN/70,C={P}17,E=0,O=/WN/f13,\",Payroll!L10,$D$3,$D$4,L$11,L$12,L$19,L$14,L$18,L$16,L$15,$N10,$N$11,$N$12,$N$14,$N$15,$N$16,$N$18,$N$19)","v":1111111},null,2222322]
[null,"Passport # : ",null,null,null,null,null,null,null,"Taxable Pay : ",null,1111211,null,2222322,null,"AE Date : ",null,"2016-01-01"]
[null,"Gender : ",null,"Male",null,"Marital Status : ",null,"Married",null,"Tax Paid/Due : ",null,498866.57,null,997687.68,null,"AE Info to EE : "]
[null,null,null,null,null,"Maiden Name : ",null,null,null,null,null,null,null,null,null,"Contract Based Info to EE: "]
[null,"NI Code : ",null,"Not C/O Standard",null,null,null,null,null,"Niable Pay : ",null,1111211,null,2222322,null,"Re-enrolment Date : "]
[null,"NI Number : ",null,"GY548374A",null,null,null,null,null,"Employee NI : ",null,22517.62,null,45033.24,null,"Re-enrolment Info to EE : "]
[null,"Tax Code : ",null,"K12",null,"Holiday Ent. : ",null,25,null,"Employers NI : ",null,153253.28,null,306492.76,null,"Opt-in Commencement : "]
[null,"Student Loan : ",null,{"$f":"[1]!AG_DTLK(\"0,3,PEGASUS,WN,F={P}1,K=CoID,F={P}2,K=/WN/1,E=9,O=Student Loan{Fmt}=8{Cm}0{DefVal}={Formula}=If {/WN/136}={Qt}Y{Qt} Then{Cr}{Lf}Result = {Qt}Plan 1{Qt}{Cr}{Lf}Else{Cr}{Lf}If {/WN/f31}={Qt}Y{Qt} Then{Cr}{Lf}Result = {Qt}Plan 2{Qt}{Cr}{Lf}Else{Cr}{Lf}Result\",\" = {Qt}{Qt}{Cr}{Lf}End If{Cr}{Lf}End If,C={P}3,E=0,O=/WN/HR/122,C={P}4,E=0,O=/WN/WCO*1/f1,C={P}5,E=0,O=/WN/WCO*1/f4,\",Payroll!D17,D$3,D$4,D$29,D$27,D$28)","v":""},null,"Pay Frequency : ",null,"M",null,null,null,null,null,null,null,"Right to Opt-in Info to EE : "]
[null,"Director Start Date : ",null,"2012-07-01",null,null,null,null,null,"Pensionable Pay : ",null,1111111,null,2222222,null,"Right to Opt-In Notice : "]
[null,null,null,null,null,null,null,null,null,"Net Pay : ",null,489826.82,null,199999.98,null,"Right to Join Info to EE : "]
[null,"Address : ",null,"6 The Grove",null,null,null,null,null,null,null,null,null,null,null,"Right to Join Date : "]
[null,null,null,"Wiston Mallet",null,"Tel : ",null,"01604 539487",null,"Bank Sort Code : ",null,{"$f":"[1]!AG_DTLK(\"0,2,PEGASUS,WN,F={P}1,K=CoID,F={P}2,K=/WN/1,E=0,O=/WN/15,C={P}3,E=0,O=/WN/14,C={P}4,E=0,O=/WN/16,C={P}5,E=0,O=/WN/106,C={P}6,E=0,O=/WN/17,\",Payroll!L21,$D$3,$D$4,L$23,L$22,L$24,L$25)","v":"204577"},null,null,null,"Qual. Scheme Info to EE : "]
[null,null,null,"Northants",null,"Mobile : ",null,null,null,"Bank Account # : ",null,65498654,null,null,null,"Active Member :"]
[null,null,null,null,null,"Leave Date : ",null,null,null,"Payee : ",null,"R GODSON",null,null,null,"Opt Out Date : "]
[null,null,null,null,null,null,null,null,null,"B/Soc Roll # : "]
[null,"Post Code :  ",null,"NN4 7RW",null,null,null,null,null,"Bank Ref : ",null,44958]
[]
[null,"Home e-mail : "]
[null,"Work e-mail : "]
[null,"e-mail : "]
[]
[]
[null,"Personnel Information",null,null,null,null,null,null,null,null,null,null,null,"Education"]
[]
[null,"Ethnic Origin : ",null,{"$f":"[1]!AG_DTLK(\"0,3,PEGASUS,HR,F={P}1,K=CoID,F={P}2,K=/HR/1,E=0,O=/HR/HE/2,C={P}3,E=0,O=/HR/10,C={P}4,E=0,O=/HR/50,C={P}5,E=0,O=/HR/51,C={P}6,E=0,O=/HR/14,C={P}7,E=0,O=/HR/15,C={P}8,E=0,O=/HR/17,C={P}9,E=0,O=/HR/18,C={P}10,E=0,O=/HR/19,C={P}11,E=0,O=/HR/20,C={P}12,E=21,O\",\"=/HR/6,C={P}13,E=0,O=/HR/7,C={P}14,E=21,O=/HR/49,\",Payroll!D34,D$3,D$4,D$35,D$36,D$37,D$39,D$40,D$41,D$42,D$43,D$44,D$45,D$46,D$47)","v":"European"},null,"Contact 1 - Name : ",null,{"$f":"[1]!AG_DTLK(\"0,3,PEGASUS,HR,F={P}1,K=CoID,F={P}2,K=/HR/1,E=9,O=Full Name{Fmt}=8{Cm}0{DefVal}={Formula}={/HR/24}&{Qt} {Qt}&{/HR/23}&{Qt} {Qt}&{/HR/22},C={P}3,E=0,O=/HR/25,C={P}4,E=21,O=/HR/26,C={P}5,E=21,O=/HR/27,C={P}6,E=0,O=/HR/54,C={P}7,E=0,O=/HR/28,C={P}8,E=0,O=/HR\",\"/29,C={P}9,E=0,O=/HR/30,C={P}10,E=0,O=/HR/31,C={P}11,E=0,O=/HR/32,C={P}12,E=0,O=/HR/33,C={P}13,E=0,O=/HR/34,\",Payroll!H34,$D$3,$D$4,H$35,H$36,H$37,H$38,H$39,H$40,H$41,H$42,H$43,H$44,H$45)","v":"Mrs Jane Godson"},null,"Contact 2 - Name : ",null,{"$f":"[1]!AG_DTLK(\"0,3,PEGASUS,HR,F={P}1,K=CoID,F={P}2,K=/HR/1,E=9,O=Full Name{Fmt}=8{Cm}0{DefVal}={Formula}={/HR/37}&{Qt} {Qt}&{/HR/36}&{Qt} {Qt}&{/HR/35},C={P}3,E=0,O=/HR/38,C={P}4,E=21,O=/HR/39,C={P}5,E=21,O=/HR/40,C={P}6,E=0,O=/HR/41,C={P}7,E=0,O=/HR/42,C={P}8,E=0,O=/HR\",\"/43,C={P}9,E=0,O=/HR/44,C={P}10,E=0,O=/HR/45,C={P}11,E=0,O=/HR/46,C={P}12,E=0,O=/HR/47,C={P}13,E=0,O=/HR/48,\",Payroll!L34,$D$3,$D$4,L$35,L$36,L$37,L$38,L$39,L$40,L$41,L$42,L$43,L$44,L$45)","v":"Mr Tim Godson"},null,"School attended : ",null,{"$f":"[1]!AG_DTLK(\"0,3,PEGASUS,HR,F={P}1,K=CoID,F={P}2,K=/HR/1,E=0,O=/HR/91,C={P}3,E=0,O=/HR/92,C={P}4,E=0,O=/HR/93,C={P}5,E=0,O=/HR/102,C={P}6,E=0,O=/HR/103,C={P}7,E=0,O=/HR/104,C={P}8,E=0,O=/HR/105,C={P}9,E=0,O=/HR/94,C={P}10,E=0,O=/HR/95,C={P}11,E=0,O=/HR/96,C={P}12,E=0,\",\"O=/HR/98,C={P}13,E=0,O=/HR/97,C={P}14,E=0,O=/HR/99,\",Payroll!P34,$D$3,$D$4,$R34,$R$35,P$37,$R$37,$R$38,P$45,P$39,P$40,P$41,P$42,P$43,P$44)","v":"Barford Lodge School, Kent"},"F","1953-09-03"]
[null,"Dependants : ",null,2,null,"Relationship : ",null,"Wife",null,"Relationship : ",null,"Father",null,null,null,null,"T","1960-06-27"]
[null,"Locker # : ",null,null,null,"Next of Kin : ",null,"Yes",null,"Next of Kin : ",null,"No"]
[null,"Badge # : ",null,1,null,"Emergency : ",null,"Yes",null,"Emergency : ",null,"No",null,"Further Education :",null,null,"F"]
[null,null,null,null,null,"Address : ",null,"As Home Address",null,"Address : ",null,"88 Willow Drive",null,null,null,null,"T"]
[null,"Car Registration : ",null,"KM51 DVS",null,null,null,null,null,null,null,"West Barton",null,"GCSE : ",null,0]
[null,"License # : ",null,"GR39487589DGKJH",null,null,null,null,null,null,null,"Kent",null,"O Level : ",null,6]
[null,"Points : ",null,3,null,null,null,null,null,null,null,null,null,"NVQ : ",null,0]
[null,"Date Checked : ",null,"1999-11-11",null,null,null,null,null,null,null,null,null,"AS Level :",null,0]
[null,"Eye Test : ",null,null,null,"Home : ",null,"01604 539487",null,"Home : ",null,"01689 438873",null,"A Level : ",null,0]
[null,"Medical : ",null,null,null,"Work : ",null,"01604 333746",null,"Work : ",null,null,null,"Other : ",null,0]
[null,"Disabled : ",null,"No",null,"Mobile : ",null,null,null,"Mobile : ",null,null,null,"Further Qualifications : "]
[null,"Disability # : "]
[null,"Smoker : ",null,"Yes"]
[]
[]
[null,"Pensions"]
[]
[null,{"$f":"[1]!AG_DTRT(\"0,Employee Pension Information,1\",$D$3,$D$4,$D$4)","v":"Scheme Description"},"s","EE Scheme Ref","w","Date Joined","q","Date Left","a","ER Cont TDTP","j","EE Cont TDTP","g","EE AVC TDTP"]
[null,"Eligible/NE Jobholders","","ADSDF/324324","","2016-01-01","",null,"",22222.22,"",111111.1,"",66666.66]
[null,"Entitled Workers","","","","2016-01-01","",null,"",22222.22,"",22222.22,"",0]
[]
[]
[]
[]
[]
[null,"Attachment Orders"]
[]
[null,{"$f":"[1]!AG_DTRT(\"0,Employee Attachment Orders,1\",$D$3,$D$4,$D$4)","v":"Attach. Order Type"},1,"Order Reference",2,"Date Issued",3,"Date Completed",4,"Normal Rate",5,"Protected Earnings","%","Total to be Paid",7,"Total Deducted TDTP"]
[null,"Council Tax AEO (CTAEO)","","case347812","",null,"","2006-08-31","",0,"",40,"Yes",3400,"",3400]

{"sheet":"HR","index":3,"n_rows":8,"n_cols":39,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["For Employee : ",{"$f":"Payroll!D4","v":1001},{"$f":"Payroll!D8","v":"Mr Richard Godson"}]
[]
[null,"Job",null,null,null,null,null,null,null,null,"Salary",null,null,null,null,null,null,null,"Training",null,null,null,null,null,null,null,null,"Absence",null,null,null,null,null,null,null,"Disciplinary"]
[]
[null,{"$f":"[1]!AG_DTRT(\"0,HR Job Data,1\",Payroll!$D$3,Payroll!$D4,Payroll!$D4)","v":"From Date"},"To Date","Job Title","Department Number","Last Review Date","Next Review Date","Comment",null,null,{"$f":"[1]!AG_DTRT(\"0,HR Salary Data,1\",Payroll!$D$3,Payroll!$D$4,Payroll!$D$4)","v":"Date Effective"},"Reason Code Text","Old Salary","Salary","Next Review Date","Comment",null,null,{"$f":"[1]!AG_DTRT(\"0,HR Training Data,1\",Payroll!$D$3,Payroll!$D$4,Payroll!$D$4)","v":"From Date"},"To Date","Description","Number of Days","Supplier","Result etc","Comment",null,null,{"$f":"[1]!AG_DTRT(\"0,HR Absence Data,1\",Payroll!$D$3,Payroll!$D$4,Payroll!$D$4)","v":"From Date"},"To Date","Absence Code","Number of Days","Description","Comment",null,null,{"$f":"[1]!AG_DTRT(\"0,HR Disciplinary Data,1\",Payroll!$D$3,Payroll!$D$4,Payroll!$D$4)","v":"Date"},"Description","Review Date","Comment"]
[null,"2002-03-02",null,"Managing Director","ADMN",null,null,"",null,null,"2017-01-01","st",0,20000,null,"",null,null,"2014-04-14","2014-04-18","Computer Software",5,"QBIT IT Limited","","",null,null,"2013-11-08","2013-11-16","Holiday",6,"Holiday",""]
[null,null,null,null,null,null,null,null,null,null,"2020-01-01","drsetdfgdf",20000,40000,null,"",null,null,null,null,null,null,null,null,null,null,null,"2016-10-03","2016-10-14","Holiday",10,"Holiday",""]
[null,null,null,null,null,null,null,null,null,null,"2021-01-01","hgcvhggh",40000,80000,null,""]

{"sheet":"PHRExport","index":4,"n_rows":3,"n_cols":132,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Name","Date Of Birth","Start Date","Passport #","Gender","NI Code","NI Number","Tax Code","Student Loan","Director Start Date","Address 1","Address 2","Address 3","Address 4","Address 5","Post Code ","Home e-mail","Work e-mail","e-mail","Group","Department","Position","Marital Status","Maiden Name","Holiday Ent.","Pay Frequency","Tel","Mobile","Leave Date","Bank Sort Code","Bank Account #","Payee","B/Soc Roll #","Bank Ref","Category","Status","AE Date","AE Info to EE","Contract Based Info to EE","Re-enrolment Date","Re-enrolment Info to EE","Opt-in Commencement","Right to Opt-in Info to EE","Right to Opt-In Notice","Right to Join Info to EE","Right to Join Date","Qual. Scheme Info to EE","Active Member ","Opt Out Date","Gross Pay TP","Taxable Pay TP","Tax Paid/Due TP","Niable Pay TP","Employee NI TP","Employers NI TP","Pensionable Pay TP","Net Pay TP","Gross Pay","Taxable Pay","Tax Paid/Due","Niable Pay","Employee NI","Employers NI","Pensionable Pay","Net Pay","Ethnic Origin","Dependants","Locker #","Badge #","Car Registration","License #","Points","Date Checked","Eye Test","Medical","Disabled","Disability #","Smoker","Contact 1 - Name","Relationship","Next of Kin","Emergency","Address 1","Address 2","Address 3","Address 4","Address 5","Home","Work","Mobile","Contact 2 - Name","Relationship","Next of Kin","Emergency","Address","Address 1","Address 2","Address 3","Address 4","Address 5","Home","Work","Mobile","School attended","From","To","Further Education ","From","To","GCSE","O Level","NVQ","AS Level ","A Level","Other","Further Qualifications","Scheme Description","EE Scheme Ref","Date Joined","Date Left","ER Cont TDTP","EE Cont TDTP","EE AVC TDTP","Attach. Order Type","Order Reference","Date Issued","Date Completed","Normal Rate","Protected Earnings","%","Total to be Paid","Total Deducted TDTP"]
[{"$f":"[1]!AG_DTLK(\"0,4,PEGASUS,WN,F={P}1,K=CoID,F={P}2,K=/WN/1,E=0,O=/WN/197,C={P}3,E=0,O=/WN/22,C={P}4,E=0,O=/WN/23,C={P}5,E=0,O=/WN/f19,C={P}6,E=21,O=/WN/13,C={P}7,E=21,O=/WN/11,C={P}8,E=0,O=/WN/12,C={P}9,E=0,O=/WN/9,C={P}10,E=9,O=Student Loan{Fmt}=8{Cm}0{DefVal}={Formula\",\"}=If {/WN/136}={Qt}Y{Qt} Then{Cr}{Lf}Result = {Qt}Plan 1{Qt}{Cr}{Lf}Else{Cr}{Lf}If {/WN/f31}={Qt}Y{Qt} Then{Cr}{Lf}Result = {Qt}Plan 2{Qt}{Cr}{Lf}Else{Cr}{Lf}Result = {Qt}{Qt}{Cr}{Lf}End If{Cr}{Lf}End If,C={P}11,E=0,O=/WN/174,C={P}12,E=0,O=/WN/31,C={P}13,\",\"E=0,O=/WN/32,C={P}14,E=0,O=/WN/33,C={P}15,E=0,O=/WN/34,C={P}16,E=0,O=/WN/35,C={P}17,E=0,O=/WN/36,C={P}18,E=0,O=/WN/WCO*1/f1,C={P}19,E=0,O=/WN/WCO*1/f4,C={P}20,E=0,O=/WN/HR/122,C={P}21,E=0,O=/WN/195,C={P}22,E=0,O=/WN/WA/2,\",PHRExport!A2,Payroll!$D$3,Payroll!$D$4,B2,C2,D2,E2,F2,G2,H2,I2,J2,K2,L2,M2,N2,O2,P2,Q2,R2,S2,T2,U2)","v":"Godson Richard"},"1971-06-03","2012-07-01",null,"Male","Not C/O Standard","GY548374A","K12",null,"2012-07-01","6 The Grove","Wiston Mallet","Northants",null,null,"NN4 7RW",null,null,null,"Monthly","Administration",{"$f":"[1]!AG_DTLK(\"0,3,PEGASUS,WN,F={P}1,K=CoID,F={P}2,K=/WN/1,E=0,O=/WN/HJ/HZ/2,C={P}3,E=0,O=/WN/HR/124,C={P}4,E=0,O=/WN/HR/11,C={P}5,E=0,O=/WN/103,C={P}6,E=0,O=/WN/21,C={P}7,E=0,O=/WN/HR/5,C={P}8,E=0,O=/WN/HR/111,C={P}9,E=0,O=/WN/24,C={P}10,E=0,O=/WN/15,C={P}11,E=0,O=/WN/\",\"16,C={P}12,E=0,O=/WN/14,C={P}13,E=0,O=/WN/106,C={P}14,E=0,O=/WN/17,\",PHRExport!V2,Payroll!$D$3,Payroll!$D$4,W2,X2,Y2,Z2,AA2,AB2,AC2,AD2,AE2,AF2,AG2,AH2)","v":"Managing Director"},"Married",null,25,"M","01604 539487",null,null,204577,65498654,"R GODSON",null,44958,{"$f":"[1]!AG_DTLK(\"0,3,PEGASUS,WN,F={P}1,K=CoID,F={P}2,K=/WN/1,E=21,O=/WN/WEN*1/WC,C={P}3,E=21,O=/WN/WEN*1/WC1,C={P}4,E=0,O=/WN/WEN*1/WA,C={P}5,E=0,O=/WN/WEN*1/WA1,C={P}6,E=0,O=/WN/WEN*1/WC8,C={P}7,E=0,O=/WN/WEN*1/f8,C={P}8,E=0,O=/WN/WEN*1/f9,C={P}9,E=0,O=/WN/WEN*1/WO2,C={P\",\"}10,E=0,O=/WN/WEN*1/WO3,C={P}11,E=0,O=/WN/WEN*1/WO1,C={P}12,E=0,O=/WN/WEN*1/WJ1,C={P}13,E=0,O=/WN/WEN*1/WJ,C={P}14,E=0,O=/WN/WEN*1/WQ,C={P}15,E=0,O=/WN/WEN*1/WA2,C={P}16,E=0,O=/WN/WEN*1/WO6,\",PHRExport!AI2,Payroll!$D$3,Payroll!$D$4,AJ2,AK2,AL2,AM2,AN2,AO2,AP2,AR2,AQ2,AS2,AT2,AU2,AV2,AW2)","v":"EJ"},"AutoEnrolled","2016-01-01",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]!AG_DTLK(\"0,3,PEGASUS,WN,F={P}1,K=CoID,F={P}2,K=/WN/1,E=0,O=/WN/55,C={P}3,E=0,O=/WN/73,C={P}4,E=0,O=/WN/74,C={P}5,E=0,O=/WN/79,C={P}6,E=0,O=/WN/77,C={P}7,E=0,O=/WN/76,C={P}8,E=0,O=/WN/84,C={P}9,E=0,O=/WN/75,C={P}10,E=0,O=/WN/71,C={P}11,E=0,O=/WN/60,C={P}12,E=0,O=/W\",\"N/61,C={P}13,E=0,O=/WN/WC/9,C={P}14,E=0,O=/WN/WC/7,C={P}15,E=0,O=/WN/WC/6,C={P}16,E=0,O=/WN/70,C={P}17,E=0,O=/WN/f13,\",PHRExport!AX2,Payroll!$D$3,Payroll!$D$4,AY2,AZ2,BA2,BB2,BC2,BD2,BE2,BF2,BG2,BH2,BI2,BJ2,BK2,BL2,BM2)","v":1111111},1111211,498866.57,1111211,22517.62,153253.28,1111111,489826.82,1111211,2222322,997687.68,1111111,22515.62,153239.48000000001,2222222,199999.98,{"$f":"[1]!AG_DTLK(\"0,3,PEGASUS,WN,F={P}1,K=CoID,F={P}2,K=/WN/1,E=0,O=/WN/HR/HE/2,C={P}3,E=0,O=/WN/HR/10,C={P}4,E=0,O=/WN/HR/50,C={P}5,E=0,O=/WN/HR/51,C={P}6,E=0,O=/WN/HR/14,C={P}7,E=0,O=/WN/HR/15,C={P}8,E=0,O=/WN/HR/17,C={P}9,E=0,O=/WN/HR/18,C={P}10,E=0,O=/WN/HR/19,C={P}11,\",\"E=0,O=/WN/HR/20,C={P}12,E=21,O=/WN/HR/6,C={P}13,E=0,O=/WN/HR/7,C={P}14,E=21,O=/WN/HR/49,\",PHRExport!BN2,Payroll!$D$3,Payroll!$D$4,BO2,BP2,BQ2,BR2,BS2,BT2,BU2,BV2,BW2,BX2,BY2,BZ2)","v":"European"},2,null,1,"KM51 DVS","GR39487589DGKJH",3,"1999-11-11",null,null,"No",null,"Yes",{"$f":"[1]!AG_DTLK(\"0,4,PEGASUS,WN,F={P}1,K=CoID,F={P}2,K=/WN/1,E=9,O=Name{Fmt}=8{Cm}0{DefVal}={Formula}={/WN/HR/24} & {Qt} {Qt} &{/WN/HR/23} & {Qt} {Qt} &{/WN/HR/22},C={P}3,E=0,O=/WN/HR/25,C={P}4,E=21,O=/WN/HR/26,C={P}5,E=21,O=/WN/HR/27,C={P}6,E=0,O=/WN/HR/54,C={P}7,E=0,O=/\",\"WN/HR/28,C={P}8,E=0,O=/WN/HR/29,C={P}9,E=0,O=/WN/HR/30,C={P}10,E=0,O=/WN/HR/31,C={P}11,E=0,O=/WN/HR/32,C={P}12,E=0,O=/WN/HR/33,C={P}13,E=0,O=/WN/HR/34,C={P}14,E=9,O=Name2{Fmt}=8{Cm}0{DefVal}={Formula}={/WN/HR/37} & {Qt} {Qt} &{/WN/HR/36} & {Qt} {Qt} &{/WN\",\"/HR/35},C={P}15,E=0,O=/WN/HR/38,C={P}16,E=21,O=/WN/HR/39,C={P}17,E=21,O=/WN/HR/40,C={P}18,E=0,O=/WN/HR/41,C={P}19,E=0,O=/WN/HR/42,C={P}20,E=0,O=/WN/HR/43,C={P}21,E=0,O=/WN/HR/44,C={P}22,E=0,O=/WN/HR/45,\",PHRExport!CA2,Payroll!$D$3,Payroll!$D$4,CB2,CC2,CD2,CE2,CF2,CG2,CH2,CI2,CJ2,CK2,CL2,CM2,CN2,CO2,CP2,CQ2,CR2,CS2,CT2,CU2)","v":"Mrs Jane Godson"},"Wife","Yes","Yes","As Home Address",null,null,null,null,"01604 539487","01604 333746",null,"Mr Tim Godson","Father","No","No","88 Willow Drive","West Barton","Kent",null,null,null,{"$f":"[1]!AG_DTLK(\"0,3,PEGASUS,WN,F={P}1,K=CoID,F={P}2,K=/WN/1,E=0,O=/WN/HR/46,C={P}3,E=0,O=/WN/HR/47,C={P}4,E=0,O=/WN/HR/48,C={P}5,E=0,O=/WN/HR/91,C={P}6,E=0,O=/WN/HR/92,C={P}7,E=0,O=/WN/HR/93,C={P}8,E=0,O=/WN/HR/102,C={P}9,E=0,O=/WN/HR/103,C={P}10,E=0,O=/WN/HR/104,C={P}11\",\",E=0,O=/WN/HR/94,C={P}12,E=0,O=/WN/HR/95,C={P}13,E=0,O=/WN/HR/96,C={P}14,E=0,O=/WN/HR/98,C={P}15,E=0,O=/WN/HR/97,C={P}16,E=0,O=/WN/HR/99,C={P}17,E=0,O=/WN/HR/105,\",PHRExport!CW2,Payroll!$D$3,Payroll!$D$4,CX2,CY2,CZ2,DA2,DB2,DC2,DD2,DE2,DF2,DG2,DH2,DI2,DJ2,DK2,DL2)","v":"01689 438873"},null,null,"Barford Lodge School, Kent","1953-09-03","1960-06-27",null,null,null,0,6,0,0,0,0,null,{"$f":"AG_DTRT(\"0,Employee Pension Information Export,1\",Payroll!$D$3,Payroll!$D$4,Payroll!$D$4)","v":"Eligible/NE Jobholders"},"ADSDF/324324","2016-01-01",null,22222.22,111111.1,66666.66,{"$f":"AG_DTRT(\"0,Employee Attachment Orders Export,1\",Payroll!$D$3,Payroll!$D$4,Payroll!$D$4)","v":"Council Tax AEO (CTAEO)"},"case347812",null,"2006-08-31",0,40,"Yes",3400,3400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entitled Workers","","2016-01-01",null,22222.22,22222.22,0]

{"sheet":"Sales Contact","index":5,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Company ID: ","Z"]
[null,"Contact Ref: ","AmandaWintermanWIN00012013-03-2215:23:21"]
[]
[null,{"$f":"[1]!AG_DTRT(\"0,Sales Contact Details,1\",$C$2,$C$3,$C$3)","v":"Ledger"},"Sales"]
[null,"Account","WIN0001"]
[null,"Salutation","Amanda"]
[null,"Title",""]
[null,"Forename","Amanda"]
[null,"Surname","Winterman"]
[null,"Contact Option","A/C Contact"]
[null,"Date of Birth"]
[null,"Phone","01604 589682"]
[null,"Fax",""]
[null,"Mobile",""]
[null,"Email",""]
[null,"Attribute 1",""]
[null,"Description",""]
[null,"Attribute 2",""]
[null,"Description",""]
[null,"Attribute 3",""]
[null,"Description",""]
[null,"Attribute 4",""]
[null,"Description",""]
[null,"Attribute 5",""]
[null,"Description",""]
[null,"Attribute 6",""]
[null,"Description",""]
[null,"Creation Date","2013-03-22"]
[null,"Creation Time","15:23:21"]
[null,"Date Last Amendment","2013-03-22"]
[null,"Time Last Amendment","15:36:42"]
[null,"Position",""]
[null,"ID","AmandaWintermanWIN00012013-03-2215:23:21"]

{"sheet":"SCExport","index":6,"n_rows":2,"n_cols":30,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[{"$f":"AG_DTRT(\"0,Sales Contact Details Export,1\",'Sales Contact'!$C$2,'Sales Contact'!$C$3,'Sales Contact'!$C$3)","v":"Ledger"},"Account","Salutation","Title","Forename","Surname","Contact Option","Date of Birth","Phone","Fax","Mobile","Email","Attribute 1","Description","Attribute 2","Description","Attribute 3","Description","Attribute 4","Description","Attribute 5","Description","Attribute 6","Description","Creation Date","Creation Time","Date Last Amendment","Time Last Amendment","Position","ID"]
["Sales","WIN0001","Amanda","","Amanda","Winterman","A/C Contact",null,"01604 589682","","","","","","","","","","","","","","","","2013-03-22","15:23:21","2013-03-22","15:36:42","","AmandaWintermanWIN00012013-03-2215:23:21"]

{"sheet":"Purchase Contact","index":7,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Company ID: ","Z"]
[null,"Contact Ref: ","CharlesFarleyPAR00012007-07-0417:50:38"]
[]
[null,{"$f":"[1]!AG_DTRT(\"0,Purchase Contact Details,1\",$C$2,$C$3,$C$3)","v":"Ledger"},"Purchase"]
[null,"Account","PAR0001"]
[null,"Salutation","Charlie Farley"]
[null,"Title",""]
[null,"Forename","Charles"]
[null,"Surname","Farley"]
[null,"Contact Option","A/C Contact"]
[null,"Date of Birth"]
[null,"Phone","01832 568321"]
[null,"Fax","01832 565656"]
[null,"Mobile",""]
[null,"Email",""]
[null,"Attribute 1",""]
[null,"Description",""]
[null,"Attribute 2",""]
[null,"Description",""]
[null,"Attribute 3",""]
[null,"Description",""]
[null,"Attribute 4",""]
[null,"Description",""]
[null,"Attribute 5",""]
[null,"Description",""]
[null,"Attribute 6",""]
[null,"Description",""]
[null,"Creation Date","2007-07-04"]
[null,"Creation Time","17:50:38"]
[null,"Date Last Amendment","2008-09-27"]
[null,"Time Last Amendment","14:00:27"]
[null,"Position","Buyer"]
[null,"ID","CharlesFarleyPAR00012007-07-0417:50:38"]

{"sheet":"PCExport","index":8,"n_rows":2,"n_cols":30,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[{"$f":"AG_DTRT(\"0,Purchase Contact Details Export,1\",'Purchase Contact'!$C$2,'Purchase Contact'!$C$3,'Purchase Contact'!$C$3)","v":"Ledger"},"Account","Salutation","Title","Forename","Surname","Contact Option","Date of Birth","Phone","Fax","Mobile","Email","Attribute 1","Description","Attribute 2","Description","Attribute 3","Description","Attribute 4","Description","Attribute 5","Description","Attribute 6","Description","Creation Date","Creation Time","Date Last Amendment","Time Last Amendment","Position","ID"]
["Purchase","PAR0001","Charlie Farley","","Charles","Farley","A/C Contact",null,"01832 568321","01832 565656","","","","","","","","","","","","","","","2007-07-04","17:50:38","2008-09-27","14:00:27","Buyer","CharlesFarleyPAR00012007-07-0417:50:38"]

{"sheet":"People Profiles","index":9,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Company ID: ","Z"]
[null,"Person Code: ","DEWER001"]
[]
[]
[null,"Personal Details",null,null,null,"Sub-contractor Details"]
[]
[null,"Title: ",{"$f":"[1]!AG_DTLK(\"0,4,PEGASUS,SP,F={P}1,K=CoID,F={P}2,K=/SP/72,E=0,O=/SP/69,C={P}3,E=0,O=/SP/70,C={P}4,E=0,O=/SP/77,C={P}5,E=0,O=/SP/84,C={P}6,E=0,O=/SP/83,C={P}7,E=0,O=/SP/82,C={P}8,E=0,O=/SP/81,C={P}9,E=0,O=/SP/73,C={P}10,E=0,O=/SP/75,C={P}11,E=0,O=/SP/78,C={P}12,E=0,O=/\",\"SP/80,C={P}13,E=0,O=/SP/76,C={P}14,E=21,O=/SP/79,C={P}15,E=21,O=/SP/71,C={P}16,E=21,O=/SP/74,C={P}17,E=0,O=/SP/JS/2,C={P}18,E=0,O=/SP/JS/3,C={P}19,E=0,O=/SP/JS/11,C={P}20,E=0,O=/SP/JS/12,C={P}21,E=0,O=/SP/JS/13,C={P}22,E=0,O=/SP/JS/14,C={P}23,E=0,O=/SP/JS\",\"/15,\",'People Profiles'!C8,C$2,C$3,C$10,C$9,C$11,C$12,C$13,C$14,C$15,C$17,C$18,C$20,C$19,$G8,$G$9,$G$10,$G$12,$G$13,$G$14,$G$15,$G$16,$G$17,$G$18)","v":{"$error":"#N/A"}},null,null,"Costing EE: ","No"]
[null,"Forename: ","David John",null,null,"Costing SuCb.: ","Yes"]
[null,"Surname: ","Dewer",null,null,"Project Leader: ","No"]
[null,"Address: ","24 Bracken Hill"]
[null,null,"Hutton",null,null,"Tax Ref: ","790/23898"]
[null,null,"Yorkshire",null,null,"Tax Rate (%): ",20]
[null,null,null,null,null,"Certification Code: "]
[null,"Post Code: ","YO60 6QG",null,null,"Certification Number: ",0]
[null,null,null,null,null,"Company Reg. Number: "]
[null,"Telephone: ",null,null,null,"Start Date (Month/Year): "]
[null,"Fax: ",null,null,null,"Expiry Date (Month/Year): "]
[null,"Mobile: "]
[null,"E-mail: "]
[]
[]
[]
[]
[null,"Sales Notes",null,null,null,null,null,"NB: System generated notes are ommitted"]
[]
[null,{"$f":"[1]!AG_DTRT(\"0,Sales Notes,1\",$C$2,$C$3,$C$3)","v":"Account"},"Creation Date","Priority","Action Date","E-mail","Subject","Comments"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Purchase Notes"]
[]
[null,{"$f":"[1]!AG_DTRT(\"0,Purchase Notes,1\",$C$2,$C$3,$C$3)","v":"Account"},"Creation Date","Priority","Action Date","E-mail","Subject","Comments"]

{"sheet":"PPExport","index":10,"n_rows":2,"n_cols":36,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Title","Forename","Surname","Address 1","Address 2","Address 3","Address 4","Post Code","Telephone","Fax","Mobile","E-mail","Costing EE","Costing SuCb.","Project Leader","Tax Ref","Tax Rate (%)","Certification Code","Certification Number","Company Reg. Number","Start Date (Month/Year)","Expiry Date (Month/Year)",{"$f":"AG_DTRT(\"0,Sales Notes Export,1\",'People Profiles'!$C$2,'People Profiles'!$C$3,'People Profiles'!$C$3)","v":"Account"},"Creation Date","Priority","Action Date","E-mail","Subject","Comments",{"$f":"AG_DTRT(\"0,Purchase Notes Export,1\",'People Profiles'!$C$2,'People Profiles'!$C$3,'People Profiles'!$C$3)","v":"Account"},"Creation Date","Priority","Action Date","E-mail","Subject","Comments"]
[{"$f":"[1]!AG_DTLK(\"0,4,PEGASUS,SP,F={P}1,K=CoID,F={P}2,K=/SP/72,E=0,O=/SP/69,C={P}3,E=0,O=/SP/70,C={P}4,E=0,O=/SP/77,C={P}5,E=0,O=/SP/84,C={P}6,E=0,O=/SP/83,C={P}7,E=0,O=/SP/82,C={P}8,E=0,O=/SP/81,C={P}9,E=0,O=/SP/73,C={P}10,E=0,O=/SP/75,C={P}11,E=0,O=/SP/78,C={P}12,E=0,O=/\",\"SP/80,C={P}13,E=0,O=/SP/76,C={P}14,E=21,O=/SP/79,C={P}15,E=21,O=/SP/71,C={P}16,E=21,O=/SP/74,C={P}17,E=0,O=/SP/JS/2,C={P}18,E=0,O=/SP/JS/3,C={P}19,E=0,O=/SP/JS/11,C={P}20,E=0,O=/SP/JS/12,C={P}21,E=0,O=/SP/JS/13,C={P}22,E=0,O=/SP/JS/14,C={P}23,E=0,O=/SP/JS\",\"/15,\",PPExport!A2,'People Profiles'!C$2,'People Profiles'!C$3,$B2,$C2,D$2,E$2,F$2,G$2,H$2,I$2,J$2,L$2,K$2,$M2,$N$2,$O$2,$P$2,$Q$2,$R$2,$S$2,$T$2,$U$2,$V$2)","v":"Mr"},"Dewer","David John","24 Bracken Hill","Hutton","Yorkshire",null,"YO60 6QG",null,null,null,null,"No","Yes","No","790/23898",20,null,0]

{"sheet":"CRMEE","index":11,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,7,3,8]]}
[]
[]
[null,"Company ID: ","Z",null,null,"Inactive flag : ",{"$f":"[1]!AG_DTLK(\"0,2,PEGASUS,SP6,F={P}1,K=CoID,F={P}2,K=/SP6/EMA,E=21,O=/SP6/LIN,\",CRMEE!G3,$C3,$C$4)","v":"No"},{"$f":"IF(G3=\"Y\",\"Inactive Record\",\"Active Contact Record\")","v":"Active Contact Record"}]
[null,"CRM EE Ref (E-mail) : ","adam.s@orionvl.co.uk"]
[]
[]
[null,"Title : ",{"$f":"[1]!AG_DTLK(\"0,3,PEGASUS,SP6,F={P}1,K=CoID,F={P}2,K=/SP6/EMA,E=0,O=/SP6/TIT,C={P}3,E=0,O=/SP6/FIR,C={P}4,E=0,O=/SP6/LAS1,C={P}5,E=0,O=/SP6/SAL,C={P}6,E=0,O=/SP6/n3,C={P}7,E=0,O=/SP6/n14,C={P}8,E=0,O=/SP6/DOB,C={P}9,E=0,O=/SP6/EMA,C={P}10,E=21,O=/SP6/LEM,C={P}11,E=21,O\",\"=/SP6/LSU,C={P}12,E=21,O=/SP6/LPR,C={P}13,E=0,O=/SP6/SP5*1/CN1,C={P}14,E=0,O=/SP6/SP5*1/ADD,C={P}15,E=0,O=/SP6/SP5*1/ADD1,C={P}16,E=0,O=/SP6/SP5*1/ADD2,C={P}17,E=0,O=/SP6/SP5*1/ADD3,C={P}18,E=0,O=/SP6/SP5*1/POS,\",CRMEE!C7,C$3,C$4,C$8,C$9,C$10,C$18,C$19,C$20,C$21,C$23,C$25,C$24,C$11,C$12,C$13,C$14,C$15,C$16)","v":"Mr"},null,"Business Telephone : ",{"$f":"[1]!AG_DTLK(\"0,3,PEGASUS,SP6,F={P}1,K=CoID,F={P}2,K=/SP6/EMA,E=0,O=/SP6/PHO,C={P}3,E=0,O=/SP6/PHO1,C={P}4,E=0,O=/SP6/FAX,C={P}5,E=0,O=/SP6/MOB,C={P}6,E=0,O=/SP6/PHO2,C={P}7,E=0,O=/SP6/PHO3,C={P}8,E=0,O=/SP6/PHO4,C={P}9,E=0,O=/SP6/PHO5,C={P}10,E=0,O=/SP6/PHO6,C={P}11,E\",\"=21,O=/SP6/LNO,C={P}12,E=21,O=/SP6/LNO1,C={P}13,E=21,O=/SP6/LNO2,C={P}14,E=0,O=/SP6/USE,C={P}15,E=0,O=/SP6/f1,C={P}16,E=0,O=/SP6/GEN,C={P}17,E=21,O=/SP6/OUT,C={P}18,E=21,O=/SP6/CAL,\",CRMEE!F7,$C$3,$C$4,F$9,F$10,F$11,F$12,F$14,F$15,F$16,F$17,F$19,F$20,F$21,F$23,F$24,F$25,F$27,F$28)","v":""},null,{"$f":"[1]!AG_DTRT(\"0,CRM EE UDFs,1\",$C$3,$C$4,$C$4)","v":"Partner's Name"},"",""]
[null,"First Name(s) : ","Adam",null,"Extension : ",null,null,"Kid's Names",""]
[null,"Last Name : ","Steadman",null,"Direct Line : ",null,null,"Hobby",""]
[null,"Salutation : ","Adam",null,"Business Fax : ",null,null,"Sport",""]
[null,"Site Name : ","Orion Vehicles Leasing",null,"Mobile : ",null,null,"Holiday",""]
[null,"Site Address : ","Orion House",null,"Assistant Telephone : ",null,null,"Food",""]
[null,null,"Orion Way",null,"Assistant Extension : ",null,null,"Religion",""]
[null,null,"Kettering",null,"Home Telephone : ",null,null,"Birthday",""]
[null,null,"Northants",null,"Home Fax : ",null,null,"Can make buying decisions","No"]
[null,"Post Code : ","NN15 6PE",null,"Other Telephone : ",null,null,"Spares","No"]
[null,null,null,null,"Other Fax : ",null,null,"Leasing","No"]
[null,"Job Title : ","Office Admininstator",null,null,null,null,"Salvage","No"]
[null,"Department : ","Office",null,"No Mailshots : ","Yes",null,"Fitter","No"]
[null,"Date of Birth : ",null,null,"No Bulk E-mail : ","Yes",null,"Main Agent Contact","No"]
[null,"E-mail : ","adam.s@orionvl.co.uk",null,"No Cold Calls : ","Yes",null,"Bead Buyer","No"]
[null,null,null,null,null,null,null,"User Field 16","No"]
[null,"Employee : ","No",null,"Username : ","USER",null,"User Field 17","No"]
[null,"Project Leader : ","No",null,"HR Ref : ",3021,null,"User Field 18","No"]
[null,"Sub-Contractor : ","Yes",null,"Gender : ","Male",null,"User Field 19","No"]
[null,null,null,null,null,null,null,"User Field 20","No"]
[null,"Skills : ",{"$f":"[1]!AG_DTRT(\"0,CRM Skills List,1\",$C$3)","v":""},null,"Work out of Hours : ","Yes",null,"User Field 21","No"]
[null,null,null,null,"Call Allocate To : ","Yes",null,"User Field 22","No"]
[null,null,null,null,null,null,null,"User Field 23","No"]
[null,null,null,null,null,null,null,"User Field 24","No"]
[null,null,null,null,null,null,null,"User Field 25","No"]
[null,null,null,null,null,null,null,"User Field 26","No"]
[null,null,null,null,null,null,null,"User Field 27","No"]
[null,null,null,null,null,null,null,"User Field 28","No"]
[null,null,null,null,null,null,null,"Attribute 1",""]
[null,null,null,null,null,null,null,"Attribute 2",""]
[null,null,null,null,null,null,null,"Attribute 3",""]
[null,null,null,null,null,null,null,"Attribute 4",""]
[null,null,null,null,null,null,null,"Attribute 5",""]
[null,null,null,null,null,null,null,"Attribute 6",""]

{"sheet":"CRMEEExport","index":12,"n_rows":2,"n_cols":71,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Title","First Name(s)","Last Name","Salutation","Site Name","Site Address","Line 2","Line 3","Line 4","Post Code","Job Title","Department","Date of Birth","E-mail","Employee","Project Leader","Sub-Contractor","Business Telephone","Extension","Direct Line","Business Fax","Mobile","Assistant Telephone","Assistant Extension","Home Telephone","Home Fax","Other Telephone","Other Fax","No Mailshots","No Bulk E-mail","No Cold Calls","Username","HR Ref","Gender","Work out of Hours","Call Allocate To","Skills",{"$f":"AG_DTRT(\"0,CRM EE UDFs Export,1\",CRMEE!C3,CRMEE!C4,CRMEE!C4)","v":"Partner's Name"},"Kid's Names","Hobby","Sport","Holiday","Food","Religion","Birthday","Can make buying decisions","Spares","Leasing","Salvage","Fitter","Main Agent Contact","Bead Buyer","User Field 16","User Field 17","User Field 18","User Field 19","User Field 20","User Field 21","User Field 22","User Field 23","User Field 24","User Field 25","User Field 26","User Field 27","User Field 28","Attribute 1","Attribute 2","Attribute 3","Attribute 4","Attribute 5","Attribute 6"]
[{"$f":"[1]!AG_DTLK(\"0,3,PEGASUS,SP6,F={P}1,K=CoID,F={P}2,K=/SP6/EMA,E=0,O=/SP6/TIT,C={P}3,E=0,O=/SP6/FIR,C={P}4,E=0,O=/SP6/LAS1,C={P}5,E=0,O=/SP6/SAL,C={P}6,E=0,O=/SP6/n3,C={P}7,E=0,O=/SP6/n14,C={P}8,E=0,O=/SP6/DOB,C={P}9,E=0,O=/SP6/EMA,C={P}10,E=21,O=/SP6/LEM,C={P}11,E=21,O\",\"=/SP6/LSU,C={P}12,E=21,O=/SP6/LPR,C={P}13,E=0,O=/SP6/SP5*1/CN1,C={P}14,E=0,O=/SP6/SP5*1/ADD,C={P}15,E=0,O=/SP6/SP5*1/ADD1,C={P}16,E=0,O=/SP6/SP5*1/ADD2,C={P}17,E=0,O=/SP6/SP5*1/ADD3,C={P}18,E=0,O=/SP6/SP5*1/POS,\",CRMEEExport!A2,CRMEE!$C$3,CRMEE!$C$4,B$2,C$2,D$2,K$2,L$2,M$2,N$2,O$2,Q$2,P$2,E$2,F$2,G$2,H$2,I$2,J$2)","v":"Mr"},"Adam","Steadman","Adam","Orion Vehicles Leasing","Orion House","Orion Way","Kettering","Northants","NN15 6PE","Office Admininstator","Office",null,"adam.s@orionvl.co.uk","No","No","Yes",{"$f":"[1]!AG_DTLK(\"0,3,PEGASUS,SP6,F={P}1,K=CoID,F={P}2,K=/SP6/EMA,E=0,O=/SP6/PHO,C={P}3,E=0,O=/SP6/PHO1,C={P}4,E=0,O=/SP6/FAX,C={P}5,E=0,O=/SP6/MOB,C={P}6,E=0,O=/SP6/PHO2,C={P}7,E=0,O=/SP6/PHO3,C={P}8,E=0,O=/SP6/PHO4,C={P}9,E=0,O=/SP6/PHO5,C={P}10,E=0,O=/SP6/PHO6,C={P}11,E\",\"=21,O=/SP6/LNO,C={P}12,E=21,O=/SP6/LNO1,C={P}13,E=21,O=/SP6/LNO2,C={P}14,E=0,O=/SP6/USE,C={P}15,E=0,O=/SP6/f1,C={P}16,E=0,O=/SP6/GEN,C={P}17,E=21,O=/SP6/OUT,C={P}18,E=21,O=/SP6/CAL,\",CRMEEExport!R2,CRMEE!$C$3,CRMEE!$C$4,T$2,U$2,V$2,W$2,Y$2,Z$2,AA$2,AB$2,AC$2,AD$2,AE$2,AF$2,AG$2,AH$2,AI$2,AJ$2)","v":""},null,null,null,null,null,null,null,null,null,null,"Yes","Yes","Yes","USER",3021,"Male","Yes","Yes",{"$f":"AG_DTRT(\"0,CRM Skills List Export,1\",CRMEE!$C$3,CRMEE!$C$4,CRMEE!$C$4)","v":""},"","","","","","","","","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","","","","","",""]

{"sheet":"CRMContact","index":13,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,7,3,8]]}
[]
[]
[null,"Company ID: ","Z",null,null,"Inactive flag : ",{"$f":"[1]!AG_DTLK(\"0,2,PEGASUS,SP6,F={P}1,K=CoID,F={P}2,K=/SP6/EMA,E=21,O=/SP6/LIN,\",CRMContact!G3,$C3,$C$4)","v":"No"},{"$f":"IF(G3=\"Y\",\"Inactive Record\",\"Active Contact Record\")","v":"Active Contact Record"}]
[null,"CRM Contact Ref (E-mail) : ","bob.andrews@andrewsofolney.net"]
[]
[]
[null,"Title : ",{"$f":"[1]!AG_DTLK(\"0,3,PEGASUS,SP6,F={P}1,K=CoID,F={P}2,K=/SP6/EMA,E=0,O=/SP6/TIT,C={P}3,E=0,O=/SP6/FIR,C={P}4,E=0,O=/SP6/LAS1,C={P}5,E=0,O=/SP6/SAL,C={P}6,E=0,O=/SP6/n3,C={P}7,E=0,O=/SP6/n14,C={P}8,E=0,O=/SP6/DOB,C={P}9,E=0,O=/SP6/EMA,C={P}10,E=0,O=/SP6/SP5*1/CN1,C={P}11,E\",\"=0,O=/SP6/SP5*1/ADD,C={P}12,E=0,O=/SP6/SP5*1/ADD1,C={P}13,E=0,O=/SP6/SP5*1/ADD2,C={P}14,E=0,O=/SP6/SP5*1/ADD3,C={P}15,E=0,O=/SP6/SP5*1/POS,C={P}16,E=21,O=/SP6/ZC*1/7,\",CRMContact!C7,C$3,C$4,C$8,C$9,C$10,C$18,C$19,C$20,C$21,C$11,C$12,C$13,C$14,C$15,C$16,C$23)","v":""},null,"Business Telephone : ",{"$f":"[1]!AG_DTLK(\"0,3,PEGASUS,SP6,F={P}1,K=CoID,F={P}2,K=/SP6/EMA,E=0,O=/SP6/PHO,C={P}3,E=0,O=/SP6/PHO1,C={P}4,E=0,O=/SP6/FAX,C={P}5,E=0,O=/SP6/MOB,C={P}6,E=0,O=/SP6/PHO2,C={P}7,E=0,O=/SP6/PHO3,C={P}8,E=0,O=/SP6/PHO4,C={P}9,E=0,O=/SP6/PHO5,C={P}10,E=0,O=/SP6/PHO6,C={P}11,E\",\"=21,O=/SP6/LNO,C={P}12,E=21,O=/SP6/LNO1,C={P}13,E=21,O=/SP6/LNO2,\",CRMContact!F7,$C$3,$C$4,F$9,F$10,F$11,F$12,F$14,F$15,F$16,F$17,F$19,F$20,F$21)","v":"01234 599595"},null,{"$f":"[1]!AG_DTRT(\"0,CRM EE UDFs,1\",$C$3,$C$4,$C$4)","v":"Partner's Name"},"",""]
[null,"First Name(s) : ","Robert",null,"Extension : ",null,null,"Kid's Names",""]
[null,"Last Name : ","Andrews",null,"Direct Line : ",null,null,"Hobby",""]
[null,"Salutation : ","Bob",null,"Business Fax : ",null,null,"Sport",""]
[null,"Site Name : ","Andrews of Olney Limited",null,"Mobile : ",null,null,"Holiday",""]
[null,"Site Address : ","180-184 Spring Lane",null,"Assistant Telephone : ",null,null,"Food",""]
[null,null,"Olney",null,"Assistant Extension : ",null,null,"Religion",""]
[null,null,"Bucks",null,"Home Telephone : ",null,null,"User Field 8",""]
[null,null,"UK",null,"Home Fax : ",null,null,"Can make buying decisions","No"]
[null,"Post Code : ","MK46 5AD",null,"Other Telephone : ",null,null,"Spares","No"]
[null,null,null,null,"Other Fax : ",null,null,"Leasing","No"]
[null,"Job Title : ",null,null,null,null,null,"Salvage","No"]
[null,"Department : ",null,null,"No Mailshots : ","Yes",null,"Fitter","No"]
[null,"Date of Birth : ",null,null,"No Bulk E-mail : ","Yes",null,"Main Agent Contact","No"]
[null,"E-mail : ","bob.andrews@andrewsofolney.net",null,"No Cold Calls : ","Yes",null,"Bead Buyer","No"]
[null,null,null,null,null,null,null,"User Field 16","No"]
[null,"Contact Type : ","A/C Contact",null,null,null,null,"User Field 17","No"]
[null,null,null,null,null,null,null,"User Field 18","No"]
[null,null,null,null,null,null,null,"User Field 19","No"]
[null,null,null,null,null,null,null,"User Field 20","No"]
[null,null,null,null,null,null,null,"User Field 21","No"]
[null,null,null,null,null,null,null,"User Field 22","No"]
[null,null,null,null,null,null,null,"User Field 23","No"]
[null,null,null,null,null,null,null,"User Field 24","No"]
[null,null,null,null,null,null,null,"User Field 25","No"]
[null,null,null,null,null,null,null,"User Field 26","No"]
[null,null,null,null,null,null,null,"User Field 27","No"]
[null,null,null,null,null,null,null,"User Field 28","No"]
[null,null,null,null,null,null,null,"Attribute 1",""]
[null,null,null,null,null,null,null,"Attribute 2",""]
[null,null,null,null,null,null,null,"Attribute 3",""]
[null,null,null,null,null,null,null,"Attribute 4",""]
[null,null,null,null,null,null,null,"Attribute 5",""]
[null,null,null,null,null,null,null,"Attribute 6",""]

{"sheet":"CRMCActions","index":14,"n_rows":14,"n_cols":31,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Activities",null,null,null,null,null,null,null,null,null,null,null,"Opportunities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quotes"]
[]
[null,{"$f":"[1]!AG_DTRT(\"0,CRMCActionsActivities,1\",CRMContact!$C$3,CRMContact!$C4,CRMContact!$C4)","v":"Activity ID"},"Description","Subject","Location","Notes","Start Date","Start Time","Duration","Priority","Call Status",null,null,{"$f":"[1]!AG_DTRT(\"0,CRMCActionsOpportunities,1\",CRMContact!$C$3,CRMEE!$C4,CRMEE!$C4)","v":"Opportunity Code"},"Description","Description","Sale Stage","Main Competitor","Sale Type","Opportunity Notes","Forecast Closure","Expected Ship Date","Last Chase Date","Next Chase Date","Result","Actual Closure","Est. Value","Maintenance",null,null,{"$f":"[1]!AG_DTRT(\"0,CRMCActionsQuotes,1\",CRMContact!C3,CRMContact!$C4,CRMContact!$C4)","v":"Document Number"}]
[null,29,"Planned Work Time (Scheduler)","Planned Work Time (Scheduler)","","Chargeable - Bob wanted to discuss how the Satellite Navigation system works.","2012-12-21","08:00",30,"Medium","Planned",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DOC02106"]
[null,113,"Planned Work Time (Scheduler)","1079 CD Player making 'strange' noise after ejecting disc.","","Site Visit Successful","2013-11-13","08:00",30,"High","Planned"]
[null,158,"Planned Work Time (Scheduler)","1034 Preventative Maintenance","","Site Visit Successful","2014-04-15","07:30",30,"Medium","Planned"]
[null,169,"Planned Work Time (Scheduler)","1081 Dashboard light very dim","","Site Visit Successful","2014-04-17","07:30",30,"High","Planned"]
[null,191,"Planned Work Time (Scheduler)","1035 Preventative Maintenance","","Site Visit Successful","2015-01-05","07:30",30,"Medium","Planned"]
[null,197,"Planned Work Time (Scheduler)","Planned Work Time (Scheduler)","","","2015-08-21","07:30",30,"High","Planned"]
[null,236,"Mileage","Mileage","Site","","2015-08-21","09:00",0,"Medium","Planned"]
[null,263,"Planned Work Time (Scheduler)","1136 Regular Engine Check","","Successful Engine Check","2015-12-07","07:30",30,"High","Planned"]
[null,330,"Planned Work Time (Scheduler)","1197 Tap out minor dents on boot door","","","2016-11-10","07:30",30,"High","Planned"]
[null,351,"Follow-up prospect","OPP000049 Entertainment System fitted in BMW","","Follow up","2016-12-17","13:46",10,"High","Planned"]

{"sheet":"CRMContactExport","index":15,"n_rows":2,"n_cols":63,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Title","First Name(s)","Last Name","Salutation","Site Name","Site Address","Line 2","Line 3","Line 4","Post Code","Job Title","Department","Date of Birth","E-mail","Contact Type","Business Telephone","Extension","Direct Line","Business Fax","Mobile","Assistant Telephone","Assistant Extension","Home Telephone","Home Fax","Other Telephone","Other Fax","No Mailshots","No Bulk E-mail","No Cold Calls",{"$f":"AG_DTRT(\"0,CRM Contact UDFs Export,1\",CRMContact!$C$3,CRMContact!$C$4,CRMContact!$C$4)","v":"Partner's Name"},"Kid's Names","Hobby","Sport","Holiday","Food","Religion","Birthday","Can make buying decisions","Spares","Leasing","Salvage","Fitter","Main Agent Contact","Bead Buyer","User Field 16","User Field 17","User Field 18","User Field 19","User Field 20","User Field 21","User Field 22","User Field 23","User Field 24","User Field 25","User Field 26","User Field 27","User Field 28","Attribute 1","Attribute 2","Attribute 3","Attribute 4","Attribute 5","Attribute 6"]
[{"$f":"[1]!AG_DTLK(\"0,3,PEGASUS,SP6,F={P}1,K=CoID,F={P}2,K=/SP6/EMA,E=0,O=/SP6/TIT,C={P}3,E=0,O=/SP6/FIR,C={P}4,E=0,O=/SP6/LAS1,C={P}5,E=0,O=/SP6/SAL,C={P}6,E=0,O=/SP6/n3,C={P}7,E=0,O=/SP6/n14,C={P}8,E=0,O=/SP6/DOB,C={P}9,E=0,O=/SP6/EMA,C={P}10,E=0,O=/SP6/SP5*1/CN1,C={P}11,E\",\"=0,O=/SP6/SP5*1/ADD,C={P}12,E=0,O=/SP6/SP5*1/ADD1,C={P}13,E=0,O=/SP6/SP5*1/ADD2,C={P}14,E=0,O=/SP6/SP5*1/ADD3,C={P}15,E=0,O=/SP6/SP5*1/POS,C={P}16,E=21,O=/SP6/ZC*1/7,\",CRMContactExport!A2,CRMContact!$C$3,CRMContact!$C$4,B$2,C$2,D$2,K$2,L$2,M$2,N$2,E$2,F$2,G$2,H$2,I$2,J$2,O$2)","v":""},"Robert","Andrews","Bob","Andrews of Olney Limited","180-184 Spring Lane","Olney","Bucks","UK","MK46 5AD",null,null,null,"bob.andrews@andrewsofolney.net","A/C Contact",{"$f":"[1]!AG_DTLK(\"0,3,PEGASUS,SP6,F={P}1,K=CoID,F={P}2,K=/SP6/EMA,E=0,O=/SP6/PHO,C={P}3,E=0,O=/SP6/PHO1,C={P}4,E=0,O=/SP6/FAX,C={P}5,E=0,O=/SP6/MOB,C={P}6,E=0,O=/SP6/PHO2,C={P}7,E=0,O=/SP6/PHO3,C={P}8,E=0,O=/SP6/PHO4,C={P}9,E=0,O=/SP6/PHO5,C={P}10,E=0,O=/SP6/PHO6,C={P}11,E\",\"=21,O=/SP6/LNO,C={P}12,E=21,O=/SP6/LNO1,C={P}13,E=21,O=/SP6/LNO2,\",CRMContactExport!P2,CRMContact!$C$3,CRMContact!$C$4,R$2,S$2,T$2,U$2,W$2,X$2,Y$2,Z$2,AA$2,AB$2,AC$2)","v":"01234 599595"},null,null,null,null,null,null,null,null,null,null,"Yes","Yes","Yes","","","","","","","","","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","","","","","",""]

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

{"sheet":"Ls_AgXLB_WorkbookFile","index":17,"n_rows":48,"n_cols":3,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
[">>List of Employee",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-03 11:29:26\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=WN\r\n@filterFrom_CoID:Str='Payroll'!$D$3{P}1\r\n@outputField_/WN/1:Str=\r\n@outputField_/WN/3:Str=\r\n@outputField_/WN/2:Str=\r\n@outputField_/WN/12:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=1\r\n@formatWidth:Int=1\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=List of Employee\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>List of Sales Contacts",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-03 10:51:54\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=ZCS\r\n@filterFrom_CoID:Str='Sales Contact'!$C$2{P}1\r\n@filterFrom_/ZCS/1:Str=S\r\n@filterTo_/ZCS/1:Str=S\r\n@filterFrom_/ZCS/5:Str=<>!\r\n@outputField_/ZCS/5:Str=\r\n@outputField_/ZCS/6:Str=\r\n@outputField_/ZCS/2:Str=\r\n@outputField_/ZCS/8:Str=\r\n@outputField_Date&Time{Fmt}=8,0{DefVal}={Formula}={/ZCS/5}&{/ZCS/6}&{/ZCS/2}&{/ZCS/24}&{/ZCS/25}:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=1\r\n@formatWidth:Int=1\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=List of Sales Contacts\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>Sales Contact Details",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-14 16:20:20\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=ZCS\r\n@filterFrom_CoID:Str='Sales Contact'!$C$2{P}1\r\n@filterFrom_/ZCS/1:Str=S\r\n@filterTo_/ZCS/1:Str=S\r\n@filterFrom_ID{Fmt}=8,1{DefVal}={Formula}={/ZCS/5}&{/ZCS/6}&{/ZCS/2}&{/ZCS/24}&{/ZCS/25}:Str='Sales Contact'!$C$3{P}2\r\n@filterTo_ID{Fmt}=8,1{DefVal}={Formula}={/ZCS/5}&{/ZCS/6}&{/ZCS/2}&{/ZCS/24}&{/ZCS/25}:Str='Sales Contact'!$C$3{P}3\r\n@outputField_Ledger{Fmt}=8,0{DefVal}={Formula}=\"Sales\":Str=\r\n@outputField_/ZCS/2:Str=\r\n@outputField_/ZCS/3:Str=\r\n@outputField_/ZCS/4:Str=\r\n@outputField_/ZCS/5:Str=\r\n@outputField_/ZCS/6:Str=\r\n@outputField_/ZCS/7{ExtractType}21:Str=\r\n@outputField_/ZCS/8:Str=\r\n@outputField_/ZCS/10:Str=\r\n@outputField_/ZCS/12:Str=\r\n@outputField_/ZCS/14:Str=\r\n@outputField_/ZCS/16:Str=\r\n@outputField_/ZCS/17:Str=\r\n@outputField_/ZCS/SCT*1/2:Str=\r\n@outputField_/ZCS/18:Str=\r\n@outputField_/ZCS/SCT*2/2:Str=\r\n@outputField_/ZCS/19:Str=\r\n@outputField_/ZCS/SCT*3/2:Str=\r\n@outputField_/ZCS/20:Str=\r\n@outputField_/ZCS/SCT*4/2:Str=\r\n@outputField_/ZCS/21:Str=\r\n@outputField_/ZCS/SCT*5/2:Str=\r\n@outputField_/ZCS/22:Str=\r\n@outputField_/ZCS/SCT*6/2:Str=\r\n@outputField_/ZCS/24:Str=\r\n@outputField_/ZCS/25:Str=\r\n@outputField_/ZCS/27:Str=\r\n@outputField_/ZCS/28:Str=\r\n@outputField_/ZCS/30:Str=\r\n@outputField_ID{Fmt}=8,1{DefVal}={Formula}={/ZCS/5}&{/ZCS/6}&{/ZCS/2}&{/ZCS/24}&{/ZCS/25}:Str=\r\n@formatType:Lng=2\r\n@formatNumber:Int=0\r\n@formatPattern:Int=0\r\n@formatFont:Int=0\r\n@formatWidth:Int=0\r\n@formatAlignment:Int=0\r\n@formatBorder:Int=0\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=Sales Contact Details\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=S\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>Purchase Contact Details",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-14 16:20:53\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=ZCP\r\n@filterFrom_CoID:Str='Purchase Contact'!$C$2{P}1\r\n@filterFrom_/ZCP/1:Str=P\r\n@filterTo_/ZCP/1:Str=P\r\n@filterFrom_ID{Fmt}=8,1{DefVal}={Formula}={ZCS\\Forename}&{ZCS\\Surname}&{ZCS\\Account}&{ZCS\\Creation Date}&{ZCS\\Creation Time}:Str='Purchase Contact'!$C$3{P}2\r\n@filterTo_ID{Fmt}=8,1{DefVal}={Formula}={ZCS\\Forename}&{ZCS\\Surname}&{ZCS\\Account}&{ZCS\\Creation Date}&{ZCS\\Creation Time}:Str='Purchase Contact'!$C$3{P}3\r\n@filterFrom_/ZCP/5:Str=<>!\r\n@outputField_Ledger{Fmt}=8,0{DefVal}={Formula}=\"Purchase\":Str=\r\n@outputField_/ZCP/2:Str=\r\n@outputField_/ZCP/3:Str=\r\n@outputField_/ZCP/4:Str=\r\n@outputField_/ZCP/5:Str=\r\n@outputField_/ZCP/6:Str=\r\n@outputField_/ZCP/7{ExtractType}21:Str=\r\n@outputField_/ZCP/8:Str=\r\n@outputField_/ZCP/10:Str=\r\n@outputField_/ZCP/12:Str=\r\n@outputField_/ZCP/14:Str=\r\n@outputField_/ZCP/16:Str=\r\n@outputField_/ZCP/17:Str=\r\n@outputField_/ZCP/PCT*1/2:Str=\r\n@outputField_/ZCP/18:Str=\r\n@outputField_/ZCP/PCT*2/2:Str=\r\n@outputField_/ZCP/19:Str=\r\n@outputField_/ZCP/PCT*3/2:Str=\r\n@outputField_/ZCP/20:Str=\r\n@outputField_/ZCP/PCT*4/2:Str=\r\n@outputField_/ZCP/21:Str=\r\n@outputField_/ZCP/PCT*5/2:Str=\r\n@outputField_/ZCP/22:Str=\r\n@outputField_/ZCP/PCT*6/2:Str=\r\n@outputField_/ZCP/24:Str=\r\n@outputField_/ZCP/25:Str=\r\n@outputField_/ZCP/27:Str=\r\n@outputField_/ZCP/28:Str=\r\n@outputField_/ZCP/30:Str=\r\n@outputField_ID{Fmt}=8,1{DefVal}={Formula}={/ZCP/5}&{/ZCP/6}&{/ZCP/2}&{/ZCP/24}&{/ZCP/25}:Str=\r\n@formatType:Lng=2\r\n@formatNumber:Int=0\r\n@formatPattern:Int=0\r\n@formatFont:Int=0\r\n@formatWidth:Int=0\r\n@formatAlignment:Int=0\r\n@formatBorder:Int=0\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=Purchase Contact Details\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=S\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>List of Purchase Contacts",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-03 10:53:25\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=ZCP\r\n@filterFrom_CoID:Str='Purchase Contact'!$C$2{P}1\r\n@filterFrom_/ZCP/5:Str=<>!\r\n@filterFrom_/ZCP/1:Str=P\r\n@filterTo_/ZCP/1:Str=P\r\n@outputField_/ZCP/5:Str=\r\n@outputField_/ZCP/6:Str=\r\n@outputField_/ZCP/2:Str=\r\n@outputField_/ZCP/8:Str=\r\n@outputField_ID{Fmt}=8,0{DefVal}={Formula}={/ZCP/5}&{/ZCP/6}&{/ZCP/2}&{/ZCP/24}&{/ZCP/25}:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=1\r\n@formatWidth:Int=1\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=List of Purchase Contacts\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>List of People",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-02 11:40:08\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=SP\r\n@filterFrom_CoID:Str='People Profiles'!$C$2{P}1\r\n@outputField_/SP/72:Str=\r\n@outputField_/SP/77:Str=\r\n@outputField_/SP/70:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=1\r\n@formatWidth:Int=1\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=List of People\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>Notes",">'",">'[LASATA SETUP FILE]\r\nDate=2017-08-02 12:08:51\r\nFileType=Agora XLB ReferenceFileLink\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=ZN\r\n@filterFrom_CoID:Str='People Profiles'!$C$2{P}1\r\n@outputField_/ZN/1{ExtractType}21:Str=\r\n@outputField_/ZN/2{ExtractType}0:Str=\r\n@outputField_/ZN/3{ExtractType}0:Str=\r\n@outputField_/ZN/4{ExtractType}0:Str=\r\n@outputField_/ZN/5{ExtractType}0:Str=\r\n@outputField_/ZN/6{ExtractType}0:Str=\r\n@outputField_/ZN/7{ExtractType}0:Str=\r\n@outputField_/ZN/8{ExtractType}0:Str=\r\n@outputField_/ZN/9{ExtractType}0:Str=\r\n@outputField_/ZN/11{ExtractType}0:Str=\r\n@outputField_/ZN/12{ExtractType}0:Str=\r\n@outputField_/ZN/13{ExtractType}0:Str=\r\n@outputField_/ZN/14{ExtractType}21:Str=\r\n@outputField_/ZN/15{ExtractType}0:Str=\r\n@outputField_/ZN/16{ExtractType}0:Str=\r\n@outputField_/ZN/17{ExtractType}0:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=1\r\n@formatWidth:Int=1\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=Notes\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=1\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=1\r\n"]
[">>Sales Notes",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-14 16:08:32\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=Z2\r\n@filterFrom_CoID:Str='People Profiles'!$C$2{P}1\r\n@filterFrom_/Z2/11:Str='People Profiles'!$C$3{P}2\r\n@filterTo_/Z2/11:Str='People Profiles'!$C$3{P}3\r\n@outputField_/Z2/2:Str=\r\n@outputField_/Z2/5:Str=\r\n@outputField_/Z2/16:Str=\r\n@outputField_/Z2/13:Str=\r\n@outputField_/Z2/12:Str=\r\n@outputField_/Z2/17:Str=\r\n@outputField_Comments{Fmt}=8,0{DefVal}={Formula}={/Z2/10}:Str=\r\n@outputField_FilterStatement{Fmt}=201,0{DefVal}={Formula}={/Z2/17}=\"Sales Statement\":Str=\r\n@outputField_FilterLetter1{Fmt}=201,0{DefVal}={Formula}={/Z2/17}=\"First Debtor Letter\":Str=\r\n@outputField_FilterLetter2{Fmt}=201,0{DefVal}={Formula}={/Z2/17}=\"Second Debtor Letter\":Str=\r\n@outputField_FilterLetter3{Fmt}=201,0{DefVal}={Formula}={/Z2/17}=\"Third Debtor Letter\":Str=\r\n@outputField_FilterCor1{Fmt}=201,0{DefVal}={Formula}={/Z2/17}=\"First Correspondence\":Str=\r\n@outputField_FilterCor2{Fmt}=201,0{DefVal}={Formula}={/Z2/17}=\"Second Correspondence\":Str=\r\n@outputField_FilterCor3{Fmt}=201,0{DefVal}={Formula}={/Z2/17}=\"Third Correspondence\":Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=0\r\n@formatWidth:Int=0\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=Sales Notes\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=1\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>Detail Report 1",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-03 11:12:43\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=WEP\r\n@filterFrom_CoID:Str='Payroll'!$D$3{P}1\r\n@filterFrom_/WEP/1:Str='Payroll'!$D$4{P}2\r\n@filterTo_/WEP/1:Str='Payroll'!$D$4{P}3\r\n@outputField_/WEP/WPS/2{ExtractType}0:Str=\r\n@outputField_/WEP/11{ExtractType}0:Str=\r\n@outputField_/WEP/12{ExtractType}0:Str=\r\n@outputField_/WEP/13{ExtractType}0:Str=\r\n@outputField_/WEP/20{ExtractType}0:Str=\r\n@outputField_/WEP/21{ExtractType}0:Str=\r\n@outputField_/WEP/24{ExtractType}0:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=1\r\n@formatWidth:Int=1\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=Detail Report 1\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=1\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=1\r\n"]
[">>Employee Pension Information",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-03 11:20:30\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=WEP\r\n@filterFrom_CoID:Str='Payroll'!$D$3{P}1\r\n@filterFrom_/WEP/1:Str='Payroll'!$D$4{P}2\r\n@filterTo_/WEP/1:Str='Payroll'!$D$4{P}3\r\n@outputField_/WEP/WPS/2:Str=\r\n@outputField_s{Fmt}=8,0{DefVal}={Formula}=\"\":Str=\r\n@outputField_/WEP/11:Str=\r\n@outputField_w{Fmt}=8,0{DefVal}={Formula}=\"\":Str=\r\n@outputField_/WEP/12:Str=\r\n@outputField_q{Fmt}=8,0{DefVal}={Formula}=\"\":Str=\r\n@outputField_/WEP/13:Str=\r\n@outputField_a{Fmt}=8,0{DefVal}={Formula}=\"\":Str=\r\n@outputField_/WEP/20:Str=\r\n@outputField_j{Fmt}=8,0{DefVal}={Formula}=\"\":Str=\r\n@outputField_/WEP/21:Str=\r\n@outputField_g{Fmt}=8,0{DefVal}={Formula}=\"\":Str=\r\n@outputField_/WEP/24:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=0\r\n@formatFont:Int=0\r\n@formatWidth:Int=0\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=Employee Pension Information\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>Employee Attachment Orders",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-03 11:27:06\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=WAO\r\n@filterFrom_CoID:Str='Payroll'!$D$3{P}1\r\n@filterFrom_/WAO/1:Str='Payroll'!$D$4{P}2\r\n@filterTo_/WAO/1:Str='Payroll'!$D$4{P}3\r\n@outputField_/WAO/3{ExtractType}21:Str=\r\n@outputField_1{Fmt}=8,0{DefVal}={Formula}=\"\":Str=\r\n@outputField_/WAO/10:Str=\r\n@outputField_2{Fmt}=8,0{DefVal}={Formula}=\"\":Str=\r\n@outputField_/WAO/9:Str=\r\n@outputField_3{Fmt}=8,0{DefVal}={Formula}=\"\":Str=\r\n@outputField_/WAO/31:Str=\r\n@outputField_4{Fmt}=8,0{DefVal}={Formula}=\"\":Str=\r\n@outputField_/WAO/5:Str=\r\n@outputField_5{Fmt}=8,0{DefVal}={Formula}=\"\":Str=\r\n@outputField_/WAO/6:Str=\r\n@outputField_%{Fmt}=8,0{DefVal}={Formula}={/WAO/7}:Str=\r\n@outputField_/WAO/8:Str=\r\n@outputField_7{Fmt}=8,0{DefVal}={Formula}=\"\":Str=\r\n@outputField_/WAO/19:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=1\r\n@formatWidth:Int=1\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=Employee Attachment Orders\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>PayrollPrint",">'axb",">'[LASATA SETUP FILE]\r\nDate=2017-08-03 12:28:23\r\nFileType=Agora XLB MacroBuilder\r\nVersion=0\r\nBuffer=\r\n@settngMacroName:Str=PayrollPrint\r\n@settngMacroButtonCaption:Str=PayrollPrint\r\n@settngMacroShortcutKey:Str=\r\n@recipeStep_PrintWorksheet_80312280299000:Str=P0=[GDPR.xlsm]Payroll,P1=,P2=\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=PayrollPrint\r\n"]
[">>HR Job Data",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-03 15:41:43\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=HJ\r\n@filterFrom_CoID:Str='Payroll'!$D$3{P}1\r\n@filterFrom_/HJ/1:Str='Payroll'!$D$4{P}2\r\n@filterTo_/HJ/1:Str='Payroll'!$D$4{P}3\r\n@outputField_/HJ/3:Str=1\r\n@outputField_/HJ/4:Str=\r\n@outputField_/HJ/HZ/2:Str=\r\n@outputField_/HJ/5:Str=\r\n@outputField_/HJ/12:Str=\r\n@outputField_/HJ/17:Str=\r\n@outputField_Comment{Fmt}=8,0{DefVal}={Formula}={/HJ/16}:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=0\r\n@formatPattern:Int=0\r\n@formatFont:Int=0\r\n@formatWidth:Int=0\r\n@formatAlignment:Int=0\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=HR Job Data\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>HR Salary Data",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-03 15:42:17\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=HL\r\n@filterFrom_CoID:Str='Payroll'!$D$3{P}1\r\n@filterFrom_/HL/1:Str='Payroll'!$D$4{P}2\r\n@filterTo_/HL/1:Str='Payroll'!$D$4{P}3\r\n@outputField_/HL/3:Str=1\r\n@outputField_/HL/6:Str=\r\n@outputField_/HL/4:Str=\r\n@outputField_/HL/5:Str=\r\n@outputField_/HL/8:Str=\r\n@outputField_Comment{Fmt}=8,0{DefVal}={Formula}={/HL/7}:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=1\r\n@formatWidth:Int=1\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=HR Salary Data\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>HR Training Data",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-03 15:42:44\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=HN\r\n@filterFrom_CoID:Str='Payroll'!$D$3{P}1\r\n@filterFrom_/HN/1:Str='Payroll'!$D$4{P}2\r\n@filterTo_/HN/1:Str='Payroll'!$D$4{P}3\r\n@outputField_/HN/4:Str=1\r\n@outputField_/HN/5:Str=\r\n@outputField_/HN/HT/2:Str=\r\n@outputField_/HN/6:Str=\r\n@outputField_/HN/7:Str=\r\n@outputField_/HN/12:Str=\r\n@outputField_Comment{Fmt}=8,0{DefVal}={Formula}={/HN/11}:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=1\r\n@formatWidth:Int=1\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=HR Training Data\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>HR Absence Data",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-03 15:43:03\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=HB\r\n@filterFrom_CoID:Str='Payroll'!$D$3{P}1\r\n@filterFrom_/HB/1:Str='Payroll'!$D$4{P}2\r\n@filterTo_/HB/1:Str='Payroll'!$D$4{P}3\r\n@outputField_/HB/4:Str=1\r\n@outputField_/HB/5:Str=\r\n@outputField_/HB/3{ExtractType}21:Str=\r\n@outputField_/HB/6:Str=\r\n@outputField_/HB/HG/2:Str=\r\n@outputField_Comment{Fmt}=8,0{DefVal}={Formula}={/HB/12}:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=1\r\n@formatWidth:Int=1\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=HR Absence Data\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>HR Disciplinary Data",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-03 15:43:20\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=HI\r\n@filterFrom_CoID:Str='Payroll'!$D$3{P}1\r\n@filterFrom_/HI/1:Str='Payroll'!$D$4{P}2\r\n@filterTo_/HI/1:Str='Payroll'!$D$4{P}3\r\n@outputField_/HI/4:Str=1\r\n@outputField_/HI/16:Str=\r\n@outputField_/HI/5:Str=\r\n@outputField_Comment{Fmt}=8,0{DefVal}={Formula}={/HI/7}:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=1\r\n@formatWidth:Int=1\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=HR Disciplinary Data\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>GoToHRRefresh",">'axb",">'[LASATA SETUP FILE]\r\nDate=2017-08-03 12:57:26\r\nFileType=Agora XLB MacroBuilder\r\nVersion=0\r\nBuffer=\r\n@settngMacroName:Str=GoToHRRefresh\r\n@settngMacroButtonCaption:Str=GoToHRRefresh\r\n@settngMacroShortcutKey:Str=\r\n@recipeStep_ActivateWorksheet_80312570967000:Str=P0=[GDPR.xlsm]HR,P1=,P2=\r\n@recipeStep_RecalculateWorksheet_80312571447000:Str=P0=[GDPR.xlsm]HR,P1=,P2=\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=GoToHRRefresh\r\n"]
[">>PrintHR",">'axb",">'[LASATA SETUP FILE]\r\nDate=2017-08-03 15:54:48\r\nFileType=Agora XLB MacroBuilder\r\nVersion=0\r\nBuffer=\r\n@settngMacroName:Str=PrintHR\r\n@settngMacroButtonCaption:Str=PrintHR\r\n@settngMacroShortcutKey:Str=\r\n@recipeStep_PrintWorksheet_80315543136000:Str=P0=[GDPR.xlsm]HR,P1=,P2=\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=PrintHR\r\n"]
[">>SalesContactPrint",">'axb",">'[LASATA SETUP FILE]\r\nDate=2017-08-03 16:27:09\r\nFileType=Agora XLB MacroBuilder\r\nVersion=0\r\nBuffer=\r\n@settngMacroName:Str=SalesContactPrint\r\n@settngMacroButtonCaption:Str=SalesContactPrint\r\n@settngMacroShortcutKey:Str=\r\n@recipeStep_PrintWorksheet_80316270165000:Str=P0=[GDPR.xlsm]Sales Contact,P1=,P2=\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=SalesContactPrint\r\n"]
[">>PurchaseContactPrint",">'axb",">'[LASATA SETUP FILE]\r\nDate=2017-08-03 16:27:59\r\nFileType=Agora XLB MacroBuilder\r\nVersion=0\r\nBuffer=\r\n@settngMacroName:Str=PurchaseContactPrint\r\n@settngMacroButtonCaption:Str=PurchaseContactPrint\r\n@settngMacroShortcutKey:Str=\r\n@recipeStep_PrintWorksheet_80316275392000:Str=P0=[GDPR.xlsm]Purchase Contact,P1=,P2=\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=PurchaseContactPrint\r\n"]
[">>PeopleProfilePrint",">'axb",">'[LASATA SETUP FILE]\r\nDate=2017-08-03 16:28:49\r\nFileType=Agora XLB MacroBuilder\r\nVersion=0\r\nBuffer=\r\n@settngMacroName:Str=PeopleProfilePrint\r\n@settngMacroButtonCaption:Str=PeopleProfilePrint\r\n@settngMacroShortcutKey:Str=\r\n@recipeStep_PrintWorksheet_80316284395000:Str=P0=[GDPR.xlsm]People Profiles,P1=,P2=\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=PeopleProfilePrint\r\n"]
[">>Purchase Notes",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-14 16:15:01\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=Z1\r\n@filterFrom_CoID:Str='People Profiles'!$C$2{P}1\r\n@filterFrom_/Z1/11:Str='People Profiles'!$C$3{P}2\r\n@filterTo_/Z1/11:Str='People Profiles'!$C$3{P}3\r\n@outputField_/Z1/2{ExtractType}0:Str=\r\n@outputField_/Z1/5{ExtractType}0:Str=\r\n@outputField_/Z1/16{ExtractType}0:Str=\r\n@outputField_/Z1/13{ExtractType}0:Str=\r\n@outputField_/Z1/12{ExtractType}0:Str=\r\n@outputField_/Z1/17{ExtractType}0:Str=\r\n@outputField_Comments{Fmt}=8,0{DefVal}={Formula}={/Z1/10}:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=0\r\n@formatWidth:Int=0\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=Purchase Notes\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=1\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>List of CRM contacts",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-17 15:00:39\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=SP6\r\n@filterFrom_CoID:Str='CRMContact'!$C$3{P}1\r\n@filterFrom_/SP6/EMA:Str=<>!\r\n@outputField_/SP6/FIR:Str=\r\n@outputField_/SP6/LAS1:Str=\r\n@outputField_/SP6/EMA:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=1\r\n@formatWidth:Int=1\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=List of CRM contacts\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>Sales Contact Details Export",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-15 10:29:01\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=ZCS\r\n@filterFrom_CoID:Str='Sales Contact'!$C$2{P}1\r\n@filterFrom_/ZCS/1:Str=S\r\n@filterTo_/ZCS/1:Str=S\r\n@filterFrom_ID{Fmt}=8,1{DefVal}={Formula}={/ZCS/5}&{/ZCS/6}&{/ZCS/2}&{/ZCS/24}&{/ZCS/25}:Str='Sales Contact'!$C$3{P}2\r\n@filterTo_ID{Fmt}=8,1{DefVal}={Formula}={/ZCS/5}&{/ZCS/6}&{/ZCS/2}&{/ZCS/24}&{/ZCS/25}:Str='Sales Contact'!$C$3{P}3\r\n@outputField_Ledger{Fmt}=8,0{DefVal}={Formula}=\"Sales\":Str=\r\n@outputField_/ZCS/2:Str=\r\n@outputField_/ZCS/3:Str=\r\n@outputField_/ZCS/4:Str=\r\n@outputField_/ZCS/5:Str=\r\n@outputField_/ZCS/6:Str=\r\n@outputField_/ZCS/7{ExtractType}21:Str=\r\n@outputField_/ZCS/8:Str=\r\n@outputField_/ZCS/10:Str=\r\n@outputField_/ZCS/12:Str=\r\n@outputField_/ZCS/14:Str=\r\n@outputField_/ZCS/16:Str=\r\n@outputField_/ZCS/17:Str=\r\n@outputField_/ZCS/SCT*1/2:Str=\r\n@outputField_/ZCS/18:Str=\r\n@outputField_/ZCS/SCT*2/2:Str=\r\n@outputField_/ZCS/19:Str=\r\n@outputField_/ZCS/SCT*3/2:Str=\r\n@outputField_/ZCS/20:Str=\r\n@outputField_/ZCS/SCT*4/2:Str=\r\n@outputField_/ZCS/21:Str=\r\n@outputField_/ZCS/SCT*5/2:Str=\r\n@outputField_/ZCS/22:Str=\r\n@outputField_/ZCS/SCT*6/2:Str=\r\n@outputField_/ZCS/24:Str=\r\n@outputField_/ZCS/25:Str=\r\n@outputField_/ZCS/27:Str=\r\n@outputField_/ZCS/28:Str=\r\n@outputField_/ZCS/30:Str=\r\n@outputField_ID{Fmt}=8,1{DefVal}={Formula}={/ZCS/5}&{/ZCS/6}&{/ZCS/2}&{/ZCS/24}&{/ZCS/25}:Str=\r\n@formatType:Lng=2\r\n@formatNumber:Int=0\r\n@formatPattern:Int=0\r\n@formatFont:Int=0\r\n@formatWidth:Int=0\r\n@formatAlignment:Int=0\r\n@formatBorder:Int=0\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=Sales Contact Details Export\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>XRLSalesContactExport",">'axb",">'[LASATA SETUP FILE]\r\nDate=2017-08-15 10:43:36\r\nFileType=Agora XLB MacroBuilder\r\nVersion=0\r\nBuffer=\r\n@settngMacroName:Str=XRLSalesContactExport\r\n@settngMacroButtonCaption:Str=XRLSalesContactExport\r\n@settngMacroShortcutKey:Str=\r\n@recipeStep_ActivateWorksheet_81510374557000:Str=P0=[GDPR.xlsm]SCExport,P1=,P2=\r\n@recipeStep_RecalculateWorksheet_81510375006000:Str=P0=[GDPR.xlsm]SCExport,P1=,P2=\r\n@recipeStep_RunCustomMacro_81510375282000:Str=P0=Module1.SCExport,P1=,P2=\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=XRLSalesContactExport\r\n"]
[">>Purchase Contact Details Export",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-15 10:49:37\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=ZCP\r\n@filterFrom_CoID:Str='Purchase Contact'!$C$2{P}1\r\n@filterFrom_/ZCP/1:Str=P\r\n@filterTo_/ZCP/1:Str=P\r\n@filterFrom_ID{Fmt}=8,1{DefVal}={Formula}={ZCS\\Forename}&{ZCS\\Surname}&{ZCS\\Account}&{ZCS\\Creation Date}&{ZCS\\Creation Time}:Str='Purchase Contact'!$C$3{P}2\r\n@filterTo_ID{Fmt}=8,1{DefVal}={Formula}={ZCS\\Forename}&{ZCS\\Surname}&{ZCS\\Account}&{ZCS\\Creation Date}&{ZCS\\Creation Time}:Str='Purchase Contact'!$C$3{P}3\r\n@filterFrom_/ZCP/5:Str=<>!\r\n@outputField_Ledger{Fmt}=8,0{DefVal}={Formula}=\"Purchase\":Str=\r\n@outputField_/ZCP/2:Str=\r\n@outputField_/ZCP/3:Str=\r\n@outputField_/ZCP/4:Str=\r\n@outputField_/ZCP/5:Str=\r\n@outputField_/ZCP/6:Str=\r\n@outputField_/ZCP/7{ExtractType}21:Str=\r\n@outputField_/ZCP/8:Str=\r\n@outputField_/ZCP/10:Str=\r\n@outputField_/ZCP/12:Str=\r\n@outputField_/ZCP/14:Str=\r\n@outputField_/ZCP/16:Str=\r\n@outputField_/ZCP/17:Str=\r\n@outputField_/ZCP/PCT*1/2:Str=\r\n@outputField_/ZCP/18:Str=\r\n@outputField_/ZCP/PCT*2/2:Str=\r\n@outputField_/ZCP/19:Str=\r\n@outputField_/ZCP/PCT*3/2:Str=\r\n@outputField_/ZCP/20:Str=\r\n@outputField_/ZCP/PCT*4/2:Str=\r\n@outputField_/ZCP/21:Str=\r\n@outputField_/ZCP/PCT*5/2:Str=\r\n@outputField_/ZCP/22:Str=\r\n@outputField_/ZCP/PCT*6/2:Str=\r\n@outputField_/ZCP/24:Str=\r\n@outputField_/ZCP/25:Str=\r\n@outputField_/ZCP/27:Str=\r\n@outputField_/ZCP/28:Str=\r\n@outputField_/ZCP/30:Str=\r\n@outputField_ID{Fmt}=8,1{DefVal}={Formula}={/ZCP/5}&{/ZCP/6}&{/ZCP/2}&{/ZCP/24}&{/ZCP/25}:Str=\r\n@formatType:Lng=2\r\n@formatNumber:Int=0\r\n@formatPattern:Int=0\r\n@formatFont:Int=0\r\n@formatWidth:Int=0\r\n@formatAlignment:Int=0\r\n@formatBorder:Int=0\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=Purchase Contact Details Export\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>XRLPurchaseContactExport",">'axb",">'[LASATA SETUP FILE]\r\nDate=2017-08-15 10:52:58\r\nFileType=Agora XLB MacroBuilder\r\nVersion=0\r\nBuffer=\r\n@settngMacroName:Str=XRLPurchaseContactExport\r\n@settngMacroButtonCaption:Str=XRLPurchaseContactExport\r\n@settngMacroShortcutKey:Str=\r\n@recipeStep_ActivateWorksheet_81510521657000:Str=P0=[GDPR.xlsm]PCExport,P1=,P2=\r\n@recipeStep_RecalculateWorksheet_81510521866000:Str=P0=[GDPR.xlsm]PCExport,P1=,P2=\r\n@recipeStep_RunCustomMacro_81510522093000:Str=P0=Module1.PCExport,P1=,P2=\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=XRLPurchaseContactExport\r\n"]
[">>Sales Notes Export",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-15 11:10:44\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=Z2\r\n@filterFrom_CoID:Str='People Profiles'!$C$2{P}1\r\n@filterFrom_/Z2/11:Str='People Profiles'!$C$3{P}2\r\n@filterTo_/Z2/11:Str='People Profiles'!$C$3{P}3\r\n@outputField_/Z2/2:Str=\r\n@outputField_/Z2/5:Str=\r\n@outputField_/Z2/16:Str=\r\n@outputField_/Z2/13:Str=\r\n@outputField_/Z2/12:Str=\r\n@outputField_/Z2/17:Str=\r\n@outputField_Comments{Fmt}=8,0{DefVal}={Formula}={/Z2/10}:Str=\r\n@outputField_FilterStatement{Fmt}=201,0{DefVal}={Formula}={/Z2/17}=\"Sales Statement\":Str=\r\n@outputField_FilterLetter1{Fmt}=201,0{DefVal}={Formula}={/Z2/17}=\"First Debtor Letter\":Str=\r\n@outputField_FilterLetter2{Fmt}=201,0{DefVal}={Formula}={/Z2/17}=\"Second Debtor Letter\":Str=\r\n@outputField_FilterLetter3{Fmt}=201,0{DefVal}={Formula}={/Z2/17}=\"Third Debtor Letter\":Str=\r\n@outputField_FilterCor1{Fmt}=201,0{DefVal}={Formula}={/Z2/17}=\"First Correspondence\":Str=\r\n@outputField_FilterCor2{Fmt}=201,0{DefVal}={Formula}={/Z2/17}=\"Second Correspondence\":Str=\r\n@outputField_FilterCor3{Fmt}=201,0{DefVal}={Formula}={/Z2/17}=\"Third Correspondence\":Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=0\r\n@formatWidth:Int=0\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=Sales Notes Export\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>Purchase Notes Export",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-15 11:12:17\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=Z1\r\n@filterFrom_CoID:Str='People Profiles'!$C$2{P}1\r\n@filterFrom_/Z1/11:Str='People Profiles'!$C$3{P}2\r\n@filterTo_/Z1/11:Str='People Profiles'!$C$3{P}3\r\n@outputField_/Z1/2:Str=\r\n@outputField_/Z1/5:Str=\r\n@outputField_/Z1/16:Str=\r\n@outputField_/Z1/13:Str=\r\n@outputField_/Z1/12:Str=\r\n@outputField_/Z1/17:Str=\r\n@outputField_Comments{Fmt}=8,0{DefVal}={Formula}={/Z1/10}:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=0\r\n@formatWidth:Int=0\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=Purchase Notes Export\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>XRLPeopleProfilesExport",">'axb",">'[LASATA SETUP FILE]\r\nDate=2017-08-15 11:15:44\r\nFileType=Agora XLB MacroBuilder\r\nVersion=0\r\nBuffer=\r\n@settngMacroName:Str=XRLPeopleProfilesExport\r\n@settngMacroButtonCaption:Str=XRLPeopleProfilesExport\r\n@settngMacroShortcutKey:Str=\r\n@recipeStep_ActivateWorksheet_81511150652000:Str=P0=[GDPR.xlsm]PPExport,P1=,P2=\r\n@recipeStep_RecalculateWorksheet_81511150992000:Str=P0=[GDPR.xlsm]PPExport,P1=,P2=\r\n@recipeStep_RunCustomMacro_81511151334000:Str=P0=Module1.PPExport,P1=,P2=\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=XRLPeopleProfilesExport\r\n"]
[">>Employee Pension Information Export",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-15 14:36:42\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=WEP\r\n@filterFrom_CoID:Str='Payroll'!$D$3{P}1\r\n@filterFrom_/WEP/1:Str='Payroll'!$D$4{P}2\r\n@filterTo_/WEP/1:Str='Payroll'!$D$4{P}3\r\n@outputField_/WEP/WPS/2:Str=\r\n@outputField_/WEP/11:Str=\r\n@outputField_/WEP/12:Str=\r\n@outputField_/WEP/13:Str=\r\n@outputField_/WEP/20:Str=\r\n@outputField_/WEP/21:Str=\r\n@outputField_/WEP/24:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=0\r\n@formatFont:Int=0\r\n@formatWidth:Int=0\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=Employee Pension Information Export\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=0\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>Employee Attachment Orders Export",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-15 14:37:37\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=WAO\r\n@filterFrom_CoID:Str='Payroll'!$D$3{P}1\r\n@filterFrom_/WAO/1:Str='Payroll'!$D$4{P}2\r\n@filterTo_/WAO/1:Str='Payroll'!$D$4{P}3\r\n@outputField_/WAO/3{ExtractType}21:Str=\r\n@outputField_/WAO/10:Str=\r\n@outputField_/WAO/9:Str=\r\n@outputField_/WAO/31:Str=\r\n@outputField_/WAO/5:Str=\r\n@outputField_/WAO/6:Str=\r\n@outputField_%{Fmt}=8,0{DefVal}={Formula}={/WAO/7}:Str=\r\n@outputField_/WAO/8:Str=\r\n@outputField_/WAO/19:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=1\r\n@formatWidth:Int=1\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=Employee Attachment Orders Export\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=0\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>XRLPayrollHRExport",">'axb",">'[LASATA SETUP FILE]\r\nDate=2017-08-15 14:41:40\r\nFileType=Agora XLB MacroBuilder\r\nVersion=0\r\nBuffer=\r\n@settngMacroName:Str=XRLPayrollHRExport\r\n@settngMacroButtonCaption:Str=XRLPayrollHRExport\r\n@settngMacroShortcutKey:Str=\r\n@recipeStep_ActivateWorksheet_81514405261000:Str=P0=[GDPR.xlsm]PHRExport,P1=,P2=\r\n@recipeStep_RecalculateWorksheet_81514405514000:Str=P0=[GDPR.xlsm]PHRExport,P1=,P2=\r\n@recipeStep_RunCustomMacro_81514405800000:Str=P0=Module1.PHRExport,P1=,P2=\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=XRLPayrollHRExport\r\n"]
[">>List of CRM EEs",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-22 14:52:03\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=SP6\r\n@filterFrom_CoID:Str='CRMEE'!$C$3{P}1\r\n@filterFrom_/SP6/EMA:Str=<>!\r\n@filterFrom_/SP6/EMA#2:Str=<>Info@OrionVehicle.co.uk\r\n@filterFrom_/SP6/EMA#3:Str=<>billing.services@ovl.co.uk\r\n@filterFrom_/SP6/SP5*1/CN:Str=00000002\r\n@filterTo_/SP6/SP5*1/CN:Str=00000002\r\n@outputField_/SP6/FIR:Str=\r\n@outputField_/SP6/LAS1:Str=\r\n@outputField_/SP6/EMA:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=1\r\n@formatWidth:Int=1\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=List of CRM EEs\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=1\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>CRM EE UDFs",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-17 14:44:05\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=SP6\r\n@filterFrom_CoID:Str='CRMEE'!$C$3{P}1\r\n@filterFrom_/SP6/EMA:Str='CRMEE'!$C$4{P}2\r\n@filterTo_/SP6/EMA:Str='CRMEE'!$C$4{P}3\r\n@outputField_/SP6/CUD:Str=\r\n@outputField_/SP6/CUD1:Str=\r\n@outputField_/SP6/CUD2:Str=\r\n@outputField_/SP6/CUD3:Str=\r\n@outputField_/SP6/CUD4:Str=\r\n@outputField_/SP6/CUD5:Str=\r\n@outputField_/SP6/CUD6:Str=\r\n@outputField_/SP6/CUD7:Str=\r\n@outputField_/SP6/LSE{ExtractType}21:Str=\r\n@outputField_/SP6/LSE1{ExtractType}21:Str=\r\n@outputField_/SP6/LSE2{ExtractType}21:Str=\r\n@outputField_/SP6/LSE3{ExtractType}21:Str=\r\n@outputField_/SP6/LSE4{ExtractType}21:Str=\r\n@outputField_/SP6/LSE5{ExtractType}21:Str=\r\n@outputField_/SP6/LSE6{ExtractType}21:Str=\r\n@outputField_/SP6/LSE7{ExtractType}21:Str=\r\n@outputField_/SP6/LSE8{ExtractType}21:Str=\r\n@outputField_/SP6/LSE9{ExtractType}21:Str=\r\n@outputField_/SP6/LKL1{ExtractType}21:Str=\r\n@outputField_/SP6/LDS1{ExtractType}21:Str=\r\n@outputField_/SP6/LJY1{ExtractType}21:Str=\r\n@outputField_/SP6/LSH1{ExtractType}21:Str=\r\n@outputField_/SP6/LPO1{ExtractType}21:Str=\r\n@outputField_/SP6/LQY1{ExtractType}21:Str=\r\n@outputField_/SP6/LXV1{ExtractType}21:Str=\r\n@outputField_/SP6/LQH1{ExtractType}21:Str=\r\n@outputField_/SP6/LVR1{ExtractType}21:Str=\r\n@outputField_/SP6/LXT1{ExtractType}21:Str=\r\n@outputField_/SP6/n6:Str=\r\n@outputField_/SP6/n7:Str=\r\n@outputField_/SP6/n8:Str=\r\n@outputField_/SP6/n9:Str=\r\n@outputField_/SP6/n10:Str=\r\n@outputField_/SP6/n11:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=1\r\n@formatWidth:Int=1\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=CRM EE UDFs\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=S\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>CRM Skills List",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-16 16:49:04\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=SP6\r\n@filterFrom_CoID:Str='CRMEE'!$C$3{P}1\r\n@filterFrom_/SP6/EMA:Str=kevin@ovl.co.uk\r\n@filterTo_/SP6/EMA:Str=kevin@ovl.co.uk\r\n@outputField_/SP6/STS*1/DES:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=1\r\n@formatWidth:Int=1\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=CRM Skills List\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=0\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>CRMCActionsActivities",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-17 15:18:26\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=SP1\r\n@filterFrom_CoID:Str='CRMContact'!$C$3{P}1\r\n@filterFrom_/SP1/SP6*4/EMA:Str='CRMContact'!$C$4{P}2\r\n@filterTo_/SP1/SP6*4/EMA:Str='CRMContact'!$C$4{P}3\r\n@outputField_/SP1/ACT{ExtractType}0:Str=\r\n@outputField_/SP1/SP3*1/DES{ExtractType}0:Str=\r\n@outputField_/SP1/SUB{ExtractType}0:Str=\r\n@outputField_/SP1/LOC{ExtractType}0:Str=\r\n@outputField_/SP1/ACT1{ExtractType}0:Str=\r\n@outputField_/SP1/STA{ExtractType}0:Str=\r\n@outputField_/SP1/f1{ExtractType}0:Str=\r\n@outputField_/SP1/DUR{ExtractType}0:Str=\r\n@outputField_/SP1/PRI{ExtractType}0:Str=\r\n@outputField_/SP1/CAL{ExtractType}21:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=1\r\n@formatWidth:Int=1\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=CRMCActionsActivities\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>CRMContactPrint",">'axb",">'[LASATA SETUP FILE]\r\nDate=2017-08-17 15:24:55\r\nFileType=Agora XLB MacroBuilder\r\nVersion=0\r\nBuffer=\r\n@settngMacroName:Str=CRMContactPrint\r\n@settngMacroButtonCaption:Str=CRMContactPrint\r\n@settngMacroShortcutKey:Str=\r\n@recipeStep_PrintWorksheet_81715241755000:Str=P0=[GDPR.XLSM]CRMContact,P1=,P2=\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=CRMContactPrint\r\n"]
[">>CRMCActionsOpportunities",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-17 15:33:45\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=SPM\r\n@filterFrom_CoID:Str='CRMContact'!$C$3{P}1\r\n@filterFrom_/SPM/SP6*1/EMA:Str='CRMEE'!$C$4{P}2\r\n@filterTo_/SPM/SP6*1/EMA:Str='CRMEE'!$C$4{P}3\r\n@outputField_/SPM/PRO:Str=\r\n@outputField_/SPM/PRO1:Str=\r\n@outputField_/SPM/SPJ*1/DES:Str=\r\n@outputField_/SPM/n2:Str=\r\n@outputField_/SPM/n9:Str=\r\n@outputField_/SPM/n1:Str=\r\n@outputField_/SPM/PRO2:Str=\r\n@outputField_/SPM/FCL:Str=\r\n@outputField_/SPM/ESH:Str=\r\n@outputField_/SPM/LAS:Str=\r\n@outputField_/SPM/NEX:Str=\r\n@outputField_/SPM/RES:Str=\r\n@outputField_/SPM/ACL:Str=\r\n@outputField_/SPM/ADD:Str=\r\n@outputField_/SPM/ADD1:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=1\r\n@formatWidth:Int=1\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=CRMCActionsOpportunities\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>CRMCActionsQuotes",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-17 15:35:46\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=IH\r\n@filterFrom_CoID:Str='CRMContact'!$C$3{P}1\r\n@filterFrom_/IH/SPM*1/SP6*1/EMA:Str='CRMContact'!$C$4{P}2\r\n@filterTo_/IH/SPM*1/SP6*1/EMA:Str='CRMContact'!$C$4{P}3\r\n@outputField_/IH/1{ExtractType}0:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=1\r\n@formatWidth:Int=1\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=CRMCActionsQuotes\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>CRMEEPrint",">'axb",">'[LASATA SETUP FILE]\r\nDate=2017-08-22 14:19:14\r\nFileType=Agora XLB MacroBuilder\r\nVersion=0\r\nBuffer=\r\n@settngMacroName:Str=CRMEEPrint\r\n@settngMacroButtonCaption:Str=CRMEEPrint\r\n@settngMacroShortcutKey:Str=\r\n@recipeStep_PrintWorksheet_82214185538000:Str=P0=[GDPR.xlsm]CRMEE,P1=,P2=\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=CRMEEPrint\r\n"]
[">>XRLCRMEEExport",">'axb",">'[LASATA SETUP FILE]\r\nDate=2017-08-22 14:45:31\r\nFileType=Agora XLB MacroBuilder\r\nVersion=0\r\nBuffer=\r\n@settngMacroName:Str=XRLCRMEEExport\r\n@settngMacroButtonCaption:Str=XRLCRMEEExport\r\n@settngMacroShortcutKey:Str=\r\n@recipeStep_ActivateWorksheet_82214444488000:Str=P0=[GDPR.xlsm]CRMEEExport,P1=,P2=\r\n@recipeStep_RecalculateWorksheet_82214444994000:Str=P0=[GDPR.xlsm]CRMEEExport,P1=,P2=\r\n@recipeStep_RunCustomMacro_82214445195000:Str=P0=Module1.CRMEEExport,P1=,P2=\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=XRLCRMEEExport\r\n"]
[">>CRM EE UDFs Export",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-22 14:52:48\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=SP6\r\n@filterFrom_CoID:Str='CRMEE'!$C$3{P}1\r\n@filterFrom_/SP6/EMA:Str='CRMEE'!$C$4{P}2\r\n@filterTo_/SP6/EMA:Str='CRMEE'!$C$4{P}3\r\n@outputField_/SP6/CUD:Str=\r\n@outputField_/SP6/CUD1:Str=\r\n@outputField_/SP6/CUD2:Str=\r\n@outputField_/SP6/CUD3:Str=\r\n@outputField_/SP6/CUD4:Str=\r\n@outputField_/SP6/CUD5:Str=\r\n@outputField_/SP6/CUD6:Str=\r\n@outputField_/SP6/CUD7:Str=\r\n@outputField_/SP6/LSE{ExtractType}21:Str=\r\n@outputField_/SP6/LSE1{ExtractType}21:Str=\r\n@outputField_/SP6/LSE2{ExtractType}21:Str=\r\n@outputField_/SP6/LSE3{ExtractType}21:Str=\r\n@outputField_/SP6/LSE4{ExtractType}21:Str=\r\n@outputField_/SP6/LSE5{ExtractType}21:Str=\r\n@outputField_/SP6/LSE6{ExtractType}21:Str=\r\n@outputField_/SP6/LSE7{ExtractType}21:Str=\r\n@outputField_/SP6/LSE8{ExtractType}21:Str=\r\n@outputField_/SP6/LSE9{ExtractType}21:Str=\r\n@outputField_/SP6/LKL1{ExtractType}21:Str=\r\n@outputField_/SP6/LDS1{ExtractType}21:Str=\r\n@outputField_/SP6/LJY1{ExtractType}21:Str=\r\n@outputField_/SP6/LSH1{ExtractType}21:Str=\r\n@outputField_/SP6/LPO1{ExtractType}21:Str=\r\n@outputField_/SP6/LQY1{ExtractType}21:Str=\r\n@outputField_/SP6/LXV1{ExtractType}21:Str=\r\n@outputField_/SP6/LQH1{ExtractType}21:Str=\r\n@outputField_/SP6/LVR1{ExtractType}21:Str=\r\n@outputField_/SP6/LXT1{ExtractType}21:Str=\r\n@outputField_/SP6/n6:Str=\r\n@outputField_/SP6/n7:Str=\r\n@outputField_/SP6/n8:Str=\r\n@outputField_/SP6/n9:Str=\r\n@outputField_/SP6/n10:Str=\r\n@outputField_/SP6/n11:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=1\r\n@formatWidth:Int=1\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=CRM EE UDFs Export\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>CRM Skills List Export",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-22 14:53:38\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=SP6\r\n@filterFrom_CoID:Str='CRMEE'!$C$3{P}1\r\n@filterFrom_/SP6/EMA:Str='CRMEE'!$C$4{P}2\r\n@filterTo_/SP6/EMA:Str='CRMEE'!$C$4{P}3\r\n@outputField_/SP6/STS*1/DES:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=1\r\n@formatWidth:Int=1\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=CRM Skills List Export\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=0\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>GoToCRMContactRefresh",">'axb",">'[LASATA SETUP FILE]\r\nDate=2017-08-22 14:57:48\r\nFileType=Agora XLB MacroBuilder\r\nVersion=0\r\nBuffer=\r\n@settngMacroName:Str=GoToCRMContactRefresh\r\n@settngMacroButtonCaption:Str=GoToCRMContactRefresh\r\n@settngMacroShortcutKey:Str=\r\n@recipeStep_ActivateWorksheet_82214562580000:Str=P0=[GDPR.xlsm]CRMCActions,P1=,P2=\r\n@recipeStep_RecalculateWorksheet_82214563491000:Str=P0=[GDPR.xlsm]CRMCActions,P1=,P2=\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=GoToCRMContactRefresh\r\n"]
[">>CRM Contact UDFs Export",">'atb",">'[LASATA SETUP FILE]\r\nDate=2017-08-22 15:07:30\r\nFileType=Agora XLB ExtractTransactions\r\nVersion=0\r\nBuffer=\r\n@systemProduct:Str=PEGASUS\r\n@systemTable:Str=SP6\r\n@filterFrom_CoID:Str='CRMContact'!$C$3{P}1\r\n@filterFrom_/SP6/EMA:Str='CRMContact'!$C$4{P}2\r\n@filterTo_/SP6/EMA:Str='CRMContact'!$C$4{P}3\r\n@outputField_/SP6/CUD:Str=\r\n@outputField_/SP6/CUD1:Str=\r\n@outputField_/SP6/CUD2:Str=\r\n@outputField_/SP6/CUD3:Str=\r\n@outputField_/SP6/CUD4:Str=\r\n@outputField_/SP6/CUD5:Str=\r\n@outputField_/SP6/CUD6:Str=\r\n@outputField_/SP6/CUD7:Str=\r\n@outputField_/SP6/LSE{ExtractType}21:Str=\r\n@outputField_/SP6/LSE1{ExtractType}21:Str=\r\n@outputField_/SP6/LSE2{ExtractType}21:Str=\r\n@outputField_/SP6/LSE3{ExtractType}21:Str=\r\n@outputField_/SP6/LSE4{ExtractType}21:Str=\r\n@outputField_/SP6/LSE5{ExtractType}21:Str=\r\n@outputField_/SP6/LSE6{ExtractType}21:Str=\r\n@outputField_/SP6/LSE7{ExtractType}21:Str=\r\n@outputField_/SP6/LSE8{ExtractType}21:Str=\r\n@outputField_/SP6/LSE9{ExtractType}21:Str=\r\n@outputField_/SP6/LKL1{ExtractType}21:Str=\r\n@outputField_/SP6/LDS1{ExtractType}21:Str=\r\n@outputField_/SP6/LJY1{ExtractType}21:Str=\r\n@outputField_/SP6/LSH1{ExtractType}21:Str=\r\n@outputField_/SP6/LPO1{ExtractType}21:Str=\r\n@outputField_/SP6/LQY1{ExtractType}21:Str=\r\n@outputField_/SP6/LXV1{ExtractType}21:Str=\r\n@outputField_/SP6/LQH1{ExtractType}21:Str=\r\n@outputField_/SP6/LVR1{ExtractType}21:Str=\r\n@outputField_/SP6/LXT1{ExtractType}21:Str=\r\n@outputField_/SP6/n6:Str=\r\n@outputField_/SP6/n7:Str=\r\n@outputField_/SP6/n8:Str=\r\n@outputField_/SP6/n9:Str=\r\n@outputField_/SP6/n10:Str=\r\n@outputField_/SP6/n11:Str=\r\n@formatType:Lng=-4154\r\n@formatNumber:Int=1\r\n@formatPattern:Int=1\r\n@formatFont:Int=1\r\n@formatWidth:Int=1\r\n@formatAlignment:Int=1\r\n@formatBorder:Int=1\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=CRM Contact UDFs Export\r\n@settngShowMessages:Str=Y\r\n@settngDirection:Str=D\r\n@settngApplyFormula:Str=Y\r\n@settngLock:Str=N\r\n@settngOutputHeaders:Int=0\r\n@settngOutputCaptions:Int=1\r\n@settngOutputTotals:Int=0\r\n@settngOutputFiltering:Int=0\r\n@settngPivotTable:Int=0\r\n@settngTopPercent:Str=\r\n@settngReportStyle:Lng=0\r\n"]
[">>XRLCRMContactExport",">'axb",">'[LASATA SETUP FILE]\r\nDate=2017-08-22 15:16:25\r\nFileType=Agora XLB MacroBuilder\r\nVersion=0\r\nBuffer=\r\n@settngMacroName:Str=XRLCRMContactExport\r\n@settngMacroButtonCaption:Str=XRLCRMContactExport\r\n@settngMacroShortcutKey:Str=\r\n@recipeStep_ActivateWorksheet_82215152608000:Str=P0=[GDPR.xlsm]CRMContactExport,P1=,P2=\r\n@recipeStep_RecalculateWorksheet_82215152906000:Str=P0=[GDPR.xlsm]CRMContactExport,P1=,P2=\r\n@recipeStep_RunCustomMacro_82215153134000:Str=P0=Module1.CRMContactExport,P1=,P2=\r\n@filenmSetupfile:Str=\r\n@filenmWorkbookSetupFile:Str=XRLCRMContactExport\r\n"]