[go: up one dir, main page]
Scribd
Upload
116 views1 page

SalaryProcessing - Assignment For Practice

This document provides instructions for processing salary data from multiple sheets into consolidated outputs. It involves taking an input file with 3 sheets of salary data, merging the sheets into a single sheet, calculating total and average values for two categories for each employee, filtering employees into two output files based on which category they scored higher in, and calculating averages for each subject by class.

Uploaded by

Renato Santos
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
116 views1 page

SalaryProcessing - Assignment For Practice

This document provides instructions for processing salary data from multiple sheets into consolidated outputs. It involves taking an input file with 3 sheets of salary data, merging the sheets into a single sheet, calculating total and average values for two categories for each employee, filtering employees into two output files based on which category they scored higher in, and calculating averages for each subject by class.

Uploaded by

Renato Santos
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Salary Processing

Assignment

Assignment1:
1. Take 1 input file with 3 different sheets (same header different data).

Take data as shown below:

Sheet1:

Sheet2:

Sheet3:

a. Merge all above data in one sheet.


b. Calculate PCM_Total, PCM _Average & PCB_Total, PCB_Average of every student.
c. Create two output files, one for PCM and another for PCB.
If student is scoring more marks in PCM grouping then store this record in PCM file else in
PCB file.
[Hint: use ‘filter rows’ step for applying the condition]
d. Also calculate average of each subject of class.

© 2018 AutomationEdge Inc. All Rights Reserved.


This document is for your company’s internal use only and may not be distributed to any third party.

You might also like