Spreadsheet: 683875d1593017991-formula-determined-by-yes-no-dropdown-generic
Sheet: PASTE DATA HERE

Sequence | Description | Item # | Equip Type | Serial # | Coverage Type | Status | Start | End | Mod Form Status | PM Vists | Pricing Method | Annual Price | Prorated Value | Field Discount | Equipment # | Annual List Price | Line Price/Inv Amount | Equipment Account | Equipment Account Number | Equipment Address | Equipment Status | Annual Value
1 | SelectChoice Agreement | NA MAINT AGREE | UNIT 1 | 10760111 | Comprehensive | Active | 2019-09-01 00:00:00 | 2020-08-31 00:00:00 |  | 2 | Prior Line Price | 5000 | 5000 | -4 | M_1131517 | 5313 | 5000 | ACCOUNT NAME 1 | 10000 | 1 SMITH BLVD | Active | 5313
2 | SelectChoice Agreement | NA MAINT AGREE | UNIT 2 | 13270023 | Comprehensive | Active | 2019-09-01 00:00:00 | 2020-08-31 00:00:00 |  | 2 | Prior Line Price | 5000 | 5000 | -4 | M_1131518 | 5313 | 5000 | ACCOUNT NAME 1 | 10000 | 1 SMITH BLVD | Active | 5313
3 | NA-Agreement Travel Surcharge | NA TRAVEL CHARGE | UNIT 2 | 11310101 |  | Active | 2019-09-01 00:00:00 | 2020-08-31 00:00:00 |  |  | Prior Line Price | 0 | 0 | 0 | M_1136621 | 0 | 0 | ACCOUNT NAME 1 | 10000 | 1 SMITH BLVD | Active | 0
4 | SelectChoice Agreement | NA MAINT AGREE | UNIT 2 | LIGHT1613111 | Comprehensive | Active | 2019-09-01 00:00:00 | 2020-08-31 00:00:00 |  | 2 | Prior Line Price | 1200 | 1200 | -5 | [PHONE] | 1200 | 1200 | ACCOUNT NAME 1 | 10000 | 1 SMITH BLVD | Active | 1200
5 | SelectChoice Agreement | NA MAINT AGREE | UNIT 3 | 404673 | Comprehensive | Active | 2019-09-01 00:00:00 | 2020-08-31 00:00:00 |  | 4 | Prior Line Price | 6500 | 6500 | -4 | [PHONE] | 6510 | 6500 | ACCOUNT NAME 1 | 10000 | 1 SMITH BLVD | Active | 6510
6 | SelectChoice Agreement | NA MAINT AGREE | UNIT 3 | 404672 | Comprehensive | Active | 2019-09-01 00:00:00 | 2020-08-31 00:00:00 |  | 4 | Prior Line Price | 6500 | 6500 | -4 | [PHONE] | 6510 | 6500 | ACCOUNT NAME 1 | 10000 | 1 SMITH BLVD | Active | 6510
7 | SelectChoice Agreement | NA MAINT AGREE | UNIT 4 | 11220104 | Comprehensive | Active | 2019-09-01 00:00:00 | 2020-08-31 00:00:00 |  | 2 | Prior Line Price | 7500 | 7500 | -5 | M_1136620 | 7760 | 7500 | ACCOUNT NAME 1 | 10000 | 1 SMITH BLVD | Active | 7760
8 | SelectChoice Agreement | NA MAINT AGREE | UNIT 4 | 11310101 | Comprehensive | Active | 2019-09-01 00:00:00 | 2020-08-31 00:00:00 |  | 2 | Prior Line Price | 7500 | 7500 | -5 | M_1136621 | 7760 | 7500 | ACCOUNT NAME 1 | 10000 | 1 SMITH BLVD | Active | 7760
9 | SelectChoice Agreement | NA MAINT AGREE | UNIT 5 | 3607217025 | Comprehensive | Active | 2019-09-01 00:00:00 | 2020-08-31 00:00:00 |  | 4 | Prior Line Price | 8000 | 8000 | -5 | [PHONE] | 8056 | 8000 | ACCOUNT NAME 1 | 10000 | 1 SMITH BLVD | Active | 8056
10 | SelectChoice Agreement | NA MAINT AGREE | UNIT 56 | 32191708 | Comprehensive | Active | 2019-09-01 00:00:00 | 2020-08-31 00:00:00 |  | 2 | Prior Line Price | 17000 | 17000 | -5 | [PHONE] | 16770 | 17000 | ACCOUNT NAME 1 | 10000 | 1 SMITH BLVD | Active | 16770
11 | NA- Cleaning Service Agreement | NA CLN AGREE | UNIT 2 | 10760111 | Cleaning | Active | 2019-09-01 00:00:00 | 2020-08-31 00:00:00 |  | 1 | List Price | 1000 | 1000 |  | M_1131517 | 1095 | 1000 | ACCOUNT NAME 1 | 10000 | 1 SMITH BLVD | Active | 1095
12 | NA- Cleaning Service Agreement | NA CLN AGREE | UNIT 2 | 13270023 | Cleaning | Active | 2019-09-01 00:00:00 | 2020-08-31 00:00:00 |  | 1 | List Price | 1000 | 1000 |  | M_1131518 | 1095 | 1000 | ACCOUNT NAME 1 | 10000 | 1 SMITH BLVD | Active | 1095
13 | NA- Cleaning Service Agreement | NA CLN AGREE | UNIT 5 | 11310101 | Cleaning | Active | 2019-09-01 00:00:00 | 2020-08-31 00:00:00 |  | 1 | List Price | 1000 | 1000 |  | M_1136621 | 1295 | 1000 | ACCOUNT NAME 1 | 10000 | 1 SMITH BLVD | Active | 1295
14 | NA- Cleaning Service Agreement | NA CLN AGREE | UNIT 5 | 11220104 | Cleaning | Active | 2019-09-01 00:00:00 | 2020-08-31 00:00:00 |  | 1 | List Price | 1000 | 1000 |  | M_1136620 | 1295 | 1000 | ACCOUNT NAME 1 | 10000 | 1 SMITH BLVD | Active | 1295