Calculating Total and Averages with awk Commands & Scripts Post: 302895417

Sponsored Content

Homework and Emergencies Homework & Coursework Questions Calculating Total and Averages with awk Commands & Scripts Post 302895417 by RedJohn on Monday 31st of March 2014 04:31:13 PM

03-31-2014

Registered User

Quote:

Originally Posted by Corona688

What is GFS? Did you mean OFS?

Yes, sorry about miswriting.

Quote:

Originally Posted by in2nix4life

Some critiques:

Try putting spaces between your print commands (i.e. print "GRAND TOTAL") and quotes.
The third line in the workers file is missing a department.
The calculations are off using the $6 variable. Since the salary is at the end of the line,
try replacing it with $NF instead.
You have a typo in this line:
END{tot_workers=cus_no+cis_tot+srt_no;

I re-wrote your script and here's my output:

Code:

./company.awk workers.txt
DEPARTMENTS & SALARIES
Department Workers TotalSalary Average
----------------------------------------
CUS             4       6600    1650
CIS             3       4000    1333.33
SRT             3       4600    1533.33
----------------------------------------
GRAND TOTAL     10      15200   1520

Hope this helps.

Thanks mate, I tried your way, and there is no problem. However, I do not understand. What is difference between $6 and $NF?

Last edited by RedJohn; 03-31-2014 at 05:31 PM.. Reason: Miswriting

RedJohn

View Public Profile for RedJohn

Find all posts by RedJohn

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Scripts for calculating size and remaining space of a directory automatically.

I would like to create a script for calculating size and remaining space of a directory automatically every 24 hours, then send an email to report to the admin. * POSIX and PERL are preferred. Can anyone help, please?

2. UNIX for Advanced & Expert Users

Sun: High kernel usage & very high load averages

Hi, I am seeing very high kernel usage and very high load averages on my system (Although we are not loading much data to our database). Here is the output of top...does anyone know what i should be looking at? Thanks, Lorraine last pid: 13144; load averages: 22.32, 19.81, 16.78 ...

3. Emergency UNIX and Linux Support

Calculating total space in GB for all files with typical pattern

Hi Experts, In a particular dir, I have many files *AJAY*. How can I get total size of all such files. I tried du -hs *AJAY* but it gave me individual size of all files. All I require is summation of all. Thanks, Ajay

4. Shell Programming and Scripting

Calculating the epoch time from standard time using awk and calculating the duration

Hi All, I have the following time stamp data in 2 columns Date TimeStamp(also with milliseconds) 05/23/2012 08:30:11.250 05/23/2012 08:30:15.500 05/23/2012 08:31.15.500 . . etc From this data I need the following output. 0.00( row1-row1 in seconds) 04.25( row2-row1 in...

5. Shell Programming and Scripting

Calculating average with awk

I need to find the average from a file like: data => BW:123 M:30 RTD:0 1 0 1 0 0 1 1 1 1 0 0 1 1 0' data => BW:123 N:30 RTD:0 1 0 1 0 0 1 1 1 1 0 0 1 1 0' data => BW:123 N:30 RTD:0 1 0 1 0 0 1 1 1 1 0 0 1 1 0' data => BW:123 N:30 RTD:0 1 0 1 0 0 1 1 1 1 0 0 1 1 0' data => BW:123 N:30 RTD:0 1...

6. Shell Programming and Scripting

Performance of calculating total number of matching records in multiple files

Hello Friends, I've been trying to calculate total number of a certain match in multiple data records files (DRs). Let say I have a daily created folders for each day since the beginning of july like the following drwxrwxrwx 2 mmsuper med 65536 Jul 1 23:59 20150701 drwxrwxrwx 2 mmsuper...

7. Shell Programming and Scripting

Awk- Pivot Table Averages

Hi everyone, Has anyone figured out yet how to do pivot table averages using AWK. I didn't see anything with regards to doing averages. For example, suppose you have the following table with various individuals and their scores in round1 and round2: SAMPLE SCORE1 SCORE2 British ...

8. What is on Your Mind?

OSX 10.14 Mojave Commands - 13K+ Total Man Pages in Repository

Just added OSX 10.14 Mojave Commands (currently over 13K pages in the mojave repo) to our man page repository: OSX 10.14 Mojave Commands We need to update all the man pages to the most current versions, so please contribute man page sets to your favorite OS environment (tar.gz with os and...

9. UNIX for Beginners Questions & Answers

Calculating Total Hours worked

Write a script using a Linux shell programming language to perform clock management for a small daycare. The program should manage all time in and out routines. At the end of the each day should give the Total hours worked that day. Example: Time-In 6:30am Lunch-Out 11 :25am...

LEARN ABOUT ULTRIX

lmfsetup

lmfsetup(8) System Manager's Manual lmfsetup(8)

Name
lmfsetup - License Management Facility PAK registration script

Syntax
/etc/lmfsetup [ template ]

Description
The script allows you to register data supplied by a Product Authorization Key (PAK). The script prompts you for the data associated with
each of the fields on a PAK. When all the data has been entered, the License Management Facility (LMF) ensures there are entries against
all the mandatory fields, and that the Checksum validates all the license data. If the data has been entered correctly, the PAK is regis-
tered in the License Database. If the data has been entered incorrectly, the appropriate error message is displayed and you are given the
opportunity to re-enter the data.

The template option allows you to register license data from templates in A template containing a partially complete PAK is created by some
products as part of their installation process. The script only prompts you for data on the fields that are empty in the template. If the
script cannot find the specified template in it searches the current directory.

The script is provided as an alternative to the command. This displays a template, which includes the fields on the PAK, and invokes an
editor so that you can add the license data to the appropriate field. The command also allows errors to be corrected without having to re-
enter all the data.

See Also
lmf(8)
Guide to Software Licensing

lmfsetup(8)