Excel
CHernandez123
SC_EX16_8b_ChristianHernandez_1.xlsxDocumentation
| Shelly Cashman Excel 2016 | Module 8: SAM Project 1b | |
| Galanos & Company | |
| WORKING WITH TRENDLINES, PIVOTTABLES, PIVOTCHARTS, AND SLICERS | |
| Author: | Christian Hernandez |
| Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. | |
2020 Project Totals
| Galanos & Company | ||||
| Construction and Renovation Projects | ||||
| Project Type | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 |
| All | $ 74,150.00 | $ 98,445.00 | $ 121,630.00 | $ 140,290.00 |
| Commercial | $ 41,570.00 | $ 52,915.00 | $ 61,490.00 | $ 66,610.00 |
Commercial Chart - Trend
Commercial Projects 2020
Commercial Quarter 1 Quarter 2 Quarter 3 Quarter 4 41570 52915 61490 66610
2020 Project Size Chart
Galanos & Company
Total Sales by Project Size
2020
Average Base Cost L M S 1057.1428571428571 3120 591.42857142857144 Quarter 1 L M S 45450 3120 25580 Quarter 2 L M S 54225 6240 37980 Quarter 3 L M S 69900 6240 45490 Quarter 4 L M S 80700 7360 52230
PROJECT Size
Dollars (U.S)
2020 Project Sales
| Galanos & Company | |||||||
| Sales by Project Type | |||||||
| Project ID | Project Type | Crew Size | Base Cost | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 |
| R101 | Exterior | S | $ 2,100.00 | $ 3,600.00 | $ 4,000.00 | $ 3,900.00 | $ 5,200.00 |
| R102 | Exterior | L | $ 4,150.00 | $ 5,300.00 | $ 5,600.00 | $ 5,450.00 | $ 4,450.00 |
| R103 | Exterior | M | $ 3,120.00 | $ 3,120.00 | $ 6,240.00 | $ 6,240.00 | $ 7,360.00 |
| C101 | Interior | S | $ 500.00 | $ 1,500.00 | $ 2,800.00 | $ 4,200.00 | $ 4,100.00 |
| C102 | Interior | L | $ 625.00 | $ 3,275.00 | $ 3,550.00 | $ 4,400.00 | $ 4,250.00 |
| C103 | Office | S | $ 300.00 | $ 600.00 | $ 1,500.00 | $ 1,800.00 | $ 1,800.00 |
| C104 | Office | M | $ 550.00 | $ 4,250.00 | $ 5,250.00 | $ 5,750.00 | $ 5,500.00 |
| R105 | Interior | S | $ 250.00 | $ 4,000.00 | $ 4,000.00 | $ 5,250.00 | $ 7,000.00 |
| R106 | Interior | L | $ 350.00 | $ 5,750.00 | $ 7,400.00 | $ 8,750.00 | $ 8,850.00 |
| R106 | Room | S | $ 200.00 | $ 400.00 | $ 800.00 | $ 2,400.00 | $ 3,600.00 |
| R107 | Room | L | $ 325.00 | $ 1,975.00 | $ 2,975.00 | $ 3,650.00 | $ 3,650.00 |
| R108 | Kitchen | M | $ 550.00 | $ 7,800.00 | $ 8,800.00 | $ 9,700.00 | $ 10,850.00 |
| R109 | Kitchen | L | $ 1,000.00 | $ 15,700.00 | $ 18,850.00 | $ 20,500.00 | $ 23,800.00 |
| R110 | Bath | S | $ 240.00 | $ 7,680.00 | $ 16,080.00 | $ 18,240.00 | $ 19,680.00 |
| R111 | Bath | M | $ 700.00 | $ 9,200.00 | $ 10,600.00 | $ 21,400.00 | $ 30,200.00 |
| Total | $ 74,150.00 | $ 98,445.00 | $ 121,630.00 | $ 140,290.00 | |||
2020 Customers
| Galanos & Company | |||||||
| 2020 Customers | |||||||
| Customer ID | Days | Project ID | Project Type | Crew Size | Season | Location | Base Cost |
| ACOSTNS | 1 | R103 | Exterior | M | Summer-Fall | North | $ 3,120.00 |
| ALLENIT | 4 | C104 | Office | M | Summer-Fall | East | $ 550.00 |
| ALLENIT | 4 | R101 | Exterior | S | Summer-Fall | East | $ 2,100.00 |
| BEANGB | 2 | C103 | Office | S | Summer-Fall | Northeast | $ 300.00 |
| BELDEMD | 2 | R105 | Interior | S | Summer-Fall | North | $ 250.00 |
| BELLSMP | 3 | R106 | Interior | L | Summer-Fall | North | $ 350.00 |
| BYRDMZ | 4 | R101 | Exterior | S | Summer-Fall | Southeast | $ 2,100.00 |
| BYRDMZ | 9 | R101 | Exterior | S | Summer-Fall | Southeast | $ 2,100.00 |
| CAMPBOX | 7 | R110 | Bath | S | Summer-Fall | North | $ 240.00 |
| CERVALV | 2 | R102 | Exterior | L | Summer-Fall | Northwest | $ 4,150.00 |
| CORDOYM | 2 | R103 | Exterior | M | Summer-Fall | North | $ 3,120.00 |
| CORDOYM | 9 | R103 | Exterior | M | Summer-Fall | North | $ 3,120.00 |
| CROSTEO | 6 | C101 | Interior | S | Summer-Fall | East | $ 500.00 |
| CUEVAJV | 8 | R105 | Interior | S | Summer-Fall | East | $ 250.00 |
| CUEVAJV | 9 | R103 | Exterior | M | Summer-Fall | East | $ 3,120.00 |
| EVANSDT | 1 | R111 | Bath | M | Summer-Fall | Northwest | $ 700.00 |
| FARREFC | 5 | R103 | Exterior | M | Summer-Fall | South | $ 3,120.00 |
| FREEMDB | 6 | R109 | Kitchen | L | Summer-Fall | Northwest | $ 1,000.00 |
| FREEMXG | 4 | R105 | Interior | S | Summer-Fall | West | $ 250.00 |
| GILLEE | 2 | R108 | Kitchen | M | Summer-Fall | East | $ 550.00 |
| GRIGGKH | 4 | C104 | Office | M | Summer-Fall | East | $ 550.00 |
| HUMPHJA | 8 | R101 | Exterior | S | Summer-Fall | Northwest | $ 2,100.00 |
| JENFOVD | 1 | C103 | Office | S | Summer-Fall | West | $ 300.00 |
| KERNEYJ | 10 | R108 | Kitchen | M | Summer-Fall | East | $ 550.00 |
| KERRYJN | 6 | R109 | Kitchen | L | Summer-Fall | East | $ 1,000.00 |
| KERRYJN | 1 | R108 | Kitchen | M | Summer-Fall | East | $ 550.00 |
| KERRYJN | 2 | R102 | Exterior | L | Summer-Fall | North | $ 4,150.00 |
| LLOYDUV | 7 | R105 | Interior | S | Summer-Fall | West | $ 250.00 |
| LUTZRI | 1 | R101 | Exterior | S | Summer-Fall | Southeast | $ 2,100.00 |
| MADDOUR | 2 | R102 | Exterior | L | Summer-Fall | Southwest | $ 4,150.00 |
| MARSDAN | 3 | R106 | Interior | L | Summer-Fall | North | $ 350.00 |
| MAYWY | 7 | R105 | Interior | S | Summer-Fall | West | $ 250.00 |
| MCFAROL | 1 | R101 | Exterior | S | Summer-Fall | West | $ 2,100.00 |
| MCFAROL | 6 | C101 | Interior | S | Summer-Fall | West | $ 500.00 |
| MCCOLL | 3 | R107 | Room | L | Summer-Fall | South | $ 325.00 |
| MCKEEOP | 6 | R101 | Exterior | S | Summer-Fall | East | $ 2,100.00 |
| MEZALP | 8 | R103 | Exterior | M | Summer-Fall | Southeast | $ 3,120.00 |
| MEZALP | 1 | R101 | Exterior | S | Summer-Fall | Southeast | $ 2,100.00 |
| MUELLCM | 9 | R102 | Exterior | L | Summer-Fall | North | $ 4,150.00 |
| MUELLER | 1 | R110 | Bath | S | Summer-Fall | East | $ 240.00 |
| NAWRENY | 1 | R103 | Exterior | M | Summer-Fall | North | $ 3,120.00 |
| PRUITIO | 7 | R102 | Exterior | L | Summer-Fall | Southwest | $ 4,150.00 |
| RITTEDK | 3 | R101 | Exterior | S | Summer-Fall | Northwest | $ 2,100.00 |
| ROTHFK | 4 | R101 | Exterior | S | Summer-Fall | East | $ 2,100.00 |
| SERRACS | 10 | R102 | Exterior | L | Summer-Fall | West | $ 4,150.00 |
| SERREOO | 3 | R106 | Interior | L | Summer-Fall | Northeast | $ 350.00 |
| SIMMOAB | 8 | R102 | Exterior | L | Summer-Fall | North | $ 4,150.00 |
| SNOWEJ | 2 | R102 | Exterior | L | Summer-Fall | North | $ 4,150.00 |
| STOKEIK | 6 | C102 | Interior | L | Summer-Fall | West | $ 625.00 |
| TALLPN | 3 | R101 | Exterior | S | Summer-Fall | Northeast | $ 2,100.00 |
| TANNLE | 6 | R101 | Exterior | S | Summer-Fall | West | $ 2,100.00 |
| TRANHJ | 1 | R101 | Exterior | S | Summer-Fall | Northwest | $ 2,100.00 |
| TRANHJ | 1 | R110 | Bath | S | Summer-Fall | East | $ 240.00 |
| WAYNEJA | 7 | R101 | Exterior | S | Summer-Fall | West | $ 2,100.00 |
| WERRIJA | 9 | R109 | Kitchen | L | Summer-Fall | Southwest | $ 1,000.00 |
| WONGKD | 10 | R108 | Kitchen | M | Summer-Fall | South | $ 550.00 |
| ALLENIT | 8 | R106 | Interior | L | Winter-Spring | East | $ 350.00 |
| ALLENIT | 6 | C103 | Office | S | Winter-Spring | East | $ 300.00 |
| BENJANQ | 3 | R105 | Interior | S | Winter-Spring | South | $ 250.00 |
| COMBSMC | 3 | R101 | Exterior | S | Winter-Spring | West | $ 2,100.00 |
| DAWSODL | 7 | R102 | Exterior | L | Winter-Spring | Southeast | $ 4,150.00 |
| FEWSODL | 5 | R111 | Bath | M | Winter-Spring | West | $ 700.00 |
| GARZATK | 10 | C102 | Interior | L | Winter-Spring | South | $ 625.00 |
| HUBBACD | 6 | R106 | Interior | L | Winter-Spring | Northeast | $ 350.00 |
| HUBERSZ | 3 | C101 | Interior | S | Winter-Spring | West | $ 500.00 |
| JUARELM | 9 | R110 | Bath | S | Winter-Spring | East | $ 240.00 |
| MANNPN | 7 | R107 | Room | L | Winter-Spring | West | $ 325.00 |
| MARSHDN | 9 | R107 | Room | L | Winter-Spring | East | $ 325.00 |
| SANTIDP | 8 | R107 | Room | L | Winter-Spring | West | $ 325.00 |
| STAFFLK | 5 | R106 | Interior | L | Winter-Spring | South | $ 350.00 |
| STAFFLK | 4 | R109 | Kitchen | L | Winter-Spring | South | $ 1,000.00 |
| TERKSKF | 2 | R110 | Bath | S | Winter-Spring | West | $ 240.00 |
| TODDNZ | 2 | R106 | Interior | L | Winter-Spring | Northwest | $ 350.00 |
| UNDERES | 1 | C102 | Interior | L | Winter-Spring | East | $ 625.00 |
| UNDERES | 3 | R110 | Bath | S | Winter-Spring | West | $ 240.00 |
| WELCHEB | 2 | R102 | Exterior | L | Winter-Spring | West | $ 4,150.00 |
| WODGECM | 5 | R105 | Interior | S | Winter-Spring | East | $ 250.00 |
Location Report
| Projects by Location | Season | |||
| Location | Project Type | Summer-Fall | Winter-Spring | Grand Total |
| East | Bath | 640 | 240 | 880 |
| Exterior | 9,420 | 9,420 | ||
| Interior | 750 | 1,225 | 1,975 | |
| Kitchen | 2,650 | 2,650 | ||
| Office | 1,100 | 300 | 1,400 | |
| Room | 325 | 325 | ||
| North | Bath | 240 | 240 | |
| Exterior | 29,080 | 29,080 | ||
| Interior | 950 | 950 | ||
| Northeast | Exterior | 2,100 | 2,100 | |
| Interior | 350 | 350 | 700 | |
| Office | 300 | 300 | ||
| Northwest | Bath | 400 | 400 | |
| Exterior | 10,450 | 10,450 | ||
| Interior | 350 | 350 | ||
| Kitchen | 1,000 | 1,000 | ||
| South | Exterior | 3,120 | 3,120 | |
| Interior | 1,225 | 1,225 | ||
| Kitchen | 550 | 1,000 | 1,550 | |
| Room | 325 | 325 | ||
| Southeast | Exterior | 11,520 | 4,150 | 15,670 |
| Southwest | Exterior | 8,300 | 8,300 | |
| Kitchen | 1,000 | 1,000 | ||
| West | Bath | 880 | 880 | |
| Exterior | 10,450 | 6,250 | 16,700 | |
| Interior | 1,875 | 500 | 2,375 | |
| Office | 300 | 300 | ||
| Room | 650 | 650 | ||
| Grand Total | 96,870 | 17,445 | 114,315 |
Sales Total Report
| Customers | Total Days | Total Base Cost |
| ACOSTNS | 1 | $3,120 |
| Exterior | 1 | $3,120 |
| ALLENIT | 22 | $3,300 |
| Exterior | 4 | $2,100 |
| Interior | 8 | $350 |
| Office | 10 | $850 |
| BEANGB | 2 | $300 |
| Office | 2 | $300 |
| BELDEMD | 2 | $250 |
| Interior | 2 | $250 |
| BELLSMP | 3 | $350 |
| Interior | 3 | $350 |
| BYRDMZ | 13 | $4,200 |
| Exterior | 13 | $4,200 |
| CAMPBOX | 7 | $240 |
| Bath | 7 | $240 |
| CERVALV | 2 | $4,150 |
| Exterior | 2 | $4,150 |
| CORDOYM | 11 | $6,240 |
| Exterior | 11 | $6,240 |
| CROSTEO | 6 | $500 |
| Interior | 6 | $500 |
| CUEVAJV | 17 | $3,370 |
| Exterior | 9 | $3,120 |
| Interior | 8 | $250 |
| EVANSDT | 1 | $400 |
| Bath | 1 | $400 |
| FARREFC | 5 | $3,120 |
| Exterior | 5 | $3,120 |
| FREEMDB | 6 | $1,000 |
| Kitchen | 6 | $1,000 |
| FREEMXG | 4 | $250 |
| Interior | 4 | $250 |
| GILLEE | 2 | $550 |
| Kitchen | 2 | $550 |
| GRIGGKH | 4 | $550 |
| Office | 4 | $550 |
| HUMPHJA | 8 | $2,100 |
| Exterior | 8 | $2,100 |
| JENFOVD | 1 | $300 |
| Office | 1 | $300 |
| KERNEYJ | 10 | $550 |
| Kitchen | 10 | $550 |
| KERRYJN | 9 | $5,700 |
| Exterior | 2 | $4,150 |
| Kitchen | 7 | $1,550 |
| LLOYDUV | 7 | $250 |
| Interior | 7 | $250 |
| LUTZRI | 1 | $2,100 |
| Exterior | 1 | $2,100 |
| MADDOUR | 2 | $4,150 |
| Exterior | 2 | $4,150 |
| MARSDAN | 3 | $350 |
| Interior | 3 | $350 |
| MAYWY | 7 | $250 |
| Interior | 7 | $250 |
| MCFAROL | 7 | $2,600 |
| Exterior | 1 | $2,100 |
| Interior | 6 | $500 |
| MCCOLL | 3 | $325 |
| Room | 3 | $325 |
| MCKEEOP | 6 | $2,100 |
| Exterior | 6 | $2,100 |
| MEZALP | 9 | $5,220 |
| Exterior | 9 | $5,220 |
| MUELLCM | 9 | $4,150 |
| Exterior | 9 | $4,150 |
| MUELLER | 1 | $400 |
| Bath | 1 | $400 |
| NAWRENY | 1 | $3,120 |
| Exterior | 1 | $3,120 |
| PRUITIO | 7 | $4,150 |
| Exterior | 7 | $4,150 |
| RITTEDK | 3 | $2,100 |
| Exterior | 3 | $2,100 |
| ROTHFK | 4 | $2,100 |
| Exterior | 4 | $2,100 |
| SERRACS | 10 | $4,150 |
| Exterior | 10 | $4,150 |
| SERREOO | 3 | $350 |
| Interior | 3 | $350 |
| SIMMOAB | 8 | $4,150 |
| Exterior | 8 | $4,150 |
| SNOWEJ | 2 | $4,150 |
| Exterior | 2 | $4,150 |
| STOKEIK | 6 | $625 |
| Interior | 6 | $625 |
| TALLPN | 3 | $2,100 |
| Exterior | 3 | $2,100 |
| TANNLE | 6 | $2,100 |
| Exterior | 6 | $2,100 |
| TRANHJ | 2 | $2,340 |
| Bath | 1 | $240 |
| Exterior | 1 | $2,100 |
| WAYNEJA | 7 | $2,100 |
| Exterior | 7 | $2,100 |
| WERRIJA | 9 | $1,000 |
| Kitchen | 9 | $1,000 |
| WONGKD | 10 | $550 |
| Kitchen | 10 | $550 |
| BENJANQ | 3 | $250 |
| Interior | 3 | $250 |
| COMBSMC | 3 | $2,100 |
| Exterior | 3 | $2,100 |
| DAWSODL | 7 | $4,150 |
| Exterior | 7 | $4,150 |
| FEWSODL | 5 | $400 |
| Bath | 5 | $400 |
| GARZATK | 10 | $625 |
| Interior | 10 | $625 |
| HUBBACD | 6 | $350 |
| Interior | 6 | $350 |
| HUBERSZ | 3 | $500 |
| Interior | 3 | $500 |
| JUARELM | 9 | $240 |
| Bath | 9 | $240 |
| MANNPN | 7 | $325 |
| Room | 7 | $325 |
| MARSHDN | 9 | $325 |
| Room | 9 | $325 |
| SANTIDP | 8 | $325 |
| Room | 8 | $325 |
| STAFFLK | 9 | $1,350 |
| Interior | 5 | $350 |
| Kitchen | 4 | $1,000 |
| TERKSKF | 2 | $240 |
| Bath | 2 | $240 |
| TODDNZ | 2 | $350 |
| Interior | 2 | $350 |
| UNDERES | 4 | $865 |
| Bath | 3 | $240 |
| Interior | 1 | $625 |
| WELCHEB | 2 | $4,150 |
| Exterior | 2 | $4,150 |
| WODGECM | 5 | $250 |
| Interior | 5 | $250 |
| Grand Total | 366 | $114,315 |
Project Type Report
| Row Labels | Number of Projects |
| Summer-Fall | 56 |
| Bath | |
| L | 2 |
| S | 2 |
| Exterior | |
| L | 8 |
| M | 7 |
| S | 14 |
| Interior | |
| L | 4 |
| S | 7 |
| Kitchen | |
| L | 3 |
| S | 4 |
| Office | |
| L | 2 |
| S | 2 |
| Room | |
| L | 1 |
| Winter-Spring | 21 |
| Bath | |
| L | 1 |
| S | 3 |
| Exterior | |
| L | 2 |
| S | 1 |
| Interior | |
| L | 6 |
| S | 3 |
| Kitchen | |
| L | 1 |
| Office | |
| S | 1 |
| Room | |
| L | 3 |
| Grand Total | 77 |
