Sponsored Content
Top Forums Shell Programming and Scripting Calculate the performance of employee Post 303037621 by rohit_shinez on Thursday 8th of August 2019 06:17:11 AM
Old 08-08-2019
Calculate the performance of employee

Hi Guys,

I need to determine the employee performance and calculate their salaries based on each quarter

Expected output
Code:
enter the no. of Employee  2
2
Enter Employee Name sam
Enter salary 1000
Enter Q1 5
Enter Q2 6
Enter Q3 3
Enter Q4 5
Enter Employee Name anderson
Enter salary 5000
Enter Q1 7
Enter Q2 7
Enter Q3 8
Enter Q4 8
EMPNAME | SALARY | Q1 | Q2 | Q3 | Q4 | Avg Q | Expected Sal | Incremented Sal | Performance |
sam 1000 5 6 3 5 4.0 1040.0 40.0 ON TRACK
anderson 5000 7 7 8 8 7.0 5350.0 350.0 BEST

code in python
Code:
def avg_check(q1,q2,q3,q4) :
    sum = q1 + q2 + q3 + q4
    av1 = float(sum / 4)
    return av1
def check_desc(av1) :
    if av1 >= 7 :
           desc="BEST"
    elif av1 <=7 and av1 >=5 :
           desc="AVG"
    else:
           desc="ON TRACK"
    return desc
details=[ ]
n=input("enter the no. of Employee  ")
print n
for i in range(n):
        name=raw_input("Enter Employee Name ")
        salary=input("Enter salary ")
        q1=input("Enter Q1 ")
        q2=input("Enter Q2 ")
        q3=input("Enter Q3 ")
        q4=input("Enter Q4 ")
        av=avg_check(q1,q2,q3,q4)
        inc_salary=float(salary * av / 100)
        exp_salary=float(salary + inc_salary)
        desc=check_desc(av)
        emp=[name,salary,q1,q2,q3,q4,av,exp_salary,inc_salary,desc]
        details.append(emp)
final=sorted(details, key = lambda x: int(x[6]))
print "EMPNAME | SALARY | Q1 | Q2 | Q3 | Q4 | Avg Q | Expected Sal | Incremented Sal | Performance | "
for i in range(len(final)):
    print " ".join(map(str,final[i]))

Can this be done on shell scripting in efficient way with good formatting of header and column
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

bc calculate problem

Hi , this is the first time i use bc to calculate and i would have decimal result , i use the following : toto=400;scale=1 echo $toto / 1000|bc scale to adjust the numbers after the command would have in this case 0.4 as result and i wonder why i have always 0 as result. Somebody can... (2 Replies)
Discussion started by: Nicol
2 Replies

2. Shell Programming and Scripting

calculate output

I was wondering can anyone give me a clue how to start script which would do the following: I have 2 numbers as input for example: 100 and 1000 and I need to create file and in that file should be written 100 - 199 200 - 299 300 - 399 400 - 499 500 - 599 600 - 699 700 - 799... (3 Replies)
Discussion started by: amon
3 Replies

3. News, Links, Events and Announcements

Announcing collectl - new performance linux performance monitor

About 4 years ago I wrote this tool inspired by Rob Urban's collect tool for DEC's Tru64 Unix. What makes this tool as different as collect was in its day is its ability to run at a low overhead and collect tons of stuff. I've expanded the general concept and even include data not available in... (0 Replies)
Discussion started by: MarkSeger
0 Replies

4. Shell Programming and Scripting

calculate the space

Hi everyone, I need to write a script to calculate the space for sub-folders under /home: Here is the scanrio: cd /home drwxr-xr-x 57 root root 8192 Jan 22 16:13 home_1 drwxrwxrwx 69 root root 8192 Jan 29 10:36 home_2 drwxr-xr-x 97 root root 8192 Nov... (8 Replies)
Discussion started by: za_7565
8 Replies

5. Shell Programming and Scripting

How can i calculate percentage ??

i have 3 files like total.dat=18 equal.dat=14 notequal.dat=16 i need find the equal percentange means: equalpercentage = ($equal.dat / $total.dat * 100) How i can do this ? I tried some of the answers to calculate the percentage in this forums.but it couldn't worked.Some one please... (6 Replies)
Discussion started by: bobprabhu
6 Replies

6. Shell Programming and Scripting

How To Calculate

I have 2 variables in my shell scripts in which i am using awk and calculating 2 files and getting 2 different variable called in_total and out_total. I want to subtract one variable from another so plz tell me how i can do that. Example is: cat in_file | awk -F: '{ in_total += $1 * 86400... (3 Replies)
Discussion started by: krishna_sicsr
3 Replies

7. Shell Programming and Scripting

Calculate age of a file | calculate time difference

Hello, I'm trying to create a shell script (#!/bin/sh) which should tell me the age of a file in minutes... I have a process, which delivers me all 15 minutes a new file and I want to have a monitoring script, which sends me an email, if the present file is older than 20 minutes. To do... (10 Replies)
Discussion started by: worm
10 Replies

8. UNIX for Dummies Questions & Answers

Calculate

i have file input abcedef|wert|13|03|10|04|23|A1|13|05|01|09|31 fsdasdf|ferg|12|04|25|21|21|A1|13|02|26|20|31 dfsfsad|gerg|12|04|25|21|21|A1|13|02|25|25|31 i expect the output abcedef|wert|13|03|10|04|23|A1|13|05|01|09|31|9.516666667... (5 Replies)
Discussion started by: radius
5 Replies

9. Shell Programming and Scripting

Employee records

If there are 2 records for an Employee, How can I choose the one with eff_status = ‘Active' and ignore the eff_status ='Terminated'. if there is only one record, then just write that record regardless of the eff_status. Please assist. (1 Reply)
Discussion started by: Harimalyala
1 Replies
answer(1)						      General Commands Manual							 answer(1)

NAME
answer - phone message transcription system SYNOPSIS
DESCRIPTION
The interactive program helps you to transcribe telephone (and other) messages into electronic mail. The program uses your personal alias database and the system alias database, allowing you to use aliases to address the messages. Options supports the following options: Prompt for phone-slip-type message fields. Allow addresses that are not aliases. Operation begins with the prompt. Enter a one-word alias or a two-word user name ("Words" are separated by spaces.) The user name is converted to an alias in the form where f is the first character of the first word, lastword is the second word, and all letters are shifted to lower- case. For example, is converted to the alias Without the option, the specified or converted alias must exist in the alias databases. With the option, if the processed "alias" is not in the alias databases, it is used for the address as is. The fully expanded address is displayed. With the option, you are asked for typical message slip data: Enter the appropriate data. You can put just an or nothing after the pertinent dash prompts, or you can type longer comments. Whatever you enter becomes part of the message. Lines with no added text are omitted from the message. Finally, you are prompted for a message. Enter a message, if any, ending with a blank line. The message is sent and the prompt is repeated. To end the program, enter any one of or at the prompt. EXAMPLES
User input is in normal type. With No Options This example shows a valid alias, an invalid user name, and a valid user name. In the invalid case, the converted alias is displayed in square brackets. With the -u Option If you enter the previous error is treated differently. With the -p Option If you enter the phone-slip prompts are added. The three lines with no added text are deleted from the message. FILES
User alias database data table User alias database directory table User alias database hash table User alias source text System alias database data table System alias database directory table System alias database hash table System alias source text Outbound mail message edit buffer AUTHOR
was developed by HP. SEE ALSO
elm(1), newalias(1). answer(1)
All times are GMT -4. The time now is 07:57 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy