HUMAN RESOURCES

Number of Employees by Year

120
100

Marketing

80
Human Resources

60
40

Customer Support
Administration
Accounting

20
0
2000

2001

2002

2003

2004

2005

2006

2007

2008

Number of Employees by Salary

>$100,000
$90,000-$100,000
$80,000-$90,000
$70,000-$80,000
$60,000-$70,000
$50,000-$60,000
$40,000-$50,000
$30,000-$40,000
<$30,000

Marketing
Human Resources
Customer Support
Administration
Accounting
0

10

Salary Distribution
$160,000
$140,000
$120,000
$100,000
$80,000
$60,000
$40,000
$20,000
$0

15

20

ESOURCES
Headcount
Sales
R&D
Marketing
IT
Human Resources
Finance
Customer Support
Administration
Accounting
0

10

15

Payroll Breakdown
Sales
R&D
Marketing
IT
Human Resources
Finance
Customer Support
Administration
Accounting

Salary
Bonus
Overtime

$0

$500,000

Employee
Department
Hire Date
Salary
Bonus
Overtime
Sick Days
Performance Score

$1,000,000

$1,500,000

Ryan Kennedy
Customer Support
12/24/01
$81,000
$4,860
$0
4
2

Accounting
Administration
Customer Support
Finance
Human Resources
IT
Sales

82

Follow the steps to enable your online Human Resources Dashboard.

1)

This is a HR Dashboard for a sample data. You can enter your data in "Employee Data" sheet.

2)

Your HR Dashboard is ready to use. Further steps for online use. First visit the site below:
http://www.spreadsheetweb.com/getting_started.htm
Ignore the downloaded software, you will only need the username and password.

3)

Visit the site below and login with your new account:
https://www4.spreadsheetweb.com/SpreadsheetWEB//

4)

Click "Add Web Application" to upload this file. Your dashboard will be created automatically.
You can simply use the dashboard from that link or place it on your website.

>>

Your online tracker will look like:

>>

Using your account, you can upload more Excel applications to the web. You can see tutorials in the link below:

https://www4.spreadsheetweb.com/SpreadSheetWEB/Output.aspx?ApplicationId=8f797910-faec-4989-af55-77228d02fe
http://www.spreadsheetweb.com/tutorials.htm
>>

In order to see more online applications created with PSW you can check the link below:
http://www.spreadsheetweb.com/demos.htm

aec-4989-af55-77228d02fe4e

Full Name
Rose Moreno
Richard Garza
Christopher Battah
Margaret Pavlovich
Johnathan A Wilhite
Saif Perrine
Janalee Eggleston
Eric W. Kilbride
Matthew Tait
Shireen Battah
Joshua Daniel
Roshan Coon
Joeanne Melendez
Ricardo Bergman
Willow Nevandro
Donna K. Bulgar
Kelley Reneau
Sara Webb
Genevieve Knapp
Ian Helmer
Tiffany M Blake
Saxton Peterson
Melissa Torruella
Yvette Hurtado
Benny Melendez
Steven Bolin
Brian M Stucki
Kelly Queen
Jacqueline N. Hildebrand
Julia Hegwood
William Melendez
Heela Kraft
Matthew W Yamaguchi
Manuel Steele
James Wilson
Bryan Brier
Rebecca L. Haight
Rikkie J Mahone
Grant Tomasevic
Alicia A. Elmasian
Natalie H. Woodford
Jena Coon
Ernest Trent
Martie Elmasian

Hire Date
5/9/2007
1/16/2003
5/13/2008
7/20/2007
6/8/2004
3/1/2006
10/21/2001
9/25/2005
2/16/2002
4/30/2003
3/22/2003
5/1/2007
5/4/2001
10/26/2007
10/18/2000
8/23/2007
1/9/2006
10/9/2007
4/2/2006
12/13/2008
4/28/2008
3/15/2008
10/19/2005
12/14/2003
9/28/2008
2/2/2002
5/10/2001
1/13/2001
8/11/2006
8/24/2000
5/24/2004
12/8/2008
5/20/2005
7/5/2002
1/3/2002
8/1/2004
2/14/2005
11/27/2003
1/29/2008
1/25/2008
12/21/2005
6/28/2007
6/25/2007
12/7/2000

Salary
$16,000
$25,000
$25,000
$26,000
$27,000
$27,000
$28,000
$28,000
$30,000
$30,000
$31,000
$31,000
$32,000
$32,000
$34,000
$34,000
$35,000
$35,000
$35,000
$36,000
$38,000
$39,000
$40,000
$40,000
$41,000
$42,000
$43,000
$43,000
$44,000
$45,000
$45,000
$45,000
$46,000
$47,000
$48,000
$48,000
$48,000
$48,000
$48,000
$51,000
$52,000
$53,000
$53,000
$54,000

