tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_germany__2011__Lonestarnom0602
Sheet: June 4, 2002

[NAME]
[NAME]
Dallas, TX  75201-5696
Attention: | Wilma Easter - Scheduling Department |  |  |  | From: | Enron Capital & Trade
Fax: | 214/875-3810 |  |  |  |  | [NAME]
Phone: | 214/875-3296 |  |  |  |  | 713/853-7750 (Phone)
Backup:  [NAME] 214/875-2674 |  |  |  |  |  | 713/345-7374 (Fax)
Contract #LS-MC-1671 |  |  | Start Date: |  | 2002-06-04 00:00:00 |  | End Date: | 2002-06-30 00:00:00
RECEIPT POINT INFORMATION:
 | STATION # | [NAME] | UPSTREAM K# | Previous Day Nom | NOM QUANTITY | FUEL % | NET QUANTITY | Changes
Cinergy | 17-1201-11 | [NAME] | 01T957 | 2000 | 2000 | 0.01 |  | **
Cinergy | 17-1954-50 | Conoco Sterling | Conoco | 8000 | 8000 | 0.01
Cinergy | 17-1240-50 | NNG Sprayberry | 107903 | 10000 | 0 | 0.01
 | 17-1240-50 | NNG Sprayberry | 108301 | 0 | 10000 | 0.01
 | 17-3000-00 | [NAME] | 01T957 | 0 | 0 | 0.01
[NAME] | 17-3000-00 | [NAME] | 2880600203 | 5000 | 5000 | 0.01
[NAME] | 17-1201-11 | [NAME] | REM | 15000 | 15000 | 0.01
 | 18-0006-00 | TW Pecos | 24198 | 5000 | 5000 | 0.01
DELIVERY POINT INFORMATION:
STATION # | [NAME] | UPSTREAM K# |  | Previous Day Nom | NOM QUANTITY | FUEL % | NET QUANTITY
25-0002-00 | Kleburne Plant | 1671 |  | 44550
FYI:  Buy/Sell Information
Cinergy | 17-1201-11 | [NAME] | #01T957 | 0 | 0 | 0 |  | sold to TXU K501 | K2704
Cinergy | 17-1201-11 | [NAME] | #01T957 | 0 | 0 | 0 |  | ** sold to TXU K1901
 |  |  |  |  |  | total sold TXU
Cuts:
Please make all necessary cuts pro ratta per location and counterparty.
Spreadsheet: 220079d1363048454-finding-golf-handicaps-using-best-2-out-of-3-last-rounds-played-golf2012
Sheet: CARDS (2)

