Spreadsheet: 865278d1712320659-help-with-designing-the-presentation-of-pivot-tables-borders-and-such-weekly_quote_report
Sheet: BREAK DOWN OF DATA

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Quote Status | Open |  | Quote Status | Open
[NAME] DOWN |  |  |  |  |  |  |  |  |  |  | # of Quotes Per Month |  |  | # and $ Amount of Quotes per Status and per Month |  |  |  | Customer's and Amount Quoted per Sales Person
 | Client Lost Order | Dormant | Lost to Competitor | Lost, Unknown | Open | Project Canceled | Revised - Closed | Won | Grand Total |  | [NAME] | # of Quotes per Month |  | [NAME] | $ Amount of Quotes per Status | # of Quotes for 2024 Status |  | [NAME] | $ [NAME] Quoted |  | [NAME] | $ Amount of Open Quotes per Customer |  | Quote # by Customer | $ Amount of Quote
[NAME] | 139365 | 19440 | 1392187 |  | 907748 | 0 | 17488 | 10130 | 2486358 |  | [NAME] | 36 |  | [NAME] | 2486358 | 36 |  | [NAME] | 2486358 |  | [NAME] | 907748 |  | AirCo Industrial Service | 251059
Jan | 50057 | 19440 |  |  | 400560 |  |  | 3235 | 473292 |  | Jan | 13 |  | Client Lost Order | 139365 | 3 |  | AirCo Industrial Service | 268547 |  | AirCo Industrial Service | 251059 |  | DQTE-1715 | 21530
Feb |  |  | 1366407 |  | 70690 |  |  | 6895 | 1443992 |  | Feb | 7 |  | Jan | 50057 | 2 |  | Applied Heat Recovery | 34526 |  | Applied Heat Recovery | 34526 |  | DQTE-1721 | 200550
Mar | 89308 |  | 25780 |  | 412689 | 0 | 17488 |  | 545265 |  | Mar | 15 |  | Mar | 89308 | 1 |  | Arman Traders | 89308 |  | Bachmann Industries Inc | 10235 |  | DQTE-1722 | 5170
Apr |  |  |  |  | 23809 |  |  |  | 23809 |  | Apr | 1 |  | Dormant | 19440 | 2 |  | Bachmann Industries Inc | 10235 |  | Barron Fan Tech | 22718 |  | DQTE-2039 | 23809
[NAME] |  |  |  |  | 627000 |  |  | 38584 | 665584 |  | [NAME] | 17 |  | Jan | 19440 | 2 |  | Barron Fan Tech | 58700 |  | [NAME] | 1765 |  | Applied Heat Recovery | 34526
Jan |  |  |  |  | 780 |  |  |  | 780 |  | Jan | 1 |  | Lost to Competitor | 1392187 | 3 |  | [NAME] | 1765 |  | CTS Industries | 24970 |  | DQTE-1814 | 34526
Feb |  |  |  |  | 464305 |  |  | 38584 | 502889 |  | Feb | 7 |  | Feb | 1366407 | 2 |  | CTS Industries | 24970 |  | Damper & Control Systems LLC | 9934 |  | Bachmann Industries Inc | 1015290
Mar |  |  |  |  | 161215 |  |  |  | 161215 |  | Mar | 8 |  | Mar | 25780 | 1 |  | Damper & Control Systems LLC | 9934 |  | ESI of Tennessee | 58407 |  | DQTE-1698 | 780
Apr |  |  |  |  | 700 |  |  |  | 700 |  | Apr | 1 |  | Open | 907748 | 24 |  | Electric Controls and Systems, Inc. | 25780 |  | Fabricated Solutions LLC | 5730 |  | DQTE-1735 | 6485
[NAME] |  |  | 63550 | 20940 | 1213301 |  |  | 43871 | 1341662 |  | [NAME] | 42 |  | Jan | 400560 | 8 |  | ESI of Tennessee | 58407 |  | Howden Americas Fans | 222462 |  | DQTE-1763 | 2120
Jan |  |  | 63550 |  | 527216 |  |  | 32521 | 623287 |  | Jan | 18 |  | Feb | 70690 | 4 |  | Fabricated Solutions LLC | 5730 |  | Indeck Keystone Energy, LLC | 20870 |  | [NAME] | 1800
Feb |  |  |  | 20940 | 363270 |  |  | 5460 | 389670 |  | Feb | 15 |  | Mar | 412689 | 11 |  | Howden Americas Fans | 222462 |  | IVI Inc. | 6010 |  | DQTE-1803 | 2260
Mar |  |  |  |  | 322815 |  |  | 5890 | 328705 |  | Mar | 9 |  | Apr | 23809 | 1 |  | Indeck Keystone Energy, LLC | 20870 |  | Kiewit Engineering Group, Inc. | 32060 |  | DQTE-1819 | 31900
[NAME] |  |  |  |  | 1800 |  |  |  | 1800 |  | [NAME] | 1 |  | Project Canceled | 0 | 1 |  | IVI Inc. | 6010 |  | L & M Industrial Contracting Inc | 61820 |  | DQTE-1821 | 0
Jan |  |  |  |  | 1800 |  |  |  | 1800 |  | Jan | 1 |  | Mar | 0 | 1 |  | Kiewit Engineering Group, Inc. | 32060 |  | Mitsubishi Power | 99750 |  | [NAME] | 210070
[NAME] |  |  |  |  | 414020 | 245480 |  |  | 659500 |  | [NAME] | 6 |  | Revised - Closed | 17488 | 1 |  | L & M Industrial Contracting Inc | 79130 |  | Robinson Fans, Inc. | 2660 |  | [NAME] | 7920
Jan |  |  |  |  | 119490 |  |  |  | 119490 |  | Jan | 3 |  | Mar | 17488 | 1 |  | LGG Industrial | 6895 |  | [NAME] Cement | 2708 |  | DQTE-1861 | 31100
Feb |  |  |  |  | 210070 | 245480 |  |  | 455550 |  | Feb | 2 |  | Won | 10130 | 2 |  | Mitsubishi Power | 99750 |  | Vogt Power International | 40064 |  | DQTE-1899 | 0
Mar |  |  |  |  | 84460 |  |  |  | 84460 |  | Mar | 1 |  | Jan | 3235 | 1 |  | Robinson Fans, Inc. | 2660 |  | [NAME] | 627000 |  | DQTE-1903 | 49500
Grand Total | 139365 | 19440 | 1455737 | 20940 | 3163869 | 245480 | 17488 | 92585 | 5154904 |  | Grand Total | 102 |  | Feb | 6895 | 1 |  | [NAME] Cement | 2708 |  | Bachmann Industries Inc | 627000 |  | DQTE-1904 | 358680
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 665584 | 17 |  | Tassco, LLC | 19440 |  | [NAME] | 1213301 |  | DQTE-1905 | 46940
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Open | 627000 | 16 |  | Vogt Power International | 1406471 |  | Bachmann Industries Inc | 166185 |  | DQTE-1921 | 9185
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan | 780 | 1 |  | [NAME] | 0 |  | Barron Fan Tech | 15206 |  | DQTE-1931 | 13800
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb | 464305 | 6 |  | [NAME] | 665584 |  | CleaverBrooks | 31245 |  | DQTE-1946 | 13990
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar | 161215 | 8 |  | Bachmann Industries Inc | 665584 |  | Dixie Industrial LLC | 34840 |  | DQTE-1959 | 32250
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr | 700 | 1 |  | [NAME] | 1341662 |  | Energylink International | 327820 |  | DQTE-1984 | 5960
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Won | 38584 | 1 |  | Bachmann Industries Inc | 166185 |  | ExxonMobil | 8305 |  | DQTE-1985 | 18750
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb | 38584 | 1 |  | Barron Fan Tech | 21096 |  | G Squared Engineered Products | 38570 |  | DQTE-1987 | 2125
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1341662 | 42 |  | CleaverBrooks | 31245 |  | Get Pro Industrial | 84595 |  | DQTE-1988 | 500
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Lost to Competitor | 63550 | 2 |  | Comanche Power Station AEP-PSO | 31900 |  | [NAME] | 30120 |  | [NAME] | 24360
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan | 63550 | 2 |  | Dixie Industrial LLC | 34840 |  | LGG Industrial | 11480 |  | DQTE-2001 | 16910
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Lost, Unknown | 20940 | 1 |  | Energylink International | 327820 |  | [NAME], Inc | 2530 |  | DQTE-2005 | 27600
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb | 20940 | 1 |  | ExxonMobil | 8305 |  | Power Systems | 4575 |  | DQTE-2024 | 10235
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Open | 1213301 | 35 |  | G Squared Engineered Products | 38570 |  | SYMS KOREA | 302470 |  | DQTE-2029 | 59920
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan | 527216 | 14 |  | Get Pro Industrial | 84595 |  | Vogt Power International | 65860 |  | DQTE-2031 | 29450
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb | 363270 | 13 |  | [NAME] | 30120 |  | [NAME] | 23980 |  | DQTE-2043 | 700
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar | 322815 | 8 |  | LGG Industrial | 11480 |  | XRG Technologies | 59980 |  | Barron Fan Tech | 37924
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Won | 43871 | 4 |  | [NAME], Inc | 2530 |  | (blank) | 5540 |  | DQTE-1697 | 731
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan | 32521 | 2 |  | Pacific NW Pump & Process Inc | 20940 |  | [NAME] | 1800 |  | DQTE-1893 | 14475
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb | 5460 | 1 |  | Power Systems | 5196 |  | Bachmann Industries Inc | 1800 |  | [NAME] | 22718
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar | 5890 | 1 |  | [NAME], Inc | 41900 |  | [NAME] | 414020 |  | DQTE-2034 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1800 | 1 |  | SYMS KOREA | 302470 |  | Bachmann Industries Inc | 210070 |  | [NAME] | 1765
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Open | 1800 | 1 |  | Technos Fan | 5460 |  | ESI of Tennessee | 84460 |  | DQTE-2023 | 1765
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan | 1800 | 1 |  | Tennessee Valley Authority | 21650 |  | L&M Industrial Contracting, Inc | 80040 |  | CleaverBrooks | 31245
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 659500 | 6 |  | Vogt Power International | 65860 |  | [NAME] | 39450 |  | DQTE-1924 | 24625
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Open | 414020 | 5 |  | [NAME] | 23980 |  | The G.C. Broach Company | 0 |  | DQTE-1951 | 6620
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan | 119490 | 3 |  | XRG Technologies | 59980 |  | Grand Total | 3163869 |  | CTS Industries | 24970
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb | 210070 | 1 |  | (blank) | 5540 |  |  |  |  | DQTE-1874 | 24970
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar | 84460 | 1 |  | [NAME] | 1800 |  |  |  |  | Damper & Control Systems LLC | 9934
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Project Canceled | 245480 | 1 |  | Bachmann Industries Inc | 1800 |  |  |  |  | [NAME] | 2948
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb | 245480 | 1 |  | [NAME] | 659500 |  |  |  |  | [NAME] | 4826
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 5154904 | 102 |  | Bachmann Industries Inc | 455550 |  |  |  |  | DQTE-2032 | 2160
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ESI of Tennessee | 84460 |  |  |  |  | Dixie Industrial LLC | 34840
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L&M Industrial Contracting, Inc | 80040 |  |  |  |  | [NAME] | 7040
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 39450 |  |  |  |  | DQTE-1755 | 27800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The G.C. Broach Company | 0 |  |  |  |  | Energylink International | 327820
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 5154904 |  |  |  |  | DQTE-1876 | 149920
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 177900
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ESI of Tennessee | 142867
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1969 | 58407
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1974 | 84460
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ExxonMobil | 8305
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1792 | 8305
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fabricated Solutions LLC | 5730
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1794 | 5730
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G Squared Engineered Products | 38570
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1869 | 16990
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1992 | 21580
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Get Pro Industrial | 84595
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1724 | 84595
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Howden Americas Fans | 222462
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1950 | 222462
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Indeck Keystone Energy, LLC | 20870
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 20870
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IVI Inc. | 6010
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1798 | 6010
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kiewit Engineering Group, Inc. | 32060
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-2016 | 32060
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L & M Industrial Contracting Inc | 61820
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1682 | 51260
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1766 | 10560
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L&M Industrial Contracting, Inc | 80040
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 80040
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 30120
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1879 | 30120
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LGG Industrial | 11480
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 9770
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1772 | 1710
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], Inc | 2530
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1737 | 2530
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1884 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mitsubishi Power | 99750
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1662 | 99750
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Power Systems | 4575
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1836 | 4575
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Robinson Fans, Inc. | 2660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Cement | 2708
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1897 | 2708
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SYMS KOREA | 302470
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 302470
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 39450
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1672 | 39450
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The G.C. Broach Company | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1780 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vogt Power International | 105924
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1762 | 65860
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 40064
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 23980
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1882 | 23980
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XRG Technologies | 59980
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1871 | 13865
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1989 | 46115
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (blank) | 5540
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DQTE-1764 | 5540
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 3163869