Bonus Overtime Department

$2,080
$160 Finance
$750
$750 Administration
$1,500
$750 Human Resources
$3,380
$780 Finance
$810
$2,160 Marketing
$4,500
$0 Marketing
$4,200
$0 R&D
$3,640
$1,400 Administration
$3,300
$3,000 Customer Support
$1,800
$1,800 Accounting
$2,790
$310 Administration
$1,240
$930 Human Resources
$2,240
$0 R&D
$4,160
$640 R&D
$4,420
$2,040 Administration
$4,080
$3,060 IT
$1,750
$1,050 Accounting
$3,500
$2,100 R&D
$26,000
$0 Sales
$2,520
$1,800 Marketing
$1,900
$0 IT
$780
$390 Marketing
$5,600
$0 Customer Support
$1,600
$1,600 Finance
$2,050
$1,640 Human Resources
$2,520
$3,780 Accounting
$4,730
$0 Sales
$42,000
$0 Sales
$1,320
$880 Finance
$37,000
$0 Sales
$5,850
$4,500 Administration
$900
$0 IT
$2,300
$0 Sales
$2,820
$470 Human Resources
$5,760
$4,800 Accounting
$3,840
$4,320 Finance
$6,720
$2,400 Accounting
$6,240
$480 Marketing
$4,800
$3,360 R&D
$6,630
$2,040 Human Resources
$1,560
$3,640 R&D
$35,000
$0 Sales
$5,300
$530 Marketing
$5,400
$3,780 Administration

Sick Days
3
8
6
8
9
7
6
7
4
1
4
2
9
8
8
5
7
8
1
1
4
9
7
6
9
9
7
5
6
9
4
7
3
7
7
8
4
6
7
9
11
3
3
7

Cristhian Roth
Rebecca Negrete
Michelle Shevlin
Micah Chokeir
Julie Yost
Jonathan C. Parnell
Jeremiah De Grazia
Stacy L Chen
Elena Miriam Hillen
Natalie H. Zeidell
Alyssa Adefioye
Kevin Nevandro
Cassandra Perry
Krisaundra Hightower
Cindy Summerville
Erik G. Rinehart
Ahlam Aby
Alexis Ripley
Michelle Greenwell
Ricardo Sherrell
Matthew H. Rios
Laura S Greenwell
Bryan Anderson
Marylou M. Diaz
Joshua Fields
Stephen H. Thomas
Jacqueline N. Gappy
Corine M. Henderson
Laura Aguirre
Rosa I. Peralta
Harman Abraha
Jesse Wooten
Elena Miriam Woodburn
Gabriel R. Self
Micah Talia
Benny Erwin
James Oberndorfer
Ryan Kennedy
Julie Harken
Tamara Pacheco
Ann Sharp
Elena Miriam Takahashi
Katherine Battah
John Michael
Alison Johnson
Jessica Rodriguez
Joshua Johnson

4/2/2001
4/27/2004
2/28/2006
12/21/2001
11/7/2003
12/4/2003
9/8/2000
11/23/2001
10/22/2001
10/24/2001
2/11/2007
8/7/2007
6/7/2004
5/5/2005
6/23/2001
11/4/2003
7/9/2008
12/3/2001
10/27/2003
11/21/2007
9/17/2007
4/17/2006
10/6/2001
4/16/2007
11/14/2007
12/22/2006
5/29/2003
8/7/2000
8/4/2005
11/19/2004
7/21/2003
12/21/2001
3/9/2005
2/8/2002
11/22/2004
12/3/2003
4/26/2008
12/24/2001
12/4/2003
3/25/2005
2/2/2006
5/6/2006
3/4/2005
3/19/2007
5/13/2000
3/1/2008
9/2/2006

$54,000
$54,000
$54,000
$55,000
$57,000
$57,000
$58,000
$59,000
$59,000
$59,000
$59,000
$60,000
$62,000
$62,000
$63,000
$63,000
$63,000
$64,000
$64,000
$64,000
$65,000
$65,000
$66,000
$66,000
$67,000
$67,000
$68,000
$72,000
$72,000
$73,000
$74,000
$75,000
$76,000
$77,000
$77,000
$77,000
$80,000
$81,000
$83,000
$85,000
$85,000
$85,000
$87,000
$87,000
$89,000
$94,000
$96,000

