Spreadsheet: 159823d1338857276-excel-2007-2-parter-yearfrac-and-multifunction-calculations-sample
Sheet: Spa Experts

The Spa Experts
Monthly Transactions
Down Payment Requirement: |  | 0.25
Transaction Number | Date | Data Entry Operator | Sales Rep First Name | Sales Rep Last Name | Manufacturer | Payment Type | Transaction | Amount
2012-004 | 2012-01-02 00:00:00 | COK | Oleta | Fairbanks | Port-a-Spa | Finance | Promotion | 4080
2012-011 | 2012-01-04 00:00:00 | LH | Oleta | Fairbanks | Port-a-Spa | Finance | Standard | 10000
2012-021 | 2012-01-06 00:00:00 | KM | Oleta | Fairbanks | Port-a-Spa | Finance | Standard | 5000
2012-047 | 2012-01-21 00:00:00 | KRM | Oleta | Fairbanks | Port-a-Spa | Finance | Promotion | 8000
2012-059 | 2012-01-27 00:00:00 | COK | Oleta | Fairbanks | Port-a-Spa | Finance | Promotion | 7540
2012-032 | 2012-01-11 00:00:00 | COK | Oleta | Fairbanks | Port-a-Spa | Paid in Full | Promotion | 7500
2012-057 | 2012-01-26 00:00:00 | KM | Oleta | Fairbanks | Port-a-Spa | Paid in Full | Promotion | 25000
2012-025 | 2012-01-08 00:00:00 | KM | Oleta | Fairbanks | Serenity Spas | Finance | Standard | 3240
2012-045 | 2012-01-20 00:00:00 | MAP | Oleta | Fairbanks | Serenity Spas | Finance | Promotion | 7500
2012-038 | 2012-01-16 00:00:00 | COK | Oleta | Fairbanks | Serenity Spas | Paid in Full | Standard | 32000
2012-007 | 2012-01-03 00:00:00 | KM | Oleta | Fairbanks | The Original Hot Tub | Finance | Standard | 5432
2012-048 | 2012-01-21 00:00:00 | MH | Oleta | Fairbanks | The Original Hot Tub | Finance | Standard | 17500
2012-066 | 2012-01-30 00:00:00 | COK | Oleta | Fairbanks | The Original Hot Tub | Finance | Standard | 4080
2012-016 | 2012-01-04 00:00:00 | KM | Oleta | Fairbanks | The Original Hot Tub | Paid in Full | Standard | 5432
2012-060 | 2012-01-27 00:00:00 | KRM | Oleta | Fairbanks | The Original Hot Tub | Paid in Full | Standard | 12500
2012-010 | 2012-01-04 00:00:00 | LH | Grant | Ingersoll | Port-a-Spa | Finance | Standard | 10000
2012-027 | 2012-01-09 00:00:00 | MH | Grant | Ingersoll | Port-a-Spa | Finance | Promotion | 22000
2012-044 | 2012-01-19 00:00:00 | COK | Grant | Ingersoll | Port-a-Spa | Paid in Full | Standard | 12500
2012-064 | 2012-01-29 00:00:00 | MH | Grant | Ingersoll | Serenity Spas | Finance | Standard | 7730
2012-015 | 2012-01-04 00:00:00 | COK | Grant | Ingersoll | Serenity Spas | Paid in Full | Promotion | 7450
2012-015 | 2012-01-04 00:00:00 | COK | Grant | Ingersoll | Serenity Spas | Paid in Full | Promotion | 7450
2012-024 | 2012-01-07 00:00:00 | COK | Grant | Ingersoll | Serenity Spas | Paid in Full | Standard | 5400
2012-036 | 2012-01-14 00:00:00 | KM | Grant | Ingersoll | Serenity Spas | Paid in Full | Promotion | 4800
2012-002 | 2012-01-01 00:00:00 | KM | Grant | Ingersoll | The Original Hot Tub | Finance | Promotion | 12000
2012-035 | 2012-01-13 00:00:00 | MAP | Grant | Ingersoll | The Original Hot Tub | Finance | Promotion | 6540
2012-046 | 2012-01-21 00:00:00 | KRM | Grant | Ingersoll | The Original Hot Tub | Finance | Standard | 3450
2012-065 | 2012-01-29 00:00:00 | MH | Grant | Ingersoll | The Original Hot Tub | Finance | Standard | 8400
2012-028 | 2012-01-09 00:00:00 | MH | Grant | Ingersoll | The Original Hot Tub | Paid in Full | Promotion | 3240
2012-003 | 2012-01-02 00:00:00 | MH | Deanne | [NAME] | Port-a-Spa | Finance | Promotion | 3240
2012-006 | 2012-01-03 00:00:00 | KRM | Deanne | [NAME] | Port-a-Spa | Finance | Standard | 6780
2012-018 | 2012-01-05 00:00:00 | LH | Deanne | [NAME] | Port-a-Spa | Finance | Standard | 7450
2012-020 | 2012-01-06 00:00:00 | MAP | Deanne | [NAME] | Port-a-Spa | Finance | Promotion | 26500
2012-026 | 2012-01-09 00:00:00 | LH | Deanne | [NAME] | Port-a-Spa | Finance | Promotion | 7400
2012-040 | 2012-01-18 00:00:00 | MH | Deanne | [NAME] | Port-a-Spa | Finance | Standard | 3200
2012-054 | 2012-01-24 00:00:00 | MH | Deanne | [NAME] | Port-a-Spa | Finance | Promotion | 6000
2012-058 | 2012-01-27 00:00:00 | KRM | Deanne | [NAME] | Port-a-Spa | Finance | Promotion | 7540
2012-068 | 2012-01-31 00:00:00 | COK | Deanne | [NAME] | Port-a-Spa | Finance | Standard | 3000
2012-070 | 2012-01-31 00:00:00 | LH | Deanne | [NAME] | Port-a-Spa | Finance | Promotion | 11250
2012-012 | 2012-01-04 00:00:00 | KM | Deanne | [NAME] | Port-a-Spa | Paid in Full | Standard | 4550
2012-019 | 2012-01-05 00:00:00 | MAP | Deanne | [NAME] | Port-a-Spa | Paid in Full | Standard | 8560
2012-037 | 2012-01-15 00:00:00 | COK | Deanne | [NAME] | Port-a-Spa | Paid in Full | Standard | 7200
2012-042 | 2012-01-18 00:00:00 | MH | Deanne | [NAME] | Port-a-Spa | Paid in Full | Promotion | 18000
2012-043 | 2012-01-19 00:00:00 | MH | Deanne | [NAME] | Port-a-Spa | Paid in Full | Standard | 4500
2012-034 | 2012-01-12 00:00:00 | KRM | Deanne | [NAME] | Serenity Spas | Finance | Standard | 6700
2012-008 | 2012-01-03 00:00:00 | LH | Deanne | [NAME] | Serenity Spas | Paid in Full | Standard | 6780
2012-013 | 2012-01-04 00:00:00 | KM | Deanne | [NAME] | Serenity Spas | Paid in Full | Promotion | 8490
2012-052 | 2012-01-22 00:00:00 | COK | Deanne | [NAME] | Serenity Spas | Paid in Full | Standard | 6540
2012-001 | 2012-01-01 00:00:00 | KM | Deanne | [NAME] | The Original Hot Tub | Finance | Promotion | 15000
2012-031 | 2012-01-11 00:00:00 | LH | Deanne | [NAME] | The Original Hot Tub | Finance | Promotion | 7500
2012-055 | 2012-01-25 00:00:00 | MAP | Deanne | [NAME] | The Original Hot Tub | Finance | Promotion | 12500
2012-009 | 2012-01-03 00:00:00 | MAP | Deanne | [NAME] | The Original Hot Tub | Paid in Full | Standard | 27000
2012-014 | 2012-01-04 00:00:00 | KRM | Deanne | [NAME] | The Original Hot Tub | Paid in Full | Standard | 5432
2012-056 | 2012-01-26 00:00:00 | MH | Deanne | [NAME] | The Original Hot Tub | Paid in Full | Promotion | 22500
2012-063 | 2012-01-28 00:00:00 | KM | Deanne | [NAME] | The Original Hot Tub | Paid in Full | Standard | 8400
2012-023 | 2012-01-07 00:00:00 | KRM | [NAME] | Prescott | Port-a-Spa | Finance | Promotion | 5000
2012-039 | 2012-01-17 00:00:00 | LH | [NAME] | Prescott | Port-a-Spa | Finance | Standard | 12000
2012-061 | 2012-01-28 00:00:00 | KRM | [NAME] | Prescott | Port-a-Spa | Finance | Standard | 9430
2012-050 | 2012-01-21 00:00:00 | KM | [NAME] | Prescott | Port-a-Spa | Paid in Full | Standard | 18500
2012-067 | 2012-01-30 00:00:00 | MH | [NAME] | Prescott | Port-a-Spa | Paid in Full | Standard | 12000
2012-005 | 2012-01-02 00:00:00 | MAP | [NAME] | Prescott | Serenity Spas | Finance | Promotion | 5432
2012-022 | 2012-01-06 00:00:00 | KM | [NAME] | Prescott | Serenity Spas | Finance | Promotion | 8560
2012-049 | 2012-01-21 00:00:00 | LH | [NAME] | Prescott | Serenity Spas | Finance | Standard | 5600
2012-053 | 2012-01-23 00:00:00 | KM | [NAME] | Prescott | Serenity Spas | Finance | Standard | 5600
2012-062 | 2012-01-28 00:00:00 | MAP | [NAME] | Prescott | Serenity Spas | Finance | Promotion | 10000
2012-017 | 2012-01-04 00:00:00 | MAP | [NAME] | Prescott | Serenity Spas | Paid in Full | Promotion | 6780
2012-033 | 2012-01-11 00:00:00 | LH | [NAME] | Prescott | Serenity Spas | Paid in Full | Promotion | 4650
2012-041 | 2012-01-18 00:00:00 | KRM | [NAME] | Prescott | The Original Hot Tub | Finance | Standard | 12350
2012-029 | 2012-01-10 00:00:00 | MH | [NAME] | Prescott | The Original Hot Tub | Paid in Full | Standard | 7690
2012-051 | 2012-01-21 00:00:00 | COK | [NAME] | Prescott | The Original Hot Tub | Paid in Full | Standard | 5400
2012-069 | 2012-01-31 00:00:00 | COK | [NAME] | Prescott | The Original Hot Tub | Paid in Full | Standard | 21500
Summary Stats for Transactions
Total dollars for Promotional Transactions
Total dollars for Standard Transactions
Summary of Stats for manufacturers
Total dollars for Port-a-Spa Financed Payments
Total dollars for Original Hot Tub Paid in Full
# of Sales Reps