HUMAN RESOURC

Number of Employees by Year

120

100

80

60

40

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
0 2 4 6 8 10 12 14 16 18

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

Headcount
Sales
R&D
Marketing
IT
Human Resources
Finance
Customer Support
Administration
Accounting
0 2 4 6 8 10 12 14 16

Payroll Breakdown
Sales
R&D
Marketing
IT Salary
Human Resources Bonus
Finance Overtime
Customer Support
Administration
Accounting
$0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000

Rose Moreno
Richard Garza
Christopher Battah
Margaret Pavlovich
Johnathan A Wilhite
Saif Perrine
Janalee Eggleston
Eric W. Kilbride
Matthew Tait
Shireen Battah
Employee Rose Moreno
Joshua Daniel
Department
Roshan Coon Finance
Joeanne Melendez
Hire Date
Ricardo Bergman 5/9/07
Salary
Willow Nevandro $16,000
Donna K. Bulgar
Bonus
Kelley Reneau $2,080
SaraOvertime
Webb $160
Genevieve Knapp
Sick Days
Ian Helmer 3
Tiffany M Blake
Performance
Saxton Peterson Score 4
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
1
Accounting
Administration
Customer Support
Finance
Human Resources
IT
Sales
 Follow the steps to enable your online Human Resources D
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:
https://www4.spreadsheetweb.com/SpreadSheetWEB/Output.aspx?ApplicationId=8f797910-faec-4989-af55-77228d
>> Using your account, you can upload more Excel applications to the web. You can see tutorials in the lin
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
an Resources Dashboard.
oyee Data" sheet.
e site below:

ed automatically.

7910-faec-4989-af55-77228d02fe4e
can see tutorials in the link below:

link below:
 Year Employee
12/31/2000 2000 6
12/31/2001 2001 21
12/31/2002 2002 26
12/31/2003 2003 40
12/31/2004 2004 47
12/31/2005 2005 57
12/31/2006 2006 68
12/31/2007 2007 83
12/31/2008 2008 96

Department Salary Bonus Overtime Total

Accounting $532,000 $40,040 $28,890 $600,930
Administration $852,000 $84,870 $39,940 $976,810
Customer Support $297,000 $28,670 $12,010 $337,680
Finance $514,000 $42,330 $25,800 $582,130
Human Resources $481,000 $38,870 $12,570 $532,440
IT $885,000 $73,480 $13,170 $971,650
Marketing $594,000 $51,560 $17,720 $663,280
R&D $792,000 $78,950 $27,980 $898,930
Sales $632,000 $308,430 $0 $940,430
 Salary Range Employee Count
0 30000 8 <$30,000 8
30000 40000 22 $30,000-$40,000 14
40000 50000 39 $40,000-$50,000 17
50000 60000 55 $50,000-$60,000 16
60000 70000 71 $60,000-$70,000 16
70000 80000 80 $70,000-$80,000 9
80000 90000 89 $80,000-$90,000 9
90000 100000 91 $90,000-$100,000 2
100000 200000 96 >$100,000 5

Number of Average Total Sick