A1 | [NAME] |  |  |  |  |  |  | AVERAGE | 6 | 6 | 6.5
A2 | [NAME] |  |  |  |  |  |  |  | 7 | 7
M1 | Crystal Elliott |  |  |  |  |  |  | AVERAGE | 23 | 23 | 18.5
M2 | [NAME] |  |  |  |  |  |  |  | 14 | 14
B1 | [NAME] |  |  |  |  |  |  | AVERAGE | 20 | 20 | 21.5
B2 | [NAME] |  |  |  |  |  |  |  | 23 | 23
D1 | [NAME] |  |  |  |  |  |  | AVERAGE | 17 | 17 | 16.5
D2 | [NAME] |  |  |  |  |  |  |  | 16 | 16
C1 | [NAME] |  |  |  |  |  |  | AVERAGE | 13 | 13 | 17.5
C2 | Amber Lucas |  |  |  |  |  |  |  | 22 | 22
S1 | [NAME] |  |  |  |  |  |  | AVERAGE | 10 | 10 | 12.5
S2 | [NAME] |  |  |  |  |  |  |  | 15 | 15
E1 | [NAME] |  |  |  |  |  |  | AVERAGE | 24 | 24 | 18.5
E2 | [NAME] |  |  |  |  |  |  |  | 13 | 13
N1 | [NAME] |  |  |  |  |  |  | AVERAGE | 24 | 24 | 18.5
N2 | [NAME] |  |  |  |  |  |  |  | 13 | 13
F1 | [NAME] |  |  |  |  |  |  | AVERAGE | 17 | 17 | 10
F2 | [NAME] |  |  |  |  |  |  |  | 3 | 3
H1 | [NAME] |  |  |  |  |  |  | AVERAGE | 10 | 10 | 6
H2 | Jan Keen |  |  |  |  |  |  |  | 2 | 2
[NAME] | [NAME] |  |  |  |  |  |  | AVERAGE | 17 | 17 | 20.5
G2 | Pam Morris |  |  |  |  |  |  |  | 24 | 24
L1 | [NAME] |  |  |  |  |  |  | AVERAGE | 15 | 15 | 19.5
L2 | Dixie Easterday |  |  |  |  |  |  |  | 24 | 24
I1 | [NAME] |  |  |  |  |  |  | AVERAGE | 14 | 14 | 15
I2 | Heather Weberling |  |  |  |  |  |  |  | 16 | 16
K1 | [NAME] |  |  |  |  |  |  | AVERAGE | 21 | 21 | 19.5
K2 | [NAME] |  |  |  |  |  |  |  | 18 | 18
J1 | [NAME] |  |  |  |  |  |  | AVERAGE | 24 | 24 | 22.5
J2 | [NAME] |  |  |  |  |  |  |  | 21 | 21
Q1 | [NAME] |  |  |  |  |  |  | AVERAGE | 22 | 22 | 17.5
Q2 | [NAME] |  |  |  |  |  |  |  | 13 | 13
O1 | [NAME] |  |  |  |  |  |  | AVERAGE | 13 | 13 | 12.5
O2 | [NAME] |  |  |  |  |  |  |  | 12 | 12
T1 | [NAME] |  |  |  |  |  |  | AVERAGE | 6 | 6 | 13.5
T2 | Pam MacQuaig |  |  |  |  |  |  |  | 21 | 21
L1 | [NAME] |  |  |  |  |  |  |  | 15 | 15
L2 | Dixie Easterday |  |  |  |  |  |  |  | 24 | 24
S1 | [NAME] |  |  |  |  |  |  |  | 10 | 10
S2 | [NAME] |  |  |  |  |  |  |  | 15 | 15
 | 1900-01-01 00:00:00
P1 | [NAME] |  |  |  |  |  |  | AVERAGE | 31 | 31 | 19.5
P2 | [NAME] |  |  |  |  |  |  |  | 8 | 8
R1 | [NAME] |  |  |  |  |  |  | AVERAGE | 25 | 25 | 16.5
R2 | [NAME] |  |  |  |  |  |  |  | 8 | 8
Spreadsheet: 173495d1344576366-calculation-of-annual-leave-youngjeesu_851855_09aug12_03
Sheet: Sheet1

Employee | Date of Commencement |  | Leave Entitlement  as of today |  | Leave Entitlement  by end of 2012 | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Total leave taken taken | Balance leave left
[NAME] | 2009-09-01 00:00:00
[NAME] | 2011-05-08 00:00:00
[NAME] | 2010-08-07 00:00:00
 | 2009-10-15 00:00:00
Spreadsheet: errol_mclaughlin_jr__10120__Chase-Stoneville Model 12_29_00
Sheet: Cash Flows & M2M

PV Cash Flows based on Libor mid curve |  |  |  |  |  |  |  |  |  |  | Nominal Cash Flows |  |  |  | M2M by month and year
As of:
Month | IF-TRANSCO/Z3 |  | Total |  | IF-TRANSCO/Z3 |  | Total |  | Price |  | IF-TRANSCO/Z3 |  | Total |  | IF-TRANSCO/Z3 |  |  | IF-TRANSCO/Z3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year 5
Spreadsheet: 102106d1300144077-lookup-function-help-test_3_14
Sheet: EFIN

