revised hw.
jontha2
example..xlsCompany Discounts - Table 1
| Job Title | Type of Company | Year-to-Date Purchases ($million) | Discount on Purchases | Number of Healthcare Companies |
| Wegmans Health | Healthcare | $550.00 | ||
| NetApp | Technology | $501.00 | Number of Technology Companies | |
| HilCorp | Real Estate | $413.00 | ||
| Ultimate Software | Technology | $390.00 | Number of Real Estate Companies | |
| Technology | $375.00 | |||
| Camden Property | Real Estate | $350.00 | Number of Healthcare companies with year-to-date purchases over $350 million | |
| QualComm | Technology | $325.00 | ||
| Burns & McCoy | Healthcare | $310.00 | 4 | |
| Schumacher Drugs | Healthcare | $300.00 | ||
| Halliday Health | Healthcare | $550.00 | ||
| Worthington Consultants | Technology | $501.00 | ||
| Manse, Inc | Real Estate | $413.00 | ||
| BB Software | Technology | $390.00 | ||
| Apple | Technology | $375.00 | ||
| IEC Realtors | Real Estate | $350.00 | ||
| Comcast | Technology | $325.00 | ||
| Williams & Borne | Healthcare | $310.00 | ||
| Lily & Assoc | Healthcare | $300.00 | ||
| Pearl Consultants | Technology | $413.00 | ||
| Bell Tower, Inc | Real Estate | $390.00 | ||
| ComSys | Technology | $375.00 | ||
| Ciscom | Technology | $350.00 | ||
| Blumenthal | Real Estate | $325.00 | ||
| Mayer-Bowles Tech | Technology | $310.00 | ||
| E.J. Morningsinde | Healthcare | $300.00 | ||
| Lews, LTD | Healthcare | $300.00 | ||
| Pholey Pharmaceuticals | Healthcare | $550.00 | ||
| Boyle Tech | Technology | $501.00 | ||
| Commercial Prepoerties | Real Estate | $413.00 | ||
| Salisbury Security | Technology | $390.00 | ||
| Donavan & Miles Tech | Technology | $375.00 | ||
| Deck Real Estate | Real Estate | $350.00 | ||
| ViraScan | Technology | $325.00 | ||
| Samuelson Pharms | Healthcare | $590.00 | ||
| Fogarty, LTD | Healthcare | $300.00 | ||
| IdeaWare | Technology | $413.00 | ||
| Yellowstone Cabins | Real Estate | $390.00 | ||
| SoftPlat | Technology | $375.00 | ||
| SystemApps | Technology | $600.00 | ||
| Mountain Rural Property | Real Estate | $325.00 | ||
| OLASistems | Technology | $475.00 | ||
| Zimmerman & Associates | Healthcare | $300.00 | ||
| Banfield Martin Distributors | Healthcare | $300.00 |
Formulas - Table 1
| Job Title | Type of Company | Year-to-Date Purchases ($million) | Discount on Purchases | Number of Healthcare Companies |
| Wegmans Health | Healthcare | $550.00 | YourFormula | YourFormula |
| NetApp | Technology | $501.00 | YourFormula | Number of Technology Companies |
| HilCorp | Real Estate | $413.00 | YourFormula | YourFormula |
| Ultimate Software | Technology | $390.00 | YourFormula | Number of Real Estate Companies |
| Technology | $375.00 | YourFormula | YourFormula | |
| Camden Property | Real Estate | $350.00 | YourFormula | Number of Healthcare companies with year-to-date purchases over $350 million |
| QualComm | Technology | $325.00 | YourFormula | |
| Burns & McCoy | Healthcare | $310.00 | YourFormula | YourFormula |
| Schumacher Drugs | Healthcare | $300.00 | YourFormula | |
| Halliday Health | Healthcare | $550.00 | YourFormula | |
| Worthington Consultants | Technology | $501.00 | YourFormula | |
| Manse, Inc | Real Estate | $413.00 | YourFormula | |
| BB Software | Technology | $390.00 | YourFormula | |
| Apple | Technology | $375.00 | YourFormula | |
| IEC Realtors | Real Estate | $350.00 | YourFormula | |
| Comcast | Technology | $325.00 | YourFormula | |
| Williams & Borne | Healthcare | $310.00 | YourFormula | |
| Lily & Assoc | Healthcare | $300.00 | YourFormula | |
| Pearl Consultants | Technology | $413.00 | YourFormula | |
| Bell Tower, Inc | Real Estate | $390.00 | YourFormula | |
| ComSys | Technology | $375.00 | YourFormula | |
| Ciscom | Technology | $350.00 | YourFormula | |
| Blumenthal | Real Estate | $325.00 | YourFormula | |
| Mayer-Bowles Tech | Technology | $310.00 | YourFormula | |
| E.J. Morningsinde | Healthcare | $300.00 | YourFormula | |
| Lews, LTD | Healthcare | $300.00 | YourFormula | |
| Pholey Pharmaceuticals | Healthcare | $550.00 | YourFormula | |
| Boyle Tech | Technology | $501.00 | YourFormula | |
| Commercial Prepoerties | Real Estate | $413.00 | YourFormula | |
| Salisbury Security | Technology | $390.00 | YourFormula | |
| Donavan & Miles Tech | Technology | $375.00 | YourFormula | |
| Deck Real Estate | Real Estate | $350.00 | YourFormula | |
| ViraScan | Technology | $325.00 | YourFormula | |
| Samuelson Pharms | Healthcare | $590.00 | YourFormula | |
| Fogarty, LTD | Healthcare | $300.00 | YourFormula | |
| IdeaWare | Technology | $413.00 | YourFormula | |
| Yellowstone Cabins | Real Estate | $390.00 | YourFormula | |
| SoftPlat | Technology | $375.00 | YourFormula | |
| SystemApps | Technology | $600.00 | YourFormula | |
| Mountain Rural Property | Real Estate | $325.00 | YourFormula | |
| OLASistems | Technology | $475.00 | YourFormula | |
| Zimmerman & Associates | Healthcare | $300.00 | YourFormula | |
| Banfield Martin Distributors | Healthcare | $300.00 | YourFormula |
