Spreadsheet: 148209d1333249858-attempting-to-extract-data-from-a-report-example-data
Sheet: Pasted Data

 |  | Page Numbe | r:   1
 |  | 397 | 2012-03-31 00:00:00 | 397 | 31-M | AR-12
yyyyyyy - #0000 |  |  |  | yyyyyy | y - #0000
11111 N. Xxxxxxx Expres | sway | Attn: |  | 11111 | [NAME] | Expressway
Xxxxxx, XX 00000 |  |  |  | Xxxxxx | , XX 00000
24-MAR-12 334849/Folio |  |  |  | 2012-03-24 00:00:00 | 334849 | 644.8
***Xx, Xxxxxxxx 532 |  |  |  | 2012-03-24 00:00:00 | 336900 | 163.15
Voucher/PO #  000000000 |  |  |  | 2012-03-24 00:00:00 | 337126 | 536.28
 |  |  |  | 2012-03-24 00:00:00 | 337127 | 536.28
20-MAR-12 Room Charge Internet | 138.7 |  |  | 2012-03-24 00:00:00 | 340930 | 163.15
20-MAR-12 State Tax | 9.71 |  |  | 2012-03-24 00:00:00 | 343637 | 155.35
20-MAR-12 City/Local Tax | 6.94 |  |  | 2012-03-24 00:00:00 | 343639 | 143.96
21-MAR-12 Room Chrg Restricted | 145.67 |  |  | 2012-03-24 00:00:00 | 343728 | 163.15
21-MAR-12 State Tax | 10.2 |  |  | 2012-03-24 00:00:00 | 343730 | 163.15
21-MAR-12 City/Local Tax | 7.28 |  |  | 2012-03-24 00:00:00 | 344020 | 163.15
22-MAR-12 Room Chrg Restricted | 145.67 |  |  | 2012-03-24 00:00:00 | 344066 | 163.15
22-MAR-12 State Tax | 10.2 |  |  | 2012-03-24 00:00:00 | 344067 | 163.15
22-MAR-12 City/Local Tax | 7.28 |  |  | 2012-03-24 00:00:00 | 344068 | 163.15
23-MAR-12 Room Chrg Restricted | 145.67 |  |  | 2012-03-24 00:00:00 | 344107 | 163.15
23-MAR-12 State Tax | 10.2 |  |  | 2012-03-24 00:00:00 | 344120 | 178.76
23-MAR-12 City/Local Tax | 7.28 |  |  | 2012-03-24 00:00:00 | 344176 | 178.76
 |  |  |  | 2012-03-24 00:00:00 | 344266 | 178.76
 | 644.8 |  | 644.8 | 2012-03-24 00:00:00 | 344568 | 178.76
24-MAR-12 336900/Folio |  |  |  | 2012-03-24 00:00:00 | 344616 | 178.76
***Xxxxxxxx, [NAME] |  |  |  | 2012-03-24 00:00:00 | 345769 | 178.76
Voucher/PO #  272776429 |  |  |  | 2012-03-25 00:00:00 | 324084 | 932.19
 |  |  |  | 2012-03-25 00:00:00 | 330847 | 652.6
23-MAR-12 Room Charge Internet | 145.67 |  |  | 2012-03-25 00:00:00 | 330848 | 652.6
23-MAR-12 State Tax | 10.2 |  |  | 2012-03-25 00:00:00 | 332155 | 1212.29
23-MAR-12 City/Local Tax | 7.28 |  |  | 2012-03-25 00:00:00 | 335494 | 715.04
 |  |  |  | 2012-03-25 00:00:00 | 344119 | 715.04
 | 163.15 |  | 163.15 | 2012-03-25 00:00:00 | 344299 | 536.28
24-MAR-12 337126/Folio |  |  |  | 2012-03-25 00:00:00 | 348504 | 201.13
***Xxxx, Andre 509 |  |  |  | 2012-03-25 00:00:00 | 348510 | 182.76
Voucher/PO #  273005489 |  |  |  | 2012-03-25 00:00:00 | 349932 | 182.76
 |  |  |  | 2012-03-25 00:00:00 | 349977 | 127.94