EFIN | Store Number
360758 | 168
361105 | 177
363809 | 228
368582 | 149
370647 | 237
370788 | 246
370789 | 245
370861 | 255
372613 | 87
372614 | 106
372615 | 113
372618 | 115
372619 | 83
372620 | 82
372714 | 147
372833 | 88
372834 | 136
372835 | 65
372983 | 153
372984 | 150
373199 | 167
373213 | 176
430806 | 212
431527 | 231
431531 | 230
431532 | 229
431657 | 234
431663 | 238
431666 | 242
432134 | 249
432213 | 289
433279 | 271
433319 | 279
433334 | 275
433725 | 284
435130 | 141
435135 | 138
435136 | 93
435137 | 72
435533 | 144
435534 | 79
435535 | 117
435536 | 139
435537 | 78
435539 | 94
435540 | 142
435541 | 85
435848 | 151
596952 | 258
620588 | 185
621074 | 219
621076 | 211
621097 | 221
621992 | 241
621993 | 240
622118 | 236
622452 | 288
622454 | 247
622558 | 260
622639 | 291
622640 | 251
622642 | 250
623686 | 263
625978 | 154
625979 | 157
625980 | 158
625981 | 156
625982 | 155
626698 | 162
626699 | 285
626700 | 159
626701 | 172
626702 | 171
626703 | 163
626704 | 286
626705 | 210
626706 | 170
626807 | 181
626808 | 178
626809 | 173
626811 | 182
630878 | 225
632460 | 248
632462 | 244
634258 | 264
634259 | 265
634262 | 266
634321 | 273
730200 | 294
730712 | 220
730716 | 209
730718 | 207
730719 | 206
730720 | 205
730721 | 213
730722 | 204
730723 | 203
730724 | 202
730725 | 201
730727 | 200
731358 | 233
732617 | 268
732620 | 269
732623 | 270
732630 | 278
733721 | 29
733999 | 92
734000 | 46
734001 | 48
734003 | 25
734004 | 140
734005 | 24
734006 | 95
740371 | 184
740373 | 186
740374 | 192
740375 | 187
740376 | 193
740380 | 194
740382 | 188
740385 | 259
740386 | 190
740387 | 183
740647 | 199
742804 | 235
745232 | 274
747234 | 63
747235 | 18
747236 | 76
747237 | 120
747239 | 127
747240 | 1
747241 | 7
747242 | 9
747243 | 110
747244 | 123
747245 | 12
747246 | 86
747247 | 68
747248 | 10
747250 | 5
747864 | 14
747866 | 4
747867 | 8
747868 | 119
747869 | 3
747870 | 124
747871 | 109
747872 | 2
747873 | 22
747874 | 6
747875 | 17
747876 | 11
748975 | 169
749238 | 175
759013 | 58
759015 | 160
759016 | 27
759019 | 114
759020 | 103
759021 | 36
759022 | 280
759023 | 26
759024 | 122
759025 | 111
759633 | 105
759636 | 71
759637 | 102
759638 | 116
759639 | 118
759641 | 28
759643 | 21
759644 | 23
759646 | 55
759647 | 15
760340 | 198
761128 | 218
761131 | 216
762385 | 281
762610 | 232
765115 | 283
765128 | 133
765130 | 189
767306 | 13
767307 | 20
767308 | 100
767310 | 91
767821 | 101
767822 | 43
767823 | 107
767824 | 108
768994 | 174
841638 | 287
841648 | 282
850046 | 195
850047 | 196
850049 | 197
850277 | 292
850659 | 276
851772 | 60
851773 | 84
851774 | 53
851775 | 125
851776 | 81
851777 | 64
851778 | 50
851779 | 62
851780 | 166
851781 | 130
851784 | 34
851964 | 32
851965 | 143
851966 | 44
851967 | 45
851968 | 129
851969 | 52
851970 | 51
851971 | 98
851972 | 59
851973 | 30
851975 | 49
851976 | 128
852298 | 180
880456 | 214
880989 | 243
881867 | 293
881868 | 57
881921 | 145
882047 | 73
882048 | 74
882049 | 70
882051 | 148
Spreadsheet: 102268d1300228525-random-item-number-equals-correct-price-using2010
Sheet: Cabinets Detail

ESTIMATE OF WORK
 |  |  |  |  |  |  | Date:
