Spreadsheet: 681581d1591645635-search-another-sheet-row-for-text-extract-data-in-that-column-protected-example-master
Sheet: PASTE DATA HERE

Sequence | Description | Item # | Equip Type | Serial # | Equipment Item # | Coverage Type | PM Offset | 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 | Prior Rev Line Price | Lis-Version # | Equipment Description | Schedule | Integration Status | Equipment Location | Equipment Control # | Equipment Status | Warranty End Date | Adjustment | Annual Value | Line Lost
1 | SelectChoice Agreement | NA MAINT AGREE | Unit 1 | SN00001 | Item#00001 | Basic | 3 | Active | 2018-09-01 00:00:00 | 2021-08-31 00:00:00 |  | 2 | List Price | 100 | 300 | 20 | Equipment#00001 | 100 | 300 | Account Name01 | 00001 | 1234 [NAME] AVE | 100 | LIST-00091 | Unit Type Here |  | Pending | 2ND FL |  | Active | 2001-01-01 00:00:00 | 0 | 100
2 | SelectChoice Agreement | NA MAINT AGREE | Unit 2 | SN00002 | Item#00002 | Basic | 3 | Cancelled | 2018-09-01 00:00:00 | 2019-06-30 00:00:00 | Received-eFAST | 2 | List Price | 100 | 300 | 20 | Equipment#00002 | 100 | 300 | Account Name01 | 00001 | 1234 [NAME] AVE | 100 | LIST-00091 | Unit Type Here |  |  | 2ND FL |  | Inactive | 2001-01-01 00:00:00 | 0 | 100
3 | SelectChoice Agreement | NA MAINT AGREE | Unit 3 | SN00003 | Item#00003 | Basic | 3 | Cancelled | 2018-09-01 00:00:00 | 2019-06-30 00:00:00 | Received-eFAST | 2 | List Price | 100 | 300 | 20 | Equipment#00003 | 100 | 300 | Account Name01 | 00001 | 1234 [NAME] AVE | 100 | LIST-00091 | Unit Type Here |  |  | 2nd FL |  | Inactive | 2001-01-01 00:00:00 | 0 | 100
4 | SelectChoice Agreement | NA MAINT AGREE | Unit 4 | SN00004 | Item#00004 | Basic | 0 | Active | 2018-09-01 00:00:00 | 2021-08-31 00:00:00 |  | 4 | List Price | 100 | 300 | 20 | Equipment#00004 | 100 | 300 | Account Name01 | 00001 | 1234 [NAME] AVE | 100 | LIST-00091 | Unit Type Here |  |  | 2nd FL |  | Active | 2001-01-01 00:00:00 | 0 | 100
5 | SelectChoice Agreement | NA MAINT AGREE | Unit 5 | SN00005 | Item#00005 | Basic | 0 | Active | 2018-09-01 00:00:00 | 2021-08-31 00:00:00 |  | 4 | List Price | 100 | 300 | 20 | Equipment#00005 | 100 | 300 | Account Name01 | 00001 | 1234 [NAME] AVE | 100 | LIST-00091 | Unit Type Here |  |  | 2nd FL |  | Active | 2001-01-01 00:00:00 | 0 | 100
6 | SelectChoice Agreement | NA MAINT AGREE | Unit 6 | SN00006 | Item#00006 | Basic | 1 | Active | 2018-09-01 00:00:00 | 2021-08-31 00:00:00 |  | 2 | List Price | 100 | 300 | 20 | Equipment#00006 | 100 | 300 | Account Name01 | 00001 | 1234 [NAME] AVE | 100 | LIST-00091 | Unit Type Here |  |  | 2nd FL |  | Active | 2001-01-01 00:00:00 | 0 | 100
7 | SelectChoice Agreement | NA MAINT AGREE | Unit 7 | SN00007 | Item#00007 | Basic | 1 | Active | 2018-09-01 00:00:00 | 2021-08-31 00:00:00 |  | 2 | List Price | 100 | 300 | 20 | Equipment#00007 | 100 | 300 | Account Name01 | 00001 | 1234 [NAME] AVE | 100 | LIST-00091 | Unit Type Here |  |  | 2nd FL |  | Active | 2001-01-01 00:00:00 | 0 | 100
8 | Addon package 1 | NA CMBR AGREE | Unit 8 | SN00008 | Item#00008 | Addon package 1 | 2 | Active | 2018-09-01 00:00:00 | 2021-08-31 00:00:00 |  | 1 | Prior Line Price | 100 | 300 |  | Equipment#00008 | 100 | 300 | Account Name01 | 00001 | 1234 [NAME] AVE | 100 | LIST-00091 | Unit Type Here |  | Pending | 2nd FL |  | Active | 2001-01-01 00:00:00 | 0 | 100
9 | Addon package 1 | NA CMBR AGREE | Unit 9 | SN00009 | Item#00009 | Addon package 1 | 2 | Cancelled | 2018-09-01 00:00:00 | 2019-08-31 00:00:00 | Received-eFAST | 1 | Prior Line Price | 100 | 300 |  | Equipment#00009 | 100 | 300 | Account Name01 | 00001 | 1234 [NAME] AVE | 100 | LIST-00091 | Unit Type Here |  |  | 2nd FL |  | Inactive | 2001-01-01 00:00:00 | 0 | 100
10 | Addon package 1 | NA CMBR AGREE | Unit 10 | SN00010 | Item#00010 | Addon package 1 | 2 | Cancelled | 2018-09-01 00:00:00 | 2019-08-31 00:00:00 | Received-eFAST | 1 | Prior Line Price | 100 | 300 |  | Equipment#00010 | 100 | 300 | Account Name01 | 00001 | 1234 [NAME] AVE | 100 | LIST-00091 | Unit Type Here |  |  | 2nd FL |  | Inactive | 2001-01-01 00:00:00 | 0 | 100
11 | Addon package 1 | NA CMBR AGREE | Unit 11 | SN00011 | Item#00011 | Addon package 1 | 2 | Active | 2018-09-01 00:00:00 | 2021-08-31 00:00:00 |  | 1 | Prior Line Price | 100 | 300 |  | Equipment#00011 | 100 | 300 | Account Name01 | 00001 | 1234 [NAME] AVE | 100 | LIST-00091 | Unit Type Here |  |  | 2nd FL |  | Active | 2001-01-01 00:00:00 | 0 | 100
12 | Addon package 1 | NA CMBR AGREE | Unit 12 | SN00012 | Item#00012 | Addon package 1 | 2 | Active | 2018-09-01 00:00:00 | 2021-08-31 00:00:00 |  | 1 | Prior Line Price | 100 | 300 |  | Equipment#00012 | 100 | 300 | Account Name01 | 00001 | 1234 [NAME] AVE | 100 | LIST-00091 | Unit Type Here |  |  | 2nd FL |  | Active | 2001-01-01 00:00:00 | 0 | 100
13 | SelectChoice Agreement | NA MAINT AGREE | Unit 13 | [NAME] | Item#00013 | Basic | 5 | Active | 2018-09-01 00:00:00 | 2021-08-31 00:00:00 |  | 2 | List Price | 100 | 300 |  | Equipment#00013 | 100 | 300 | Account Name01 | 00001 | 1234 [NAME] AVE | 100 | LIST-00091 | Unit Type Here |  |  | 2nd FL |  | Active | 2001-01-01 00:00:00 | 0 | 100
14 | SelectChoice Agreement | NA MAINT AGREE | Unit 14 | SN00014 | Item#00014 | Basic | 2 | Active | 2018-09-01 00:00:00 | 2021-08-31 00:00:00 |  | 4 | List Price | 100 | 300 | 20 | Equipment#00014 | 100 | 300 | Account Name01 | 00001 | 1234 [NAME] AVE | 100 | LIST-00091 | Unit Type Here |  |  | 2nd FL |  | Active | 2001-01-01 00:00:00 | 0 | 100
15 | SelectChoice Agreement | NA MAINT AGREE | Unit 15 | SN00015 | Item#00015 | Basic | 2 | Active | 2018-09-01 00:00:00 | 2021-08-31 00:00:00 |  | 4 | List Price | 100 | 300 | 20 | Equipment#00015 | 100 | 300 | Account Name01 | 00001 | 1234 [NAME] AVE | 100 | LIST-00091 | Unit Type Here |  |  | 2nd FL |  | Active | 2001-01-01 00:00:00 | 0 | 100
16 | SelectChoice Agreement | NA MAINT AGREE | Unit 16 | SN00016 | Item#00016 | Basic | 2 | Active | 2018-09-01 00:00:00 | 2021-08-31 00:00:00 |  | 4 | List Price | 100 | 300 | 20 | Equipment#00016 | 100 | 300 | Account Name01 | 00001 | 1234 [NAME] AVE | 100 | LIST-00091 | Unit Type Here |  |  | 2nd FL |  | Active | 2001-01-01 00:00:00 | 0 | 100
17 | SelectChoice Agreement | NA MAINT AGREE | Unit 17 | SN00017 | Item#00017 | Basic | 0 | Active | 2018-09-01 00:00:00 | 2021-08-31 00:00:00 |  | 2 | List Price | 100 | 300 | 20 | Equipment#00017 | 100 | 300 | Account Name01 | 00001 | 1234 [NAME] AVE | 100 | LIST-00091 | Unit Type Here |  |  | 2nd FL |  | Active | 2001-01-01 00:00:00 | 0 | 100
18 | SelectChoice Agreement | NA MAINT AGREE | Unit 18 | SN00018 | Item#00018 | Basic | 0 | Active | 2018-09-01 00:00:00 | 2021-08-31 00:00:00 |  | 4 | List Price | 100 | 300 | 20 | Equipment#00018 | 100 | 300 | Account Name01 | 00001 | 1234 [NAME] AVE | 100 | LIST-00091 | Unit Type Here |  |  | 2nd FL |  | Active | 2001-01-01 00:00:00 | 0 | 100
19 | SelectChoice Agreement | NA MAINT AGREE | Unit 19 | SN00019 | Item#00019 | Basic | 0 | Active | 2018-09-01 00:00:00 | 2021-08-31 00:00:00 |  | 4 | List Price | 100 | 300 | 20 | Equipment#00019 | 100 | 300 | Account Name01 | 00001 | 1234 [NAME] AVE | 100 | LIST-00091 | Unit Type Here |  |  | 2nd FL |  | Active | 2001-01-01 00:00:00 | 0 | 100
20 | SelectChoice Agreement | NA MAINT AGREE | Unit 20 | SN00020 | Item#00020 | Basic | 0 | Active | 2018-09-01 00:00:00 | 2021-08-31 00:00:00 |  | 4 | List Price | 100 | 300 | 20 | Equipment#00020 | 100 | 300 | Account Name01 | 00001 | 1234 [NAME] AVE | 100 | LIST-00091 | Unit Type Here |  |  | 2nd FL |  | Active | 2001-01-01 00:00:00 | 0 | 100
21 | SelectChoice Agreement | NA MAINT AGREE | Unit 21 | SN00021 | Item#00021 | Basic | 0 | Active | 2018-09-01 00:00:00 | 2021-08-31 00:00:00 |  | 4 | List Price | 100 | 300 | 20 | Equipment#00021 | 100 | 300 | Account Name01 | 00001 | 1234 [NAME] AVE | 100 | LIST-00091 | Unit Type Here |  |  | 2nd FL |  | Active | 2001-01-01 00:00:00 | 0 | 100
22 | SelectChoice Agreement | NA MAINT AGREE | Unit 22 | SN00022 | Item#00022 | Basic | 0 | Active | 2018-09-01 00:00:00 | 2021-08-31 00:00:00 |  | 4 | List Price | 100 | 300 | 20 | Equipment#00022 | 100 | 300 | Account Name01 | 00001 | 1234 [NAME] AVE | 100 | LIST-00091 | Unit Type Here |  |  | 2nd FL |  | Active | 2001-01-01 00:00:00 | 0 | 100
23 | SelectChoice Agreement | NA MAINT AGREE | Unit 23 | SN00023 | Item#00023 | Basic | 0 | Active | 2018-09-01 00:00:00 | 2021-08-31 00:00:00 |  | 4 | List Price | 100 | 300 | 20 | Equipment#00023 | 100 | 300 | Account Name01 | 00001 | 1234 [NAME] AVE | 100 | LIST-00091 | Unit Type Here |  |  | 2nd FL |  | Active | 2001-01-01 00:00:00 | 0 | 100
24 | SelectChoice Agreement | NA MAINT AGREE | Unit 24 | SN00024 | Item#00024 | Basic | 0 | Quoted | 2020-06-01 00:00:00 | 2021-08-31 00:00:00 |  | 2 | List Price | 100 | 300 |  | Equipment#00024 | 100 | 300 | Account Name01 | 00001 | 1234 [NAME] AVE |  | LIST-00091 | Unit Type Here |  |  | 2nd FL |  | Active | 2001-01-01 00:00:00 | 0 | 100