Learning Excel FCC
Learning Excel FCC
House Worked Overtime hours Pay Overtime Pay total pay Jan Pay
Last Name First Name Hourly Wage 1-Jan 8-Jan 15-Jan 22-Jan 29-Jan 1-Jan 8-Jan 15-Jan 22-Jan 29-Jan 1-Jan 8-Jan 15-Jan 22-Jan 29-Jan 1-Jan 8-Jan 15-Jan 22-Jan 29-Jan 1-Jan 8-Jan 15-Jan 22-Jan 29-Jan
Kern Paul $ 20.00 29 33 33 31 32 0 0 0 0 0 $ 580.00 $ 660.00 $ 660.00 $ 620.00 $ 640.00 $ - $ - $ - $ - $ - $ 580.00 $ 660.00 $ 660.00 $ 620.00 $ 640.00 $ 3,160.00
Howard Brock $ 26.10 30 51 21 34 21 0 11 0 0 0 $ 783.00 $ 1,331.10 $ 548.10 $ 887.40 $ 548.10 $ - $ 143.55 $ - $ - $ - $ 783.00 $ 1,474.65 $ 548.10 $ 887.40 $ 548.10 $ 4,241.25
Donald Nancy $ 17.50 40 23 44 65 43 0 0 4 25 3 $ 700.00 $ 402.50 $ 770.00 $ 1,137.50 $ 752.50 $ - $ - $ 35.00 $ 218.75 $ 26.25 $ 700.00 $ 402.50 $ 805.00 $ 1,356.25 $ 778.75 $ 4,042.50
Smith Deren $ 21.70 50 50 54 87 54 10 10 14 47 14 $ 1,085.00 $ 1,085.00 $ 1,171.80 $ 1,887.90 $ 1,171.80 $ 108.50 $ 108.50 $ 151.90 $ 509.95 $ 151.90 $ 1,193.50 $ 1,193.50 $ 1,323.70 $ 2,397.85 $ 1,323.70 $ 7,432.25
Baker Bill $ 10.80 15 70 55 33 43 0 30 15 0 3 $ 162.00 $ 756.00 $ 594.00 $ 356.40 $ 464.40 $ - $ 162.00 $ 81.00 $ - $ 16.20 $ 162.00 $ 918.00 $ 675.00 $ 356.40 $ 480.60 $ 2,592.00
Young Olivia $ 12.40 33 99 56 21 55 0 59 16 0 15 $ 409.20 $ 1,227.60 $ 694.40 $ 260.40 $ 682.00 $ - $ 365.80 $ 99.20 $ - $ 93.00 $ 409.20 $ 1,593.40 $ 793.60 $ 260.40 $ 775.00 $ 3,831.60
Mann Trent $ 19.20 17 41 65 1 65 0 1 25 0 25 $ 326.40 $ 787.20 $ 1,248.00 $ 19.20 $ 1,248.00 $ - $ 9.60 $ 240.00 $ - $ 240.00 $ 326.40 $ 796.80 $ 1,488.00 $ 19.20 $ 1,488.00 $ 4,118.40
Rim John $ 23.00 15 22 44 33 22 0 0 4 0 0 $ 345.00 $ 506.00 $ 1,012.00 $ 759.00 $ 506.00 $ - $ - $ 46.00 $ - $ - $ 345.00 $ 506.00 $ 1,058.00 $ 759.00 $ 506.00 $ 3,174.00
Diana Rock $ 8.00 70 42 21 34 13 30 2 0 0 0 $ 560.00 $ 336.00 $ 168.00 $ 272.00 $ 104.00 $ 120.00 $ 8.00 $ - $ - $ - $ 680.00 $ 344.00 $ 168.00 $ 272.00 $ 104.00 $ 1,568.00
max $ 26.10 70.0 99.0 65.0 87.0 65.0 $ 1,085.00 $ 1,331.10 $ 1,248.00 $ 1,887.90 $ 1,248.00 $ 120.00 $ 365.80 $ 240.00 $ 509.95 $ 240.00 $ 1,193.50 $ 1,593.40 $ 1,488.00 $ 2,397.85 $ 1,488.00 $ 7,432.25
min $ 8.00 15.0 22.0 21.0 1.0 13.0 $ 162.00 $ 336.00 $ 168.00 $ 19.20 $ 104.00 $ - $ - $ - $ - $ - $ 162.00 $ 344.00 $ 168.00 $ 19.20 $ 104.00 $ 1,568.00
avg. $ 17.63 33.2 47.9 43.7 37.7 38.7 $ 550.07 $ 787.93 $ 762.92 $ 688.87 $ 679.64 $ 25.39 $ 88.61 $ 72.57 $ 80.97 $ 58.59 $ 575.46 $ 876.54 $ 835.49 $ 769.83 $ 738.24 $ 3,795.56
total 299 431 393 339 348 $ 4,950.60 $ 7,091.40 $ 6,866.30 $ 6,199.80 $ 6,116.80 $ 228.50 $ 797.45 $ 653.10 $ 728.70 $ 527.35 $ 5,179.10 $ 7,888.85 $ 7,519.40 $ 6,928.50 $ 6,644.15 $ 34,160.00
Company Philosophy Test
Financial Test
Safety Test
Safety Test
Drug Test
Gradebook
Max. Possibl 10 20 100 1
Last Name First Name
Kern Paul 5 4 66 1 50% 20% 66%
Howard Brock 6 5 45 0 60% 25% 45%
Donald Nancy 7 14 34 1 70% 70% 34%
Smith Deren 3 20 23 1 30% 100% 23%
Baker Bill 2 13 87 1 20% 65% 87%
Young Olivia 4 4 9 1 40% 20% 9%
Mann Trent 7 17 22 0 70% 85% 22%
Rim John 9 16 45 0 90% 80% 45%
Diana Rock 4 10 66 1 40% 50% 66%
Fire Employee?
10
9
Drug Test
8
7
6
5
100% 0% 4
0% 100% 3
100% 0% 2
100% 0% 1
100% 0%
0
100% 100% Paul Brock Nancy Deren Bill Olivia Trent
0% 100%
0% 100%
100% 0%
Company Philosophy Test
100% 25
0%
67% 20
15
10
0
Paul Brock Nancy Deren Bill Olivia Trent
Safety Test
ny Philosophy Test
Last Name
Barns
Hernandez
Smith Barns Johnson
33% 35% Smith
JohnsonHernandez
18% 14%
Month Txn. Number Product Code Product Description Store Cost Sale Price Profit Commision 10%
Mar 1,041 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
April 1,049 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
May 1,062 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
June 1,087 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
June 1,088 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
Jan 1,003 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
Jan 1,016 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
Feb 1,019 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
Feb 1,020 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
May 1,065 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
July 1,101 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
Mar 1,035 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
May 1,064 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
May 1,070 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
June 1,095 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
Feb 1,029 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
Mar 1,036 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
Mar 1,038 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
April 1,057 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
July 1,105 2499 8 ft Hose $ 6.20 $ 9.20 $ 3.00 0.3
Nov 1,162 9212 1 Gal Muratic Acid $ 4.00 $ 7.00 $ 3.00 0.3
Aug 1,126 9212 1 Gal Muratic Acid $ 4.00 $ 7.00 $ 3.00 0.3
Sept 1,148 9212 1 Gal Muratic Acid $ 4.00 $ 7.00 $ 3.00 0.3
Oct 1,157 9212 1 Gal Muratic Acid $ 4.00 $ 7.00 $ 3.00 0.3
Nov 1,163 9212 1 Gal Muratic Acid $ 4.00 $ 7.00 $ 3.00 0.3
Jan 1,013 9212 1 Gal Muratic Acid $ 4.00 $ 7.00 $ 3.00 0.3
June 1,097 9212 1 Gal Muratic Acid $ 4.00 $ 7.00 $ 3.00 0.3
Aug 1,131 9212 1 Gal Muratic Acid $ 4.00 $ 7.00 $ 3.00 0.3
Aug 1,132 9212 1 Gal Muratic Acid $ 4.00 $ 7.00 $ 3.00 0.3
Feb 1,024 9212 1 Gal Muratic Acid $ 4.00 $ 7.00 $ 3.00 0.3
Aug 1,141 9212 1 Gal Muratic Acid $ 4.00 $ 7.00 $ 3.00 0.3
Feb 1,032 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
April 1,050 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
June 1,090 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
Jan 1,008 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
Feb 1,022 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
Mar 1,044 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
May 1,066 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
May 1,067 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
May 1,074 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
June 1,092 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
July 1,099 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
July 1,104 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
Jan 1,015 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
Feb 1,025 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
June 1,091 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
Jan 1,002 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
Jan 1,010 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
Jan 1,011 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
Feb 1,034 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
Mar 1,039 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
May 1,078 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
June 1,079 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
June 1,098 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
July 1,103 2877 Net $ 11.40 $ 16.30 $ 4.90 0.49
Feb 1,027 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
May 1,071 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
June 1,082 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
June 1,083 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
June 1,084 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
July 1,100 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
Jan 1,005 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
Jan 1,009 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
Feb 1,018 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
April 1,051 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
April 1,056 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
April 1,060 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
May 1,061 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
May 1,063 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
May 1,069 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
May 1,072 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
June 1,081 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
June 1,089 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
June 1,094 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
June 1,096 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
Jan 1,007 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
Feb 1,023 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
Feb 1,026 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
April 1,058 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
May 1,075 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
June 1,086 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
July 1,107 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
Feb 1,021 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
Feb 1,031 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
Mar 1,040 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
Mar 1,046 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
April 1,055 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
May 1,068 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
May 1,076 1109 Chlorine Test Kit $ 3.00 $ 8.00 $ 5.00 0.5
June 1,093 6119 Algea Killer 8 oz $ 9.00 $ 14.00 $ 5.00 0.5
April 1,052 6622 5 Gal Chlorine $ 42.00 $ 77.00 $ 35.00 7
May 1,073 6622 5 Gal Chlorine $ 42.00 $ 77.00 $ 35.00 7
July 1,112 6622 5 Gal Chlorine $ 42.00 $ 77.00 $ 35.00 7
July 1,116 6622 5 Gal Chlorine $ 42.00 $ 77.00 $ 35.00 7
Nov 1,159 6622 5 Gal Chlorine $ 42.00 $ 77.00 $ 35.00 7
Mar 1,047 6622 5 Gal Chlorine $ 42.00 $ 77.00 $ 35.00 7
July 1,111 6622 5 Gal Chlorine $ 42.00 $ 77.00 $ 35.00 7
Mar 1,037 6622 5 Gal Chlorine $ 42.00 $ 77.00 $ 35.00 7
Aug 1,128 6622 5 Gal Chlorine $ 42.00 $ 77.00 $ 35.00 7
Jan 1,001 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
July 1,113 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Aug 1,133 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Sept 1,147 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Jan 1,006 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
June 1,085 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
July 1,108 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
July 1,123 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Aug 1,134 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Nov 1,164 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Nov 1,165 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Dec 1,168 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
May 1,077 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Aug 1,129 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Sept 1,143 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Nov 1,160 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Feb 1,033 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
July 1,106 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
July 1,118 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Aug 1,137 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Oct 1,154 9822 Pool Cover $ 58.30 $ 98.40 $ 40.10 8.02
Oct 1,152 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
Dec 1,170 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
Jan 1,012 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
April 1,054 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
June 1,080 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
July 1,121 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
July 1,124 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
Aug 1,139 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
Oct 1,155 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
Aug 1,130 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
Sept 1,145 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
Feb 1,030 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
Aug 1,140 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
Nov 1,161 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
Dec 1,171 4421 Skimmer $ 45.00 $ 87.00 $ 42.00 8.4
April 1,053 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
July 1,119 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
Mar 1,043 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
April 1,059 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
July 1,120 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
Aug 1,125 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
Aug 1,136 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
Oct 1,150 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
Oct 1,156 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
Dec 1,167 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
Sept 1,144 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
Feb 1,017 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
July 1,102 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
July 1,114 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
Sept 1,142 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
Oct 1,151 2242 AutoVac $ 60.00 $ 124.00 $ 64.00 12.8
Jan 1,004 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Jan 1,014 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Feb 1,028 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Mar 1,048 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
July 1,115 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Aug 1,127 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Aug 1,135 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Aug 1,138 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Sept 1,149 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Nov 1,158 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Mar 1,042 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
July 1,122 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Oct 1,153 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Nov 1,166 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Dec 1,169 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Mar 1,045 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
July 1,110 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
July 1,117 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
Sept 1,146 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6
July 1,109 8722 Water Pump $ 344.00 $ 502.00 $ 158.00 31.6