Contractor: | LaMorinda Tile and Stone |  |  | Job Name:
Address: | 2261 Commerce Ave., Suite B |  |  | Address:
City: | Concord, CA 94520 |  |  | City:
Phone: | [PHONE] |  |  | Phone:
Fax : | [PHONE] |  |  | Fax:
[NAME]: | [EMAIL] |  |  | [NAME]:
Detail of Work
Kitchen Cabinets Modular
 | [NAME] and doors
 | Solid maple plywood interiors
 | [NAME]-close slides
 | Pre-finished dovetail maple drawers
 | Standard Adjustable hinges
 | Adjustable shelves
 | Door type: Overlay
 |  | Door Style:
 |  | Drawer 5-piece to match door style
Item | Description of Job |  |  |  |  | Quantity | Price EA | Price
A7TK8 |  |  |  |  |  | 5
J5CM10 |  |  |  |  |  | 6
 |  |  |  |  |  |  | Discount
 |  |  |  |  |  |  | Sub Total
 |  |  |  |  |  |  | Tax
 |  |  |  |  |  |  | Total
Assembly |  |  |  |  |  |  | 15
Installation
 | Mounting all Cabinets
 | Installing all mouldings
 | Installing door pulls
NOTE: | Cabinets do not come with pulls
 |  |  |  |  |  |  | Total:
 | Accepted by:
 | Client |  |  |  |  |  | Date
Spreadsheet: 778386d1651045711-find-last-value-vertically-based-on-other-criteria-multiple-column-array-lastcolumnvaluebasedoncondition
Sheet: Sheet1

1 | 2 | 3 | 4 | 5
10 | 5 | 1 | 14 | 10
20 | 9 | 2 | 5 | 0
13 | 0 | 0 | 9 | 0 |  |  |  | 1 | 13
 |  |  |  |  |  |  |  | 2 | 9
 |  |  |  |  |  |  |  | 3 | 2
 |  |  |  |  |  |  |  | 4 | 9
 |  |  |  |  |  |  |  | 5 | 10
Spreadsheet: 293e4856-3654-45a1-ad40-f11296ee84a9
Sheet: FB Survey Information

Farm [NAME] |  |  |  |  | Survey Summary* |  |  |  |  | Survey Method, Diagnostics, & Assistance |  |  |  |  |  | FUNDING
State | Farm [NAME] | Genus | Species | [NAME] or Disease | Survey Dates (Starting-Ending) | Number of Sites | Number of Traps / Visual surveys | Total Number of Visits | Possible Total Number of Collections | [NAME] | Lure | State lab diagnostics available? | Name(s) and affiliation of taxonomist or diagnostician | Is PPQ ID assistance required in addition to final confimation? | If yes, what type of assistance is needed? | FY12 Funding | State Cooperator Share
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Instructions: Please fill in each column. List all target species for each survey.
Use scroll bar at bottom right to see all columns.
[NAME] rows as necessary to list all target pests.
Spreadsheet: 115988d1311446928-using-lookup-with-two-variables-and-less-than-greater-than-constraints-lookup-using-two-variables-help-bvj-
Sheet: Sheet1

 | Capacity: |  |  | 1
 | Resolution: |  |  | 0.001
 | Displacement Per Revolution: |  |  | 0.1
 | Calibration Standard | Verification Reading #1 | Verification Reading #2 | Verification Reading #3 | Tolerance ± | Revolutions
 | 0 | 0 | 0 | 0 | 0 | 0
 | 0.225 |  |  |  |  | 2.25
 | 0.45 |  |  |  |  | 4.5
 | 0.675 |  |  |  |  | 6.75
 | 0.8 |  |  |  |  | 8
 | 1 |  |  |  |  | 10
 | 0.8
 | 0.675
 | 0.45
 | 0.225
 | 0
 | Tolerance Table
 | Resolution Inches |  | Hysteresis |  | 1 | 2.5 | 2.51 | 10
 | 5e-05 |  | 1 |  | 1 | 1 | 4
 | 0.0001 |  | 1 |  | 1 | 1 | 3 | 4
 | 0.0005 |  | 0.33 |  | 1 | 1 | 3 | 4
 | 0.001 |  | 0.33 |  | 1 | 1 | 2 | 4