21-MAR-12 Room Charge Internet | 159.61 |  |  | 2012-03-25 00:00:00 | 349978 | 127.94
21-MAR-12 State Tax | 11.17 |  |  | 2012-03-25 00:00:00 | 349990 | 127.94
21-MAR-12 City/Local Tax | 7.98 |  |  | 2012-03-25 00:00:00 | 350012 | 127.94
 |  |  |  | 2012-03-25 00:00:00 | 350016 | 127.94
 |  |  |  | 2012-03-25 00:00:00 | 350020 | 140.8
 |  | ** Con | tinued ** |  | ** C | ontinued **
_x000C_
 |  | Page Numbe | r:   2
 |  | 397 | 2012-03-31 00:00:00 | 397 | 31-M | AR-12
yyyyyyy - #8135 |  |  |  | yyyyyy | y - #8135
11111 N. Xxxxxxx Expres | sway | Attn: |  | 11111 | [NAME] | Expressway
Xxxxxx, XX 00000 |  |  |  | Xxxxxx | , XX 00000
22-MAR-12 Room Charge Internet | 159.61 |  |  | 2012-03-25 00:00:00 | 350021 | 140.8
22-MAR-12 State Tax | 11.17 |  |  | 2012-03-25 00:00:00 | 350022 | 127.94
22-MAR-12 City/Local Tax | 7.98 |  |  | 2012-03-25 00:00:00 | 350023 | 127.94
23-MAR-12 Room Charge Internet | 159.61 |  |  | 2012-03-25 00:00:00 | 350028 | 137.12
23-MAR-12 State Tax | 11.17 |  |  | 2012-03-25 00:00:00 | 350031 | 127.94
23-MAR-12 City/Local Tax | 7.98 |  |  | 2012-03-25 00:00:00 | 350038 | 150.41
 |  |  |  | 2012-03-25 00:00:00 | 350041 | 127.94
 | 536.28 |  | 536.28 | 2012-03-25 00:00:00 | 350050 | 140.8
24-MAR-12 337127/Folio |  |  |  | 2012-03-25 00:00:00 | 350056 | 140.8
***Xxxx, Andre 511 |  |  |  | 2012-03-25 00:00:00 | 350062 | 140.8
Voucher/PO #  273005491 |  |  |  | 2012-03-25 00:00:00 | 350063 | 140.8
 |  |  |  | 2012-03-25 00:00:00 | 350067 | 140.8
21-MAR-12 Room Charge Internet | 159.61 |  |  | 2012-03-25 00:00:00 | 350070 | 140.8
21-MAR-12 State Tax | 11.17 |  |  | 2012-03-25 00:00:00 | 350072 | 140.8
21-MAR-12 City/Local Tax | 7.98 |  |  | 2012-03-25 00:00:00 | 350075 | 140.8
22-MAR-12 Room Charge Internet | 159.61 |  |  | 2012-03-25 00:00:00 | 350078 | 140.8
22-MAR-12 State Tax | 11.17 |  |  | 2012-03-25 00:00:00 | 350080 | 140.8
22-MAR-12 City/Local Tax | 7.98 |  |  | 2012-03-25 00:00:00 | 350081 | 140.8
23-MAR-12 Room Charge Internet | 159.61 |  |  | 2012-03-26 00:00:00 | 340563 | 139.73
23-MAR-12 State Tax | 11.17 |  |  | 2012-03-26 00:00:00 | 340694 | 139.73
23-MAR-12 City/Local Tax | 7.98 |  |  | 2012-03-26 00:00:00 | 344024 | 629.18
 |  |  |  | 2012-03-26 00:00:00 | 349985 | 236.59
 | 536.28 |  | 536.28 | 2012-03-26 00:00:00 | 350045 | 236.59
