Altair personal scl Monarch Exercise 38 UKG Pro Detail Labor Allocations by Project
Too long to pose in a listserv, see github
github
https://github.com/rogerjdeangelis/utl-altair-personal-scl-Monarch-Exercise-38-UKG-Pro-Detail-Labor-Allocations-by-Project
community.altair.com
https://community.altair.com/discussion/34153
https://community.altair.com/discussion/34153/monarch-exercise-38-ukg-pro-detail-labor-allocations-by-project#latest
CONTENTS AND RESULTS
1 EXTRACT DATA FROM EXCEL
Create Tables
companys (eight company names
combined (all eight sheets combined)
2 TOTAL TAXES BY PROJECT FOR THE COMPANY?
PROJ_COMPANY EMPLOYEE_TAX
Project: 10100000 - Corporate 9961.95
Project: 12000000 - Marketing 2109.70
Project: 17000000 - The Center 1175.77
Project: 27027080 - Kresge Found. - Next Gen. 534.90
Project: 27036060 - United Way AIMS CCF 2009.65
Project: 27067060 - YAP Wayne County 816.97
Project: 27095985 - City of Detroit NOF 184.93
3 WHICH EMPLOYEE HAD THE LARGEST NUMBER OF DEDUCTIONS?
NAMESAV
y2xxxxx, Jesse H
4 WHICH EMPLOYEE HAD THE LARGEST NET PAY?
NAME NET_PAY
y11xxxxx, Vincent 4167.83