Spreadsheet: 07296c68-386c-439e-ae6d-c17a93d8cce3
Sheet: 3

THE ALLSTATE CORPORATION
REVENUES
($ in millions)
 |  |  | Three months ended |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Twelve months ended
 |  |  |  | Dec. 31, |  |  | Sept. 30, |  |  | June 30, |  |  | March 31, |  |  | Dec. 31, |  |  | Sept. 30, |  |  | June 30, |  |  | March 31, |  |  | Dec. 31, |  |  | Dec. 31,
 |  |  |  | 2012 |  |  | 2012 |  |  | 2012 |  |  | 2012 |  |  | 2011 |  |  | 2011 |  |  | 2011 |  |  | 2011 |  |  | 2012 |  |  | 2011
Property-Liability
 | Property-liability insurance premiums |  | $ | 6744 |  | $ | 6697 |  | $ | 6666 |  | $ | 6630 |  | $ | 6605 |  | $ | 6432 |  | $ | 6457 |  | $ | 6448 |  | $ | 26737 |  | $ | 25942
 | Net investment income |  |  | 362 |  |  | 299 |  |  | 352 |  |  | 313 |  |  | 309 |  |  | 298 |  |  | 310 |  |  | 284 |  |  | 1326 |  |  | 1201
 | Realized capital gains and losses |  |  | 143 |  |  | -16 |  |  | 19 |  |  | 189 |  |  | 12 |  |  | 24 |  |  | -8 |  |  | 57 |  |  | 335 |  |  | 85
 |  | Total Property-Liability revenues |  | 7249 |  |  | 6980 |  |  | 7037 |  |  | 7132 |  |  | 6926 |  |  | 6754 |  |  | 6759 |  |  | 6789 |  |  | 28398 |  |  | 27228
Allstate Financial
 | Life and annuity premiums and contract charges |  |  | 566 |  |  | 563 |  |  | 559 |  |  | 553 |  |  | 570 |  |  | 552 |  |  | 547 |  |  | 569 |  |  | 2241 |  |  | 2238
 | Net investment income |  |  | 665 |  |  | 632 |  |  | 663 |  |  | 687 |  |  | 656 |  |  | 682 |  |  | 694 |  |  | 684 |  |  | 2647 |  |  | 2716
 | Realized capital gains and losses |  |  | 56 |  |  | -56 |  |  | 8 |  |  | -21 |  |  | 68 |  |  | 219 |  |  | 62 |  |  | 39 |  |  | -13 |  |  | 388
 |  | Total Allstate Financial revenues |  | 1287 |  |  | 1139 |  |  | 1230 |  |  | 1219 |  |  | 1294 |  |  | 1453 |  |  | 1303 |  |  | 1292 |  |  | 4875 |  |  | 5342
Corporate and Other
 | Service fees (1) |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 2 |  |  | 1 |  |  | 2 |  |  | 2 |  |  | 4 |  |  | 7
 | Net investment income |  |  | 6 |  |  | 9 |  |  | 11 |  |  | 11 |  |  | 10 |  |  | 14 |  |  | 16 |  |  | 14 |  |  | 37 |  |  | 54
 | Realized capital gains and losses |  |  | 5 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 6 |  |  | 21 |  |  | 3 |  |  | 0 |  |  | 5 |  |  | 30
 |  | Total Corporate and Other revenues before
 |  | reclassification of services fees |  | 12 |  |  | 10 |  |  | 12 |  |  | 12 |  |  | 18 |  |  | 36 |  |  | 21 |  |  | 16 |  |  | 46 |  |  | 91
 |  | Reclassification of service fees (1) |  | -1 |  |  | -1 |  |  | -1 |  |  | -1 |  |  | -2 |  |  | -1 |  |  | -2 |  |  | -2 |  |  | -4 |  |  | -7
 |  | Total Corporate and Other revenues |  | 11 |  |  | 9 |  |  | 11 |  |  | 11 |  |  | 16 |  |  | 35 |  |  | 19 |  |  | 14 |  |  | 42 |  |  | 84