Employees Salary Days Average Sick Days
10 $53,200 62 6.2
13 $65,538 78 6
5 $59,400 21 4.2
10 $51,400 66 6.6
9 $53,444 50 5.6
14 $63,214 88 6.3
11 $54,000 54 4.9
13 $60,923 117 9
11 $57,455 59 5.4
Full Name Hire Date Salary Bonus Overtime
Rose Moreno 5/9/2007 $16,000 $2,080 $160
Richard Garza 1/16/2003 $25,000 $750 $750
Christopher Battah 5/13/2008 $25,000 $1,500 $750
Margaret Pavlovich 7/20/2007 $26,000 $3,380 $780
Johnathan A Wilhite 6/8/2004 $27,000 $810 $2,160
Saif Perrine 3/1/2006 $27,000 $4,500 $0
Janalee Eggleston 10/21/2001 $28,000 $4,200 $0
Eric W. Kilbride 9/25/2005 $28,000 $3,640 $1,400
Matthew Tait 2/16/2002 $30,000 $3,300 $3,000
Shireen Battah 4/30/2003 $30,000 $1,800 $1,800
Joshua Daniel 3/22/2003 $31,000 $2,790 $310
Roshan Coon 5/1/2007 $31,000 $1,240 $930
Joeanne Melendez 5/4/2001 $32,000 $2,240 $0
Ricardo Bergman 10/26/2007 $32,000 $4,160 $640
Willow Nevandro 10/18/2000 $34,000 $4,420 $2,040
Donna K. Bulgar 8/23/2007 $34,000 $4,080 $3,060
Kelley Reneau 1/9/2006 $35,000 $1,750 $1,050
Sara Webb 10/9/2007 $35,000 $3,500 $2,100
Genevieve Knapp 4/2/2006 $35,000 $26,000 $0
Ian Helmer 12/13/2008 $36,000 $2,520 $1,800
Tiffany M Blake 4/28/2008 $38,000 $1,900 $0
Saxton Peterson 3/15/2008 $39,000 $780 $390
Melissa Torruella 10/19/2005 $40,000 $5,600 $0
Yvette Hurtado 12/14/2003 $40,000 $1,600 $1,600
Benny Melendez 9/28/2008 $41,000 $2,050 $1,640
Steven Bolin 2/2/2002 $42,000 $2,520 $3,780
Brian M Stucki 5/10/2001 $43,000 $4,730 $0
Kelly Queen 1/13/2001 $43,000 $42,000 $0
Jacqueline N. Hildebrand 8/11/2006 $44,000 $1,320 $880
Julia Hegwood 8/24/2000 $45,000 $37,000 $0
William Melendez 5/24/2004 $45,000 $5,850 $4,500
Heela Kraft 12/8/2008 $45,000 $900 $0
Matthew W Yamaguchi 5/20/2005 $46,000 $2,300 $0
Manuel Steele 7/5/2002 $47,000 $2,820 $470
James Wilson 1/3/2002 $48,000 $5,760 $4,800
Bryan Brier 8/1/2004 $48,000 $3,840 $4,320
Rebecca L. Haight 2/14/2005 $48,000 $6,720 $2,400
Rikkie J Mahone 11/27/2003 $48,000 $6,240 $480
Grant Tomasevic 1/29/2008 $48,000 $4,800 $3,360
Alicia A. Elmasian 1/25/2008 $51,000 $6,630 $2,040
Natalie H. Woodford 12/21/2005 $52,000 $1,560 $3,640
Jena Coon 6/28/2007 $53,000 $35,000 $0
Ernest Trent 6/25/2007 $53,000 $5,300 $530
Martie Elmasian 12/7/2000 $54,000 $5,400 $3,780
Cristhian Roth 4/2/2001 $54,000 $1,620 $4,320
Rebecca Negrete 4/27/2004 $54,000 $5,400 $4,860
Michelle Shevlin 2/28/2006 $54,000 $8,100 $1,620
Micah Chokeir 12/21/2001 $55,000 $1,100 $0
Julie Yost 11/7/2003 $57,000 $3,990 $570
Jonathan C. Parnell 12/4/2003 $57,000 $5,130 $3,420
Jeremiah De Grazia 9/8/2000 $58,000 $5,220 $5,220
Stacy L Chen 11/23/2001 $59,000 $8,850 $0
Elena Miriam Hillen 10/22/2001 $59,000 $5,900 $0
Natalie H. Zeidell 10/24/2001 $59,000 $5,310 $590
Alyssa Adefioye 2/11/2007 $59,000 $7,080 $1,180
Kevin Nevandro 8/7/2007 $60,000 $8,400 $0
Cassandra Perry 6/7/2004 $62,000 $8,060 $3,100
Krisaundra Hightower 5/5/2005 $62,000 $8,060 $1,240
Cindy Summerville 6/23/2001 $63,000 $7,560 $4,410
Erik G. Rinehart 11/4/2003 $63,000 $7,560 $0
Ahlam Aby 7/9/2008 $63,000 $3,150 $3,780
Alexis Ripley 12/3/2001 $64,000 $2,560 $0
Michelle Greenwell 10/27/2003 $64,000 $8,320 $5,120
Ricardo Sherrell 11/21/2007 $64,000 $5,760 $0
Matthew H. Rios 9/17/2007 $65,000 $3,900 $0
Laura S Greenwell 4/17/2006 $65,000 $1,300 $1,300
Bryan Anderson 10/6/2001 $66,000 $2,640 $1,320
Marylou M. Diaz 4/16/2007 $66,000 $1,320 $1,980
Joshua Fields 11/14/2007 $67,000 $41,000 $0
Stephen H. Thomas 12/22/2006 $67,000 $8,040 $3,350
Jacqueline N. Gappy 5/29/2003 $68,000 $8,840 $5,440
Corine M. Henderson 8/7/2000 $72,000 $2,880 $6,480
Laura Aguirre 8/4/2005 $72,000 $2,160 $2,880
Rosa I. Peralta 11/19/2004 $73,000 $1,460 $5,110
Harman Abraha 7/21/2003 $74,000 $8,140 $2,220
Jesse Wooten 12/21/2001 $75,000 $9,750 $1,500
Elena Miriam Woodburn 3/9/2005 $76,000 $7,600 $2,280
Gabriel R. Self 2/8/2002 $77,000 $11,550 $0
Micah Talia 11/22/2004 $77,000 $5,390 $0
Benny Erwin 12/3/2003 $77,000 $28,000 $0
James Oberndorfer 4/26/2008 $80,000 $52,000 $0
Ryan Kennedy 12/24/2001 $81,000 $4,860 $0
Julie Harken 12/4/2003 $83,000 $32,000 $0
Tamara Pacheco 3/25/2005 $85,000 $1,700 $0
Ann Sharp 2/2/2006 $85,000 $9,350 $0
Elena Miriam Takahashi 5/6/2006 $85,000 $9,350 $0
Katherine Battah 3/4/2005 $87,000 $7,830 $7,830
John Michael 3/19/2007 $87,000 $13,050 $6,960
Alison Johnson 5/13/2000 $89,000 $8,010 $0
Jessica Rodriguez 3/1/2008 $94,000 $5,640 $0
Joshua Johnson 9/2/2006 $96,000 $4,800 $7,680
Tony Merrick 9/18/2001 $105,000 $15,750 $0
Ernest Talia 9/15/2008 $110,000 $6,600 $5,500
Moriel Caldwell 11/16/2006 $119,000 $10,710 $4,760
Ryan Mesko 10/18/2003 $123,000 $17,220 $4,920
Brian Tomasevic 10/30/2008 $145,000 $15,950 $5,800
 Sick Performance
