аЯрЁБс>ўџ Eўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ§џџџD  !"#$%&'()*+,-./0123456789:;<=>?@ABCўџџџKWGHIJLTMNOPQRSU`VXўџџџYZ[\]^_aebcdўџџџўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџRoot Entryџџџџџџџџ РF`cХ`_ъіcХF€5WorkbookџџџџџџџџXƒ_VBA_PROJECT_CUR"Ж>іcХ`_ъіcХVBAџџџџџџџџ Ж>іcХ  аіcХ гЭЩР`сАСт\pmichaeln BАaР= гНК ThisWorkbookœЏМ=h- 0&8X@"Зк1ШџјArial1ШџјArial1ШџјArial1ШџјArial1ШџМјArial1№џМјArial1ШџјArial1ШџМјArial1џМјArial1Ш јArial1Ш$јArial1ШџјArial1ШџМјArial1ДџМјArial1ДџјArial1 џјArial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)Є"True";"True";"False"Ѕ#,##0;\-#,##0;\'І#,##0;\-#,##0; Ї?;\'рѕџ Р рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР р Р р+ѕџ јР р)ѕџ јР р,ѕџ јР р*ѕџ јР р єџєР р єџєР р ѕџ јР р @Р р Р р Р р `@ @ Р р!Р р Р р  Р р,!#Р р,!#XР р,!#PР р#Р р(Р р  Р р ,!#Р р #Р р `@ Р р,!#x@ Р р#p@ Р р(Р р#0@ Р р"Р рЄ"t@ @ Р рЄ"t@ Р р,!#xР р,!#x@ @ Р р#0Р р!Р р,!!Р р @ Р р !Р р Р р `Р рЄ"tР р#pР р `@@ Р р#p@ @ Р р,! Р р,! `@ @ Р р, $@ @ Р р,! h@ @ Р р,! HР р, Р р `@@ Р рЇ d@@ Р рІ $@ @ Р р `@ @ Р р,! h@ @ Р р, $@ @ Р р,! `@ @ Р р!Р р Р р!Р р Р р,! Р р Р р Р р!8 Р р)Р р!x!@ @  р h!@ @  р"x@ @  р,!"x@ @  р (x!@ @  р ,!+x!@ @  р (x@ @ р *x@ @ р,!"x@@  р,!"x@  р,!"x @  р *x!@ @  р +x!@ @  р,!#x!@ @  р#x!@ @  р!Р р !Р р  x!@ @  р `@ @  “€џ“€џ“€џ“€џ“€ џ“€џ“€џ“€џ`…ЈW2 Requirements…+Pay IDs…F Deduction IDs…х[ Fringe IDs…кq AllocationŒЎЎ   &ўџўџ( ExternalData_1; ( ExternalData_1; ( ExternalData_1; ( ExternalData_1; ( ExternalData_1= ( ExternalData_2;( ExternalData_2;( ExternalData_2;( ExternalData_2;( ExternalData_2= ( ExternalData_3;( ExternalData_4;TSCount TSDataFolderTSFindTSLookupTSSumСС"ОќA …P Description Retain YTDDo Not Retain YTDBTotals for these Pay Ids will be retained when the year is closed.ATotals for these Pay Ids will be cleared when the year is closed.”To change whether the balance for a Pay ID will be retained or not, open Payroll and go to Setup / Pays. Then check or un-check the Retain YTD box.Employee Pay RecordsПUse this worksheet to verify that Pay Ids have been correctly identified for retaining balances at year-end. Also identify Pay Ids that are not being used that can potentially be eliminated. Year End Payroll - Pay ID Review&Year End Payroll - Deduction ID ReviewЫUse this worksheet to verify that Deduction Ids have been correctly identified for retaining balances at year-end. Also identify Deduction Ids that are not being used that can potentially be eliminated.Union Item Records Current UsageGeneral InformationEmployee YTD PayHTotals for these Deduction Ids will be retained when the year is closed.GTotals for these Deduction Ids will be cleared when the year is closed.Employee YTD DeductionsEmployee Deduct RecordsEmployee YTD FringeEmployee Fringe Records#Year End Payroll - Fringe ID ReviewХUse this worksheet to verify that Fringe Ids have been correctly identified for retaining balances at year-end. Also identify Fringe Ids that are not being used that can potentially be eliminated.ETotals for these Fringe Ids will be retained when the year is closed.DTotals for these Fringe Ids will be cleared when the year is closed.šTo change whether the balance for a Fringe ID will be retained or not, open Payroll and go to Setup / Fringes. Then check or un-check the Retain YTD box. Federal Run EmployeesW2 Requirements WorksheetУThis worksheet provides a count of the number of employees having YTD wages for federal, each state and each local tax. This can be used to help you determine the number of W2 forms you require. State Run Local RunExtraAmount Job Number Cost CodeCategory GL AccountBurdenTimePercentage to allocate:% AllocationYear End Allocation WorksheetjThis worksheet can be used to determine year-end allocation of payroll costs that are split between calendar years. The first table shows cost from time entries that have been recorded but not posted. The second table shows cost from burden that has been processed but not posted. Both are summarized by Job, Extra, Cost Code, Category and GL expense account.Pay IDPay Type0 Salary PayRegular1Regular Hourly Pay2 Overtime 1.5Overtime3 Double Time4 Sick $ PaidOther5 Vac $ Paid6Sick Hrs EarnedAccrual7Sick Hrs Taken8Vac Hrs Earned9 Vac Hrs Taken10 Cash Fringe Cash fringe Deduction ID Deduct Type Fringe ID Auto EmployeeWCWorkers' CompensationџRќ $4зчЛЫГУех '7 v† Уг cc" гЭЩР  + л&  dќЉёвMbP?_*+‚€%џС1.&LOffice Connector &F&CPayroll Year End&R&D &Tƒ„M’HP LaserJet 2100 Series PSмДGъ oRАLetterPRIVр'''' )џЁ"Rcар?р?U} л !} ’ } ’}  } Ж} л } Ж} m } } л   h @ џ€I h о@ €    џ§ 4О44444D`џџ ў.#COMPANY_INFORMATIONCNAME0BџО44444!aџџџ #BџОHHHHHО444444§ MОMMMMMMMMM § Q§ R§ R§ R§ R§ R§ R§  R*O3џџџ9# MASTER_PRM_RECORD_1 Where ((EYGROSS <> 0))BџAOBџџDR§9#TAX_PRX_RECORD_4TXDESCDР@SWH@Bџ{Cџџџe# MASTER_PRM_RECORD_2 Where ((E2WORK2 = '@DР@@') AND (E2YGRS <> 0))@BџADBџџџ.#TAX_PRX_RECORD_4TXDESC$Р@Bџ‘ Cџџџ{# MASTER_PRM_RECORD_4 Where ((ETTXID = '@DР@@,') AND (ETYTXBL <> 0) AND (ETLEV = 'Local'))@BџО 059OBџџџ9#TAX_PRX_RECORD_4TXDESCDР@SWH@Bџ{Cџџџe# MASTER_PRM_RECORD_2 Where ((E2WORK2 = '@DР@@') AND (E2YGRS <> 0))@Bџ9DBџџџ.#TAX_PRX_RECORD_4TXDESC$Р@Bџ‘ Cџџ џ{# MASTER_PRM_RECORD_4 Where ((ETTXID = '@DР@@,') AND (ETYTXBL <> 0) AND (ETLEV = 'Local'))@BџзјŒ"\9*p Т  >Д@<d х  ­ШExternalData_3 м ™Эƒ€SELECT DISTINCT MASTER_PRM_RECORD_2.E2WORK2 FROM MASTER_PRM_RECORD_2 MASTER_PRM_RECORD_2 WHERE (MASTER_PRM_RECORD_2.E2YGRS<>0)Э\YDSN=E1 Timberline Gold Data;DBQ=D:\TEST;CODEPAGE=1252;MaxColSupport=255;DictionaryMode=1;#ExternalData_3Q=,E2WORK2­ШExternalData_4м ™ЭЋЈSELECT DISTINCT MASTER_PRM_RECORD_4.ETTXID FROM MASTER_PRM_RECORD_4 MASTER_PRM_RECORD_4 WHERE (MASTER_PRM_RECORD_4.ETLEV='Local') AND (MASTER_PRM_RECORD_4.ETYTXBL<>0)Э\YDSN=E1 Timberline Gold Data;DBQ=D:\TEST;CODEPAGE=1252;MaxColSupport=255;DictionaryMode=1;#ExternalData_4Q=,ETTXIDя7К Sheet1 гЭЩР $б/№@DA  dќЉёвMbP?_*+‚€%џС96&LEvent 1Office Connector &F&CPayroll Year End&R&D &T ƒ„MКTektronix Phaser 850DPммSџ€ъ oacаLetterPRIVт0''''Ф\KhCє*A џSKETЁ"acар?р?U} л} л} m } Ж } I !} I!Pay TypePay ID$hџџ€Kџ€#9Р#,џџ  €"  џ џ ,џџ  џџџџџџџџџџџџџ§ D`џџў.#COMPANY_INFORMATIONCNAME0Bџ!aџџџ #BџОJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJџО $%%§ NОNNNNN§ § 1О2§ S О SS§ T О TT§ U-§ U§ U.§ V§ ]§ ] О &&&r 'џџpR§\#MASTER_PRM_RECORD_3EPYPAY Where ((EPPAYID = '@D Р@@'))@Bџi (џџџS# MASTER_PRM_RECORD_3 Where ((EPPAYID = '@D Р@@'))@Bџ| (џџџf# SYSTEM_PRS_RECORD_10 Where ((UIPAYID = '@D Р@@') AND (UIPAYID<>''))@BџО &&&r 'џџ џ\#MASTER_PRM_RECORD_3EPYPAY Where ((EPPAYID = '@D Р@@'))@Bџi (џџ џS# MASTER_PRM_RECORD_3 Where ((EPPAYID = '@D Р@@'))@Bџ| (џџ џf# SYSTEM_PRS_RECORD_10 Where ((UIPAYID = '@D Р@@') AND (UIPAYID<>''))@Bџ§  § OОOOOOO§ S О SS§ T О TT§ b-§ b§ b.§ V§ ]§ ] § &/§ &0§ &1'џџ џМf \#MASTER_PRM_RECORD_3EPYPAY Where ((EPPAYID = '@L§Р@@'))@Bџ(џџ џМ] S# MASTER_PRM_RECORD_3 Where ((EPPAYID = '@LќР@@'))@Bџ(џџ џМp f# SYSTEM_PRS_RECORD_10 Where ((UIPAYID = '@LћР@@') AND (UIPAYID<>''))@Bџ§ 2§ 3§ 1'џџ џ(џџ џ(џџ џ§ 4§ 5§ 6'џџ џ(џџ џ(џџ џ§ 7§ 8§ 6'џџ џ(џџ џ(џџ џ§ 9§ :§ ;'џџ џ(џџ џ(џџ џ§ <§ =§ ;'џџ џ(џџ џ(џџ џ§ >§ ?§ @'џџ џ(џџ џ(џџ џ§ A§ B§ @'џџ џ(џџ џ(џџ џ§ C§ D§ @'џџ џ(џџ џ(џџ џ§ E§ F§ @'џџ џ(џџ џ(џџ џ§ G§ H§ I'џџ џ(џџ џ(џџ џ§ MОMMMMз<H-""8Tss"8TЦ‡‡‡‡‡‡‡‡‡‡ #@зТ$   џ  REC>Д@<dх:­ЩExternalData_2м ™ЭyvSELECT "PPAYID" AS "Pay ID","PDESC" AS "Description","PTYPE" AS "Pay Type" FROM SYSTEM_PRS_RECORD_1 Where ((PYTD = 0))Э\YDSN=E1 Timberline Gold Data;DBQ=D:\TEST;CODEPAGE=1252;MaxColSupport=255;DictionaryMode=1;#ExternalData_2Q=,Pay ID DescriptionPay Type­ЩExternalData_1м ™ЭyvSELECT "PPAYID" AS "Pay ID","PDESC" AS "Description","PTYPE" AS "Pay Type" FROM SYSTEM_PRS_RECORD_1 Where ((PYTD = 1))Э\YDSN=E1 Timberline Gold Data;DBQ=D:\TEST;CODEPAGE=1252;MaxColSupport=255;DictionaryMode=1;#ExternalData_1Q=, Pay ID DescriptionPay Typeя7К Sheet2 гЭЩР ЬJУV  dќЉёвMbP?_*+‚€%џС:7&LEvent 1 Office Connector &F&CPayroll Year End&R&D &T ƒ„MКTektronix Phaser 850DPммSџ€ъ odcаLetterPRIVт0''''Ф\KhCє*A џSKETЁ"dcар?р?U} $ } л} $} I } л !} I !hџџ€K8@,џџ  €)  џ џ џ ,џџ €) џџџ§  D`џџў.#COMPANY_INFORMATIONCNAME0Bџ!aџџџ #BџОJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJџ§ N ОNNNNN§ § OОOOOOO§ S О SS§ T О TT§ UJ§ U§ UK§ V§ V§ V О &&&r 'џџXR§\#MASTER_PRM_RECORD_5EDYDED Where ((EDDEDID = '@D Р@@'))@Bџi *џџџS# MASTER_PRM_RECORD_5 Where ((EDDEDID = '@D Р@@'))@Bџ} *џџџg# SYSTEM_PRS_RECORD_10 Where ((UIDEDID = '@D Р@@') AND (UIDEDID <>''))@BџО r 'џџ џ\#MASTER_PRM_RECORD_5EDYDED Where ((EDDEDID = '@D Р@@'))@Bџi *џџ џS# MASTER_PRM_RECORD_5 Where ((EDDEDID = '@D Р@@'))@Bџ} *џџ џg# SYSTEM_PRS_RECORD_10 Where ((UIDEDID = '@D Р@@') AND (UIDEDID <>''))@BџО .§  § OОOOOOO§ S О SS§ T О TT§ UJ§ U§ UK§ V§ V§ V О &&&r'џџ џ\#MASTER_PRM_RECORD_5EDYDED Where ((EDDEDID = '@DР@@'))@Bџi*џџ џS# MASTER_PRM_RECORD_5 Where ((EDDEDID = '@DР@@'))@Bџ}*џџ џg# SYSTEM_PRS_RECORD_10 Where ((UIDEDID = '@DР@@') AND (UIDEDID <>''))@BџО r'џџџ\#MASTER_PRM_RECORD_5EDYDED Where ((EDDEDID = '@DР@@'))@Bџi*џџџS# MASTER_PRM_RECORD_5 Where ((EDDEDID = '@DР@@'))@Bџ}*џџџg# SYSTEM_PRS_RECORD_10 Where ((UIDEDID = '@DР@@') AND (UIDEDID <>''))@BџО 00з( TH-""8Ttt"8TttТ$ 0 џ  SY>Д@х:­ЩExternalData_2м ™Э†ƒSELECT "MDDEDID" AS "Deduction ID","MDDESC" AS "Description","MDTYPE" AS "Deduct Type" FROM SYSTEM_PRS_RECORD_3 Where ((MDYTD = 0))Э\YDSN=E1 Timberline Gold Data;DBQ=D:\TEST;CODEPAGE=1252;MaxColSupport=255;DictionaryMode=1;#ExternalData_2Q=, Deduction ID Description Deduct Type­ЩExternalData_1м ™Э†ƒSELECT "MDDEDID" AS "Deduction ID","MDDESC" AS "Description","MDTYPE" AS "Deduct Type" FROM SYSTEM_PRS_RECORD_3 Where ((MDYTD = 1))Э\YDSN=E1 Timberline Gold Data;DBQ=D:\TEST;CODEPAGE=1252;MaxColSupport=255;DictionaryMode=1;#ExternalData_1Q=,  Deduction ID Description Deduct Typeя7К Sheet3 гЭЩР ™`Шl  dќЉёвMbP?_*+‚€%џС:7&LEvent 1 Office Connector &F&CPayroll Year End&R&D &T ƒ„MКTektronix Phaser 850DPммSџ€ъ odcаLetterPRIVт0''''Ф\KhCє*A џSKETЁ"dcар?р?U} I } } л+} ’ }  !} I!hџџ€Kэ@,џџ §€" џ џ џ ,џџ  џџџџ@№@§ D`џџў.#COMPANY_INFORMATIONCNAME0Bџ!aџџџ #BџОJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJџ§ NОNNNNN§ § § S О SS§ T О TT§ WL§ W§ XM§ X§ X§ X О ,r /џџДR§\#MASTER_PRM_RECORD_6EFYFRG Where ((EFFRGID = '@D Р@@'))@Bџi :џџџS# MASTER_PRM_RECORD_6 Where ((EFFRGID = '@D Р@@'))@Bџ| :џџџf# SYSTEM_PRS_RECORD_10 Where ((UIFRGID = '@D Р@@') AND (UIFRGID<>''))@BџО ,r /џџ џ\#MASTER_PRM_RECORD_6EFYFRG Where ((EFFRGID = '@D Р@@'))@Bџi :џџ џS# MASTER_PRM_RECORD_6 Where ((EFFRGID = '@D Р@@'))@Bџ| :џџ џf# SYSTEM_PRS_RECORD_10 Where ((UIFRGID = '@D Р@@') AND (UIFRGID<>''))@BџО 667.88§  §  § S О SS§ Y О Z[§ UL§ U§ \M§ V§ ]§ ] § &N§ &O~ -№?r/џџ џ\#MASTER_PRM_RECORD_6EFYFRG Where ((EFFRGID = '@DР@@'))@Bџi:џџ џS# MASTER_PRM_RECORD_6 Where ((EFFRGID = '@DР@@'))@Bџ|:џџ џf# SYSTEM_PRS_RECORD_10 Where ((UIFRGID = '@DР@@') AND (UIFRGID<>''))@BџО ,r/џџџ\#MASTER_PRM_RECORD_6EFYFRG Where ((EFFRGID = '@DР@@'))@Bџi:џџџS# MASTER_PRM_RECORD_6 Where ((EFFRGID = '@DР@@'))@Bџ|:џџџf# SYSTEM_PRS_RECORD_10 Where ((UIFRGID = '@DР@@') AND (UIFRGID<>''))@Bџ§ MОMMMMMз,З |H-"8Tss8Ts"Т$ M џ  SY>Д@х2­ЩExternalData_1м ™Э~SELECT "FFRGID" AS "Fringe ID","FDESC" AS "Description","FAUTO" AS "Auto Employee" FROM SYSTEM_PRS_RECORD_4 Where ((FYTD = 1))Э\YDSN=E1 Timberline Gold Data;DBQ=D:\TEST;CODEPAGE=1252;MaxColSupport=255;DictionaryMode=1;#ExternalData_1Q=,  Fringe ID Description Auto Employee­ЩExternalData_2eм ™Э~SELECT "FFRGID" AS "Fringe ID","FDESC" AS "Description","FAUTO" AS "Auto Employee" FROM SYSTEM_PRS_RECORD_4 Where ((FYTD = 0))Э\YDSN=E1 Timberline Gold Data;DBQ=D:\TEST;CODEPAGE=1252;MaxColSupport=255;DictionaryMode=1;#ExternalData_2Q=, Fringe ID Description Auto Employeeя7К Sheet4 гЭЩР ŽvЅ{  dќЉёвMbP?_*+‚€%џС:7&LEvent 1 Office Connector &F&CPayroll Year End&R&D &T ƒ„MКTektronix Phaser 850DPммSџ€ъ odcаLetterPRIVт0''''Ф\KhCє*A џSKETЁ"dcар?р?U} }  } ’ } m} Ж ;} л hџџ€K @џ h   џ џ џh џџџ§ +D`џџў.#COMPANY_INFORMATIONCNAME0Bџ!aџџ џ #BџL§ P,ОPPPPPP§ (~ c9@§ )§ '§ R"§ R § R#§ R$§ R%§ ^!§ _*О DDDDDG% F џD РDdО <% =џD РDdО # ?џ % РРЌ№# @œ R§ % РРџ§ &§ R"§ R § R#§ R$§ R%§ ^!§ _*ОDDDDDE%FџDРDdО>%=џDРDdО#? џ %РРЌ№#@ џ %РРЌ№з"ŸH/$*b??bb??Т$  џ  Р>Д@<dх ­ШExternalData_2м ™ЭщцSELECT NEW_PRT_RECORD_11.BJOB, NEW_PRT_RECORD_11.BEXTRA, NEW_PRT_RECORD_11.BPHASE, NEW_PRT_RECORD_11.BCAT, NEW_PRT_RECORD_11.BACCT, Sum(NEW_PRT_RECORD_11.BAMT) FROM NEW_PRT_RECORD_11 NEW_PRT_RECORD_11 GROUP BY NEW_PRT_RECORD_11.ЭщцBJOB, NEW_PRT_RECORD_11.BEXTRA, NEW_PRT_RECORD_11.BPHASE, NEW_PRT_RECORD_11.BCAT, NEW_PRT_RECORD_11.BACCT ORDER BY NEW_PRT_RECORD_11.BJOB, NEW_PRT_RECORD_11.BEXTRA, NEW_PRT_RECORD_11.BPHASE, NEW_PRT_RECORD_11.BCAT, NEW_PRT_RECORDЭ _11.BACCTЭ\YDSN=E1 Timberline Gold Data;DBQ=D:\TEST;CODEPAGE=1252;MaxColSupport=255;DictionaryMode=1;#ExternalData_2Q=,BJOBBEXTRABPHASEBCATBACCTEXPR_1­ШExternalData_1м ™ЭщцSELECT NEW_PRT_RECORD_1.TJOB, NEW_PRT_RECORD_1.TEXTRA, NEW_PRT_RECORD_1.TPHASE, NEW_PRT_RECORD_1.TCAT, NEW_PRT_RECORD_1.TACCT, Sum(NEW_PRT_RECORD_1.TAMT) FROM NEW_PRT_RECORD_1 NEW_PRT_RECORD_1 GROUP BY NEW_PRT_RECORD_1.TJOB, NEWЭрн_PRT_RECORD_1.TEXTRA, NEW_PRT_RECORD_1.TPHASE, NEW_PRT_RECORD_1.TCAT, NEW_PRT_RECORD_1.TACCT ORDER BY NEW_PRT_RECORD_1.TJOB, NEW_PRT_RECORD_1.TEXTRA, NEW_PRT_RECORD_1.TPHASE, NEW_PRT_RECORD_1.TCAT, NEW_PRT_RECORD_1.TACCTЭ\YDSN=E1 Timberline Gold Data;DBQ=D:\TEST;CODEPAGE=1252;MaxColSupport=255;DictionaryMode=1;#ExternalData_1Q=, TJOBTEXTRATPHASETCATTACCTEXPR_1я7К Sheet5 ThisWorkbook џџџџйSheet1 џџџџџџџџ~__SRP_2џџџџ"ф__SRP_3џџџџџџџџџџџџ&B ўџџџ !ўџџџ#$%ўџџџ'ўџџџ)*+,-./01234567ўџџџ9:;<=>?@ABCDEFGўџџџIJKLMNOPQRSTUVWўџџџYZ[\]^_`abcdefgўџџџijklmnopqrstuvwxyz{|}~€№ФдџџџџЫžQоЃџџ#ˆЖџџџџџџџџџџџџџџџџџџџџџџџџxџџMEџџџџџџџџџџпџџ џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ(SLџџџџSџџџџS”џџџџ<џџџџџџN0{00020819-0000-0000-C000-000000000046}џџџџ8€ўџџџџџџџ(џџџџџџџџџџ%џџџџHџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџпўЪџџџџџџџџxџџџџААAttribute VB_Name = "ThisWorkbook" ŒBasŒ0{00020P819-0C$0046} |GlobalаSpac’False dCreatablPredeclaIdБTru BExposeTemplateDeriv’BustomizD2<фjxЬžQŽzџџ#ˆЖџџџџџџџџ<џџЁQR<)D†чp”<ыЮ РFЎъ9р5 Ѕ@Є;Лт=‰Д џџџџџџџџџџџџxЎъ9р5 Ѕ@Є;Лт=‰Д ЁQR<)D†чp”<ыЮџџMEџџџџџџџџџџпџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ(SLџџџџSџџџџS”џџџџ6"џџџџџџN0{00020820-0000-0000-C000-000000000046}џџџџ €ўџџџџџџџ(џџџџџџџџџџ%џџџџHƒўџџџџџџџ`џџџџџџџџџџџџџџ %‚ џџџџўџџџџџўџџџџџџџџџџџ %џџџџ`џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџh8@HHџџџџџџџџџџџџџџџџџџџџџџ0Z€N?$*\Rffff*084356572fпџџџџ4ўЪџџџџџџџџxџџџџЈАAttribute VB_Name = "She@et1" шBast0{000Р20820- C$0046} |Global!ФSpac’False dCreatablPre declaIdЋTru BExposeTemplateDeriv$’Bustom izD2rU€€€ pЉбљџџџџ4!aIџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ‹`rU€€€ џџџџџџџџ@nSheet2 џџџџ(бSheet3џџџџџџџџџџџџ8бSheet4џџџџHбSheet5џџџџџџџџџџџџXб№ФдџџџџЫžQМхџџ#ˆЖџџџџџџџџџџџџџџџџџџџџџџџџxџџMEџџџџџџџџџџпџџ џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ(SLџџџџSџџџџS”џџџџ<џџџџџџN0{00020820-0000-0000-C000-000000000046}џџџџ8€ўџџџџџџџ(џџџџџџџџџџ%џџџџHџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџпўЪџџџџџџџџxџџџџЈАAttribute VB_Name = "She@et2" шBast0{000Р20820- C$0046} |Global!ФSpac’False dCreatablPre declaIdЋTru BExposeTemplateDeriv$’Bustom izD2№ФдџџџџЫžQ­џџ#ˆЖџџџџџџџџџџџџџџџџџџџџџџџџxџџMEџџџџџџџџџџпџџ џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ(SLџџџџSџџџџS”џџџџ<џџџџџџN0{00020820-0000-0000-C000-000000000046}џџџџ8€ўџџџџџџџ(џџџџџџџџџџ%џџџџHџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџпўЪџџџџџџџџxџџџџЈАAttribute VB_Name = "She@et3" шBast0{000Р20820- C$0046} |Global!ФSpac’False dCreatablPre declaIdЋTru BExposeTemplateDeriv$’Bustom izD2№ФдџџџџЫžQuДџџ#ˆЖџџџџџџџџџџџџџџџџџџџџџџџџxџџMEџџџџџџџџџџпџџ џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ(SLџџџџSџџџџS”џџџџ<џџџџџџN0{00020820-0000-0000-C000-000000000046}џџџџ8€ўџџџџџџџ(џџџџџџџџџџ%џџџџHџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџпўЪџџџџџџџџxџџџџЈАAttribute VB_Name = "She@et4" шBast0{000Р20820- C$0046} |Global!ФSpac’False dCreatablPre declaIdЋTru BExposeTemplateDeriv$’Bustom izD2№ФдџџџџЫžQ!џџ#ˆЖџџџџџџџџџџџџџџџџџџџџџџџџxџџMEџџџџџџџџџџпџџ џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ(SLџџџџSџџџџS”џџџџ<џџџџџџN0{00020820-0000-0000-C000-000000000046}џџџџ8€ўџџџџџџџ(џџџџџџџџџџ%џџџџHџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџпўЪџџџџџџџџxџџџџЈАAttribute VB_Name = "She@et5" шBast0{000Р20820- C$0046} |Global!ФSpac’False dCreatablPre declaIdЋTru BExposeTemplateDeriv$’Bustom izD2_VBA_PROJECTџџџџџџџџџџџџh. dirџџџџџџџџџџџџ•3__SRP_0 џџџџž__SRP_1џџџџџџџџџџџџГzЬayџ  фњ*\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.5#0#C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE#Microsoft Excel 11.0 Object LibraryМ*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\System32\stdole2.tlb#OLE Automation *\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.3#0#C:\Program Files\Microsoft Office\Office\MSO9.DLL#Microsoft Office 9.0‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”ўџџџ–—˜™š›œўџџџŸ ЁЂЃЄЅІЇЈЉЊЋЌ­ЎЏАБВўџџџДўџџџЖЗўџџџЙКЛМНОПРСўџџџУФХўџџџЧШЩЪЫЬЭЮЯабвгўџџџеўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ Object Library  џџџџџџџџZ€N?џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџžQThisWorkbook02435656fbџџThisWorkbookџџоЃ%џџ Sheet1084356572fџџ Sheet1џџŽzвџџ Sheet204435656fbџџ Sheet2џџМх0%џџ Sheet305435656fbџџ Sheet3џџ­H%џџ Sheet406435656fbџџ Sheet4џџuД`%џџ Sheet507435656fbџџ Sheet5џџ!x%џџџџџџ˜џџџџџџџџџџџџџџџџџџџџџџџџ`џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџHџџџџџџџџџџџџџџџџџџџџ0џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџxџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџN+Ъ^бšјJ„PЯFЯ §,џџџџЧѕдЃр4C–JйCaŽ]†џџџџ ћ˜.б{ыHЂй№/ …џџџџ;RЪ?ГЖ™HЎmБшдœиЎџџџџШихђ>K•PРЭжЦџџџџ:zЉ™qЕLОC&K``т–џџџџџџџџh€џ`&Excel€+VBAїтWin16С~Win32MacГВVBA6­# VBAProjectОПstdole“`Officeu ThisWorkbook|у €џ_EvaluateйSheet1шSheet2щSheet3ъSheet4ыSheet5ьWorkbookk WorksheetСўџџ„џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ џџџџџџl/В€0* pH‚dф VBAProjeˆct4@j = r Z€N?” J< r€stdole>stdo€le h%^*\G{00€020430-C 0046}#2.0#0#C:\WINDOWS\Syst em32\e2.tlb#OLE Automation`ƒEOffDic„EOf€iдc‚E€…€E2DF8D04C-5BFA-10€1B-BDE5€EдAA€C4€2ˆE€˜gram Files\Micro soft 6\MSO9.DLL#  9.0 ObК Libra,ry€CЭ"‚žQЁThisWorkbo okG€TЄ isWЌrЈkb€o€ŽŠ2к РHB‚1‚t%BE,Т!оЃ"B+B‚xSheetT1GТS@#e€Ttа1H2NЯRваŽzд2Э2%Щ2Э2у7МхUд3Э3Щ3Э3Љф­д4Э4ЩJ4Э4фuДє 5еэ 5щ 5э 5џ тE!щ ЂF“K*yџџџџrU€€€~~~~~~l Щ$Žš[LyKŽЛE*ё‘a;  фџџџџ џџџџџџџџџџџџщƒŠa iџџџџџџ џџџџџџџџџџџџ) џџџџџџџџџџџџA џџџџџџџџџџџџY џџџџџџџџџџџџq)9!) VBAProject ThisWorkbookSheet1Sheet2Sheet3Sheet4Sheet5яРF /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA ‰џџџџ Б0РF4C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXEExcel џџџџЉ!@0РF C:\WINDOWS\System32\stdole2.tlbstdole ‘џџџџЙ PLај-њ[НхЊDоR 1C:\Program Files\Microsoft Office\Office\MSO9.DLLOffice yџџџџЁ`иРFЁQR<)D†чp”<ыЮ РFЎъ9р5 Ѕ@Є;Лт=‰Д DРF Worksheet @/rU€€€€~} џџџџџџџџџџџџџџџџ џџџџџџџџџџџџџџџџ 9!pThisWorkbookThisWorkbookSheet1Sheet1Sheet2Sheet2Sheet3Sheet3Sheet4Sheet4Sheet5Sheet5PROJECTwmџџџџџџџџџџџџЕ’PROJECTџџџџИfSummaryInformation(џџџџџџџџТєDocumentSummaryInformation8џџџџџџџџџџџџЦ€ID="{59C8E358-7B05-4F10-A847-4EE93E7D14F9}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Document=Sheet2/&H00000000 Document=Sheet3/&H00000000 Document=Sheet4/&H00000000 Document=Sheet5/&H00000000 Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="F9FB1CE420E420E420E420" DPB="F2F0172C112D112D11" GC="EBE90E3706380638F9" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=0, 0, 0, 0, C Sheet1=0, 0, 0, 0, C Sheet2=0, 0, 0, 0, C Sheet3=0, 0, 0, 0, C Sheet4=0, 0, 0, 0, C Sheet5=0, 0, 0, 0, C ўџр…ŸђљOhЋ‘+'Гй0ФHPl€ ˜ Є АМфMichael R. Newland michaelnMicrosoft Excel@€GHЄŒЅТ@йЊџёЂТ@€юwіcХўџеЭеœ.“—+,љЎDеЭеœ.“—+,љЎФ€ PXx €ˆ˜   >фEvent 1 Software, Inc.и W2 RequirementsPay IDsDeduction IDs Fringe IDs AllocationAllocation!ExternalData_1'Deduction IDs'!ExternalData_1'Fringe IDs'!ExternalData_1'Pay IDs'!ExternalData_1Allocation!ExternalData_2'Deduction IDs'!ExternalData_2'Fringe IDs'!ExternalData_2'Pay IDs'!ExternalData_2!'W2 Requirements'!ExternalData_3!'W2 Requirements'!ExternalData_4  Worksheets Named Ranges М0{ƒŸЏ OCVersionTimberlineDataFolderPersistentCacheфVersion 1.01.0040Prompt0ўџ џџџџ РF!Microsoft Office Excel WorksheetBiff8Excel.Sheet.8є9ВqCompObjџџџџџџџџџџџџдmџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