Consolidated revenues |  |  | $ | 8547 |  | $ | 8128 |  | $ | 8278 |  | $ | 8362 |  | $ | 8236 |  | $ | 8242 |  | $ | 8081 |  | $ | 8095 |  | $ | 33315 |  | $ | 32654
(1) | For presentation in the Consolidated Statements of Operations, service fees of the Corporate and Other segment are reclassified to Operating costs and expenses.
Spreadsheet: 749385d1632767020-return-highest-value-for-repeating-lookup-values-sample
Sheet: Sample Data

Part | Last used date |  |  |  |  | Lookup
1001 | 2020-01-01 00:00:00
1002 | 2020-05-02 00:00:00 |  |  |  |  | Part | 1001
1003 | 2020-06-03 00:00:00 |  |  |  |  | Last used | 2021-01-06 00:00:00 | --> | Expected result
1004 | 2020-01-06 00:00:00
1001 | 2020-02-04 00:00:00
1002 | 2020-03-08 00:00:00
1003 | 2020-02-06 00:00:00
1004 | 2020-05-06 00:00:00
1001 | 2021-01-06 00:00:00
1002 | 2021-08-08 00:00:00
1003 | 2021-04-05 00:00:00
1004 | 2021-07-09 00:00:00
Spreadsheet: 120887d1315601801-looking-up-a-value-and-returning-a-list-book1
Sheet: Data

Branch | Employee #
A | 1
A
A
A
A
A
A
A
A
A
A
A
A
A
A
B
B
B
B
B
B
B
B
C
C
C
C
C
C
C
Spreadsheet: 1ad1d4b5-166a-4e72-8db9-4e28a2ee84a7
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
VDSF | Test | VDSF | VDRL, Spinal Fluid | VDRL, CSF | Floculation/Agglutination | Plastic vial: PlV |  |  | 0.5 | mL | Collection Container/Tube: Sterile vial Submission Container/Tube: Plastic vial	 [NAME]: 0.5 mL | 0.2 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | Negative Positive results will be titered. | Monday through Friday 12 p.m. | 1 day | 3 days | 1 | 86592 |  |  |  |  | Rochester
VDSF | [NAME] | CSF | CSF |  |  |  | Frozen | 14 days
VDSF | Result | 9028 | VDRL, CSF | VDRL, CSF | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5290-2
Spreadsheet: 876796d1723520269-reference-formula-to-repeat-x-numbers-of-rows-repeat-row
Sheet: Sheet1

Key | Person 1 | Person 2 | Person 3 | Person 4
K123 | [NAME] | [NAME]
B456 | [NAME] | Will | Anna
…
Result Needed
Key
K123
K123
B456
B456
B456
…
Spreadsheet: 791672d1660547051-special-selection-and-listing-of-data-template_petty-cash
Sheet: Lookup

Period | Period Option2
Months | Periods |  | Reference | Code | Description
2022-07-01 00:00:00 | 13 |  | C | 8520010 | Cash | c
2022-08-01 00:00:00 | 02 |  | T | 8520020 | Transfer |  |  |  | formula 2
2022-09-01 00:00:00 | 03 |  | S | 8520030 | Speedpoint
2022-10-01 00:00:00 | 04 |  | CA | 9990000 | Cancelled
2022-11-01 00:00:00 | 05
2022-12-01 00:00:00 | 06
2023-01-01 00:00:00 | 07
2023-02-01 00:00:00 | 08
2023-03-01 00:00:00 | 09
2023-04-01 00:00:00 | 10
2023-05-01 00:00:00 | 11
2023-06-01 00:00:00 | 12
2023-07-01 00:00:00 | 13
2023-08-01 00:00:00 | 02
2023-09-01 00:00:00 | 03
2023-10-01 00:00:00 | 04
2023-11-01 00:00:00 | 05
2023-12-01 00:00:00 | 06
2024-01-01 00:00:00 | 07
2024-02-01 00:00:00 | 08
2024-03-01 00:00:00 | 09
2024-04-01 00:00:00 | 10
2024-05-01 00:00:00 | 11
2024-06-01 00:00:00 | 12
 | VAT Rate | 101
 | 15 | 101