Department Days Score
Finance 3 4
Administration 8 1
Human Resources 6 2
Finance 8 4
Marketing 9 1
Marketing 7 5
R&D 6 5
Administration 7 4
Customer Support 4 4
Accounting 1 2
Administration 4 3
Human Resources 2 1
R&D 9 2
R&D 8 4
Administration 8 4
IT 5 4
Accounting 7 2
R&D 8 3
Sales 1 3
Marketing 1 2
IT 4 2
Marketing 9 1
Customer Support 7 5
Finance 6 1
Human Resources 9 2
Accounting 9 2
Sales 7 4
Sales 5 5
Finance 6 1
Sales 9 4
Administration 4 4
IT 7 1
Sales 3 2
Human Resources 7 2
Accounting 7 4
Finance 8 3
Accounting 4 5
Marketing 6 4
R&D 7 3
Human Resources 9 4
R&D 11 1
Sales 3 3
Marketing 3 3
Administration 7 3
Administration 8 1
Accounting 6 3
R&D 9 5
IT 9 1
Finance 8 2
Marketing 6 3
Finance 5 3
Human Resources 3 5
IT 7 3
IT 7 3
Customer Support 5 4
Sales 8 5
R&D 9 4
Finance 6 4
IT 9 4
IT 4 4
Accounting 3 2
Administration 3 1
Administration 6 4
IT 4 3
Marketing 4 2
Human Resources 4 1
Accounting 9 1
Marketing 1 1
Sales 8 3
Finance 8 4
Human Resources 4 4
R&D 15 1
Accounting 7 1
IT 8 1
Accounting 9 4
Administration 6 4
R&D 9 3
IT 2 5
R&D 14 2
Sales 5 3
Sales 6 4
Customer Support 4 2
Sales 4 2
IT 6 1
IT 9 4
IT 7 4
Customer Support 1 3
Marketing 6 5
Marketing 2 3
Human Resources 6 2
Finance 8 2
R&D 8 5
Administration 4 2
R&D 4 3
Administration 7 5
Administration 6 4