$1,620
$5,400
$8,100
$1,100
$3,990
$5,130
$5,220
$8,850
$5,900
$5,310
$7,080
$8,400
$8,060
$8,060
$7,560
$7,560
$3,150
$2,560
$8,320
$5,760
$3,900
$1,300
$2,640
$1,320
$41,000
$8,040
$8,840
$2,880
$2,160
$1,460
$8,140
$9,750
$7,600
$11,550
$5,390
$28,000
$52,000
$4,860
$32,000
$1,700
$9,350
$9,350
$7,830
$13,050
$8,010
$5,640
$4,800

$4,320
$4,860
$1,620
$0
$570
$3,420
$5,220
$0
$0
$590
$1,180
$0
$3,100
$1,240
$4,410
$0
$3,780
$0
$5,120
$0
$0
$1,300
$1,320
$1,980
$0
$3,350
$5,440
$6,480
$2,880
$5,110
$2,220
$1,500
$2,280
$0
$0
$0
$0
$0
$0
$0
$0
$0
$7,830
$6,960
$0
$0
$7,680

Administration
Accounting
R&D
IT
Finance
Marketing
Finance
Human Resources
IT
IT
Customer Support
Sales
R&D
Finance
IT
IT
Accounting
Administration
Administration
IT
Marketing
Human Resources
Accounting
Marketing
Sales
Finance
Human Resources
R&D
Accounting
IT
Accounting
Administration
R&D
IT
R&D
Sales
Sales
Customer Support
Sales
IT
IT
IT
Customer Support
Marketing
Marketing
Human Resources
Finance

8
6
9
9
8
6
5
3
7
7
5
8
9
6
9
4
3
3
6
4
4
4
9
1
8
8
4
15
7
8
9
6
9
2
14
5
6
4
4
6
9
7
1
6
2
6
8

Tony Merrick
Ernest Talia
Moriel Caldwell
Ryan Mesko
Brian Tomasevic

9/18/2001
9/15/2008
11/16/2006
10/18/2003
10/30/2008

$105,000
$110,000
$119,000
$123,000
$145,000

$15,750
$6,600
$10,710
$17,220
$15,950

$0
$5,500
$4,760
$4,920
$5,800

R&D
Administration
R&D
Administration
Administration

8
4
4
7
6

Performance
Score
4
1
2
4
1
5
5
4
4
2
3
1
2
4
4
4
2
3
3
2
2
1
5
1
2
2
4
5
1
4
4
1
2
2
4
3
5
4
3
4
1
3
3
3

1
3
5
1
2
3
3
5
3
3
4
5
4
4
4
4
2
1
4
3
2
1
1
1
3
4
4
1
1
1
4
4
3
5
2
3
4
2
2
1
4
4
3
5
3
2
2

5
2
3
5
4

Year
12/31/2000
12/31/2001
12/31/2002
12/31/2003
12/31/2004
12/31/2005
12/31/2006
12/31/2007
12/31/2008

Department
Accounting
Administration
Customer Support
Finance
Human Resources
IT
Marketing
R&D
Sales

Employee
2000
2001
2002
2003
2004
2005
2006
2007
2008

6
21
26
40
47
57
68
83
96

Salary
Bonus
Overtime
Total
$532,000
$40,040
$28,890
$600,930
$852,000
$84,870
$39,940
$976,810
$297,000
$28,670
$12,010
$337,680
$514,000
$42,330
$25,800
$582,130
$481,000
$38,870
$12,570
$532,440
$885,000
$73,480
$13,170
$971,650
$594,000
$51,560
$17,720
$663,280
$792,000
$78,950
$27,980
$898,930
$632,000
$308,430
$0
$940,430

0
30000
40000
50000
60000
70000
80000
90000
100000

Number of
Employees
10
13
5
10
9
14
11
13
11

30000
40000
50000
60000
70000
80000
90000
100000
200000

Average
Salary
$53,200
$65,538
$59,400
$51,400
$53,444
$63,214
$54,000
$60,923
$57,455

8
22
39
55
71
80
89
91
96

Salary Range
Employee Count
<$30,000
8
$30,000-$40,000
14
$40,000-$50,000
17
$50,000-$60,000
16
$60,000-$70,000
16
$70,000-$80,000
9
$80,000-$90,000
9
$90,000-$100,000
2
>$100,000
5

Total Sick
Days
Average Sick Days
62
6.2
78
6
21
4.2
66
6.6
50
5.6
88
6.3
54
4.9
117
9
59
5.4