Spreadsheet: 728683d1618576720-rank-based-on-values-in-2-colums-book2-autorecovered-
Sheet: Sheet1

 |  | Rank | Custo Code | VIP
 |  | 1 | 10000223384 | VIPS1176
 |  | 2 | 10000223384 | VIPS1239
 |  |  | 10000223384 | VIPS1239
 |  | 3 | 10000223384 | VIPS1319
 |  |  | 10000223384 | VIPS1319
 |  | 4 | 10000223384 | VIPS1320
 |  |  | 10000223384 | VIPS1320
 |  |  | 10000223384 | VIPS1320
 |  |  | 10000223384 | VIPS1320
 |  | 5 | 10000223384 | VIPS1321
 |  |  | 10000223384 | VIPS1321
 |  |  | 10000223384 | VIPS1321
 |  |  | 10000223384 | VIPS1321
 |  | 6 | 10000223384 | VIPS1322
 |  |  | 10000223384 | VIPS1322
 |  | 7 | 10000223384 | VIPS1440
 |  |  | 10000223384 | VIPS1440
 |  | 8 | 10000223384 | VIPS1529
 |  |  | 10000223384 | VIPS1529
 |  | 9 | 10000223384 | VIPS16622
 |  |  | 10000223384 | VIPS16622
 |  | 10 | 10000223384 | VIPS17505
 |  |  | 10000223384 | VIPS17505
 |  | 1 | 10000223385 | VIPS17505
 |  |  | 10000223385 | VIPS17505
 |  |  | 10000223385 | VIPS17505
 |  |  | 10000223385 | VIPS17505
 |  | 2 | 10000223385 | VIPS17506
 |  |  | 10000223385 | VIPS17506
 |  | 3 | 10000223385 | VIPS17507
 |  |  | 10000223385 | VIPS17507
 |  |  | 10000223385 | VIPS17507
 |  |  | 10000223385 | VIPS17507
 |  |  | 10000223385 | VIPS17507
 |  |  | 10000223385 | VIPS17507
 |  |  | 10000223385 | VIPS17507
 |  |  | 10000223385 | VIPS17507
 |  | 1 | 10000223387 | VIPS17508
 |  |  | 10000223387 | VIPS17508
 |  |  | 10000223387 | VIPS17508
 |  |  | 10000223387 | VIPS17508
 |  |  | 10000223387 | VIPS17508
 |  |  | 10000223387 | VIPS17508
 |  |  | 10000223387 | VIPS17508
 |  |  | 10000223387 | VIPS17508
 |  | 2 | 10000223387 | VIPS17509
 |  |  | 10000223387 | VIPS17509
 |  |  | 10000223387 | VIPS17509
 |  |  | 10000223387 | VIPS17509
 |  | 3 | 10000223387 | VIPS18222
 |  |  | 10000223387 | VIPS18222
 |  |  | 10000223387 | VIPS18222
 |  |  | 10000223387 | VIPS18222
 |  |  | 10000223387 | VIPS18222
 |  |  | 10000223387 | VIPS18222
 |  | 4 | 10000223387 | VIPS18224
 |  |  | 10000223387 | VIPS18224
 |  |  | 10000223387 | VIPS18224
 |  |  | 10000223387 | VIPS18224
 |  |  | 10000223387 | VIPS18224
 |  |  | 10000223387 | VIPS18224
 |  |  | 10000223387 | VIPS18224
 |  |  | 10000223387 | VIPS18224
 |  | 5 | 10000223387 | VIPS18225
 |  |  | 10000223387 | VIPS18225
 |  |  | 10000223387 | VIPS18225
 |  |  | 10000223387 | VIPS18225
 |  |  | 10000223387 | VIPS18225
 |  | 6 | 10000223387 | VIPS18229
 |  |  | 10000223387 | VIPS18229
 |  |  | 10000223387 | VIPS18229
 |  |  | 10000223387 | VIPS18229
 |  |  | 10000223387 | VIPS18229
 |  |  | 10000223387 | VIPS18229
 |  |  | 10000223387 | VIPS18229
 |  | 7 | 10000223387 | VIPS18440
 |  |  | 10000223387 | VIPS18440
 |  |  | 10000223387 | VIPS18440
 |  |  | 10000223387 | VIPS18440
 |  |  | 10000223387 | VIPS18440
 |  |  | 10000223387 | VIPS18440
 |  |  | 10000223387 | VIPS18440
 |  |  | 10000223387 | VIPS18440
 |  |  | 10000223387 | VIPS18440
 |  |  | 10000223387 | VIPS18440
