Book1 - Employee Sagar Patel Helen Tan priya Patel Yash...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Page 1 CS170 Spreadsheets 1 Section:7 Chocolate Paradise Payroll-Spring 2010 Data for Last Quarter Employee Hours Base Pay Rate Total Base Pay Sales Commission Pay Advances Bonus Total Pay Sagar Patel 345 $30.00 $10,350.00 $387,590.00 $387,590.00 $2,000.00 $798.00 $400,738.00 Helen Tan 564 $30.00 $16,920.00 $345,666.00 $345,666.00 $700.00 $250.00 $363,536.00 priya Patel 534 $30.00 $16,020.00 $324,787.00 $324,787.00 $900.00 $90.00 $341,797.00 Yash Patel 346 $30.00 $10,380.00 $243,343.00 $243,343.00 $2,500.00 $543.00 $256,766.00 Amy Ng 260 $30.00 $7,800.00 $235,666.00 $235,666.00 $2,999.00 $500.00 $246,965.00 Matt Petrol 355 $30.00 $10,650.00 $234,878.00 $234,878.00 $999.00 $79.00 $246,606.00 Divya Sree 354 $30.00 $10,620.00 $234,789.00 $234,789.00 $1,111.00 $600.00 $247,120.00 Trixie Tang 500 $30.00 $15,000.00 $234,754.00 $234,754.00 $500.00 $567.00 $250,821.00 Thomas Smith 444 $49.25 $21,867.00 $145,862.00 $145,862.00 $1,000.00 $900.00 $169,629.00 John Smith 256 $30.00 $7,680.00 $123,987.00 $123,987.00 $2,424.00 $879.00 $134,970.00 Total 3958 $319.25 $127,287.00 $2,511,322.00 #DIV/0! $2,511,322.00 $15,133.00 $5,206.00 $2,658,948.00 Sales Commission $- 0% $10,000.00 1% $20,000.00 2% $40,000.00 3% $75,000.00 4% $100,000.00 5% $200,000.00 10% number of cells with values 12 12 12 12 2 12 12 12 12 number of cells with just text 0 0 0 0 0 0 0 0 0 largest value for each column 564 $49.25 $21,867.00 $387,590.00 0% $387,590.00 $2,999.00 $900.00 $400,738.00 smallest value for each column 256 $30.00 $7,680.00 $123,987.00
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/19/2012 for the course COMP SCI 150 taught by Professor Chan during the Spring '11 term at Aarhus Universitet.

Page1 / 5

Book1 - Employee Sagar Patel Helen Tan priya Patel Yash...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online