24-MAR-12 340930/Folio |  |  |  | 2012-03-26 00:00:00 | 350068 | 262.3
***Xxxx, Bradley 650 |  |  |  | 2012-03-26 00:00:00 | 350092 | 108.65
Voucher/PO #  275767813 |  |  |  | 2012-03-26 00:00:00 | 350202 | 108.65
 |  |  |  | 2012-03-26 00:00:00 | 350211 | 121.5
23-MAR-12 Room Charge Internet | 379 |  |  | 2012-03-26 00:00:00 | 350228 | 117.83
23-MAR-12 State Tax | 26.53 |  |  | 2012-03-26 00:00:00 | 350249 | 108.65
23-MAR-12 City/Local Tax | 18.95 |  |  | 2012-03-27 00:00:00 | 349417 | 200.45
24-MAR-12 -Adj Room Chrg Opaqu |  | -233.33 |  | 2012-03-27 00:00:00 | 350212 | 230.15
24-MAR-12 Adj State Tax |  | -16.33 |  | 2012-03-27 00:00:00 | 350326 | 121.5
24-MAR-12 Adj City/Local Tax |  | -11.67 |  | 2012-03-27 00:00:00 | 350502 | 134.37
 |  |  |  | 2012-03-27 00:00:00 | 350503 | 134.37
 | 424.48 | -261.33 | 163.15 | 2012-03-27 00:00:00 | 350504 | 134.37
 |  |  |  | 2012-03-27 00:00:00 | 350565 | 121.5
 |  | ** Con | tinued ** |  | ** C | ontinued **
_x000C_
 |  | Page Numbe | r:   3
 |  | 397 | 2012-03-31 00:00:00 | 397 | 31-M | AR-12
yyyyyyy - #8135 |  |  |  | yyyyyy | y - #8135
11111 N. Xxxxxxx Expres | sway | Attn: |  | 11111 | [NAME] | Expressway
Xxxxxx, XX 00000 |  |  |  | Xxxxxx | , XX 00000
24-MAR-12 343637/Folio |  |  |  | 2012-03-27 00:00:00 | 350600 | 130.68
***Xxxxxxxx, Camila 448 |  |  |  | 2012-03-27 00:00:00 | 350620 | 121.5
Voucher/PO #  277585750 |  |  |  | 2012-03-27 00:00:00 | 350625 | 121.5
 |  |  |  | 2012-03-28 00:00:00 | 344071 | 174.61
20-MAR-12 Deposit Applied |  | -489.45 |  | 2012-03-28 00:00:00 | 350922 | 489.45
20-MAR-12 Room Charge Internet | 138.7 |  |  | 2012-03-29 00:00:00 | 343645 | 310.7
20-MAR-12 State Tax | 9.71 |  |  | 2012-03-29 00:00:00 | 344487 | 466.05
20-MAR-12 City/Local Tax | 6.94 |  |  | 2012-03-30 00:00:00 | 347096 | 194.38
21-MAR-12 Room Chrg Restricted | 145.67 |  |  |  | - | -----------
21-MAR-12 State Tax | 10.2 |  |  | ** Tot | al ** | 19104.64
21-MAR-12 City/Local Tax | 7.28
22-MAR-12 Room Chrg Restricted | 145.67
22-MAR-12 State Tax | 10.2
22-MAR-12 City/Local Tax | 7.28
23-MAR-12 Room Chrg Restricted | 145.67
23-MAR-12 State Tax | 10.2
23-MAR-12 City/Local Tax | 7.28
 | 644.8 | -489.45 | 155.35
24-MAR-12 343639/Folio
***Xxxxxx, Philip 123
Voucher/PO #  277586886
23-MAR-12 Room Charge Internet | 128.53
23-MAR-12 State Tax | 9
23-MAR-12 City/Local Tax | 6.43
 | 143.96 |  | 143.96
24-MAR-12 343728/Folio
***Xxxxx, Jennifer 118
Voucher/PO #  277638233
23-MAR-12 Room Charge Internet | 145.67
23-MAR-12 State Tax | 10.2
 |  | ** Con | tinued ** |  | ** C | ontinued **
_x000C_