Spreadsheet: 769487d1645554786-unique-count-average-percentage-and-weekly-breakdown-member-check-ins-average-check-ins-testing
Sheet: List of Members

Account  Number | First Name | Last Name | Age | Check-In  Date/Time | Week
11 | First 1 | Last 1 | 13 | 2022-01-01 11:24:54 | 1
11 | First 1 | Last 1 | 13 | 2022-01-03 15:04:58 | 1
11 | First 1 | Last 1 | 13 | 2022-01-05 11:24:54 | 1
11 | First 1 | Last 1 | 13 | 2022-01-20 15:04:58 | 3
22 | First 2 | Last 2 | 15 | 2022-01-11 16:25:11 | 2
22 | First 2 | Last 2 | 15 | 2022-01-18 16:38:46 | 3
22 | First 2 | Last 2 | 15 | 2022-01-20 16:38:46 | 3
22 | First 2 | Last 2 | 15 | 2022-01-21 16:25:11 | 3
22 | First 2 | Last 2 | 15 | 2022-01-29 16:38:46 | 4
33 | First 3 | Last 3 | 21 | 2022-01-20 16:38:46 | 3
33 | First 3 | Last 3 | 21 | 2022-01-21 16:38:46 | 3
Spreadsheet: 173123d1344441140-using-a-mastersheet-to-populate-a-sheet-with-different-formating-jbsmithee-example
Sheet: Sheet1

Part Description | Vendor | Vendor part # | Manufacturer | MFG Part # | Qty | Per Unit Value | Total Value
Power Supply | Electronics | 2134JGH332 | Tech-retail-r-us | A8372 | 1 | 23
Motherboard | Electronics | 12344FKM5 | Tech-retail-r-us | A3264 | 2 | 34
Rollerskates | Roller-Fun | 234KSDD334 | Fun-retail-r-us | 1SD04 | 3 | 54
Skateboard | Roller-Fun | 2234DFE234 | Fun-retail-r-us | 324AD | 4 | 12
sunglasses | Fun-N-sun | 132SDFSFD3 | Fun-retail-r-us | [NAME] | 5 | 12
spoons | [NAME] | SDFSFD2234 | Dine-retail-r-us | 4332AS | 6 | 45
Spreadsheet: 858712d1707298162-redistribute-data-contained-in-a-single-cell-to-multiple-cells-exampledata
Sheet: Sheet1

Unique ID | Date Ranges
1 | AAAAAA BBBBBB |  |  |  |  |  |  | AAAAAA
2 | AAAAAA BBBBBB CCCCCC DDDDDD |  |  |  |  |  | 1 | BBBBBB
3 | [NAME] |  |  |  |  |  | 2 | AAAAAA
4 | YYYYYYY ZZZZZZZ |  |  |  |  |  | 2 | BBBBBB
5 | FFFFFFF GGGGG HHHHH |  |  |  |  |  | 2 | CCCCCC
 |  |  |  |  |  |  | 2 | [NAME]
 |  |  |  |  |  |  | 3 | [NAME]
 |  |  |  |  |  |  | 4 | YYYYYYY
 |  |  |  |  |  |  | 4 | ZZZZZZZ
 |  |  |  |  |  |  | 5 | FFFFFFF
 |  |  |  |  |  |  | 5 | GGGGG
 |  |  |  |  |  |  | 5 | HHHHH