tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 718997d1613465008-single-formula-conditional-formatting-for-3-criteria-tsm-schedule-1-
Sheet: Sheet1

 | Customer | Frequency | Last TSM |  |  |  | Customer | Frequency | Last TSM | Column1 |  |  |  | Customer | Frequency | Last TSM
 | Customer 2 | Monthly | 2020-03-10 00:00:00 | What I have | What I want |  | Customer 2 | Monthly | 2020-03-10 00:00:00 |  |  |  | 1 | Customer 2 | Monthly | 2020-03-10 00:00:00
 | Customer 3 | Monthly | 2020-10-10 00:00:00 | <----- | -----> |  | Customer 3 | Monthly | 2020-10-10 00:00:00 |  |  |  | 2 | Customer 3 | Monthly | 2020-10-10 00:00:00
 | Customer 1 | Monthly | 2021-02-10 00:00:00 |  |  |  | Customer 1 | Monthly | 2021-02-10 00:00:00 |  |  |  | 3 | Customer 1 | Monthly | 2021-02-10 00:00:00
 | Customer 4 | Quarterly | 2020-04-29 00:00:00 |  |  |  | Customer 4 | Quarterly | 2020-04-29 00:00:00 |  |  |  | 4 | Customer 4 | Quarterly | 2020-04-29 00:00:00
 | Customer 6 | Quarterly | 2020-01-22 00:00:00 |  |  |  | Customer 6 | Quarterly | 2020-01-22 00:00:00 |  |  |  | 5 | Customer 6 | Quarterly | 2020-01-22 00:00:00
 | Customer 7 | Quarterly | 2020-08-12 00:00:00 |  |  |  | Customer 7 | Quarterly | 2020-08-12 00:00:00 |  |  |  | 6 | Customer 7 | Quarterly | 2020-08-12 00:00:00
 | Customer 5 | Quarterly | 2020-12-11 00:00:00 |  |  |  | Customer 5 | Quarterly | 2020-12-11 00:00:00 |  |  |  | 7 | Customer 5 | Quarterly | 2020-12-11 00:00:00
 | Customer 14 | Quarterly | 2021-01-15 00:00:00 |  |  |  | Customer 14 | Quarterly | 2021-01-15 00:00:00 |  |  |  | 8 | Customer 14 | Quarterly | 2021-01-15 00:00:00
 | Customer 13 | Quarterly | 2021-02-10 00:00:00 |  |  |  | Customer 13 | Quarterly | 2021-02-10 00:00:00 |  |  |  | 9 | Customer 13 | Quarterly | 2021-02-10 00:00:00
 | Customer 8 | Semi-Anually | 2020-01-28 00:00:00 |  |  |  | Customer 8 | Semi-Anually | 2020-01-28 00:00:00 |  |  |  | 10 | Customer 8 | Semi-Anually | 2020-01-28 00:00:00
 | Customer 9 | Semi-Anually | 2020-11-01 00:00:00 |  |  |  | Customer 9 | Semi-Anually | 2020-11-01 00:00:00 |  |  |  | 11 | Customer 9 | Semi-Anually | 2020-11-01 00:00:00
 | Customer 15 | Semi-Anually | 2021-02-01 00:00:00 |  |  |  | Customer 15 | Semi-Anually | 2021-02-01 00:00:00 |  |  |  | 12 | Customer 15 | Semi-Anually | 2021-02-01 00:00:00
 | Customer 11 | Anually | 2020-03-11 00:00:00 |  |  |  | Customer 11 | Anually | 2020-03-11 00:00:00 |  |  |  | 13 | Customer 11 | Anually | 2020-03-11 00:00:00
 | Customer 12 | Anually | 2020-08-12 00:00:00 |  |  |  | Customer 12 | Anually | 2020-08-12 00:00:00 |  |  |  | 14 | Customer 12 | Anually | 2020-08-12 00:00:00
 | Customer 10 | Anually | 2020-10-10 00:00:00 |  |  |  | Customer 10 | Anually | 2020-10-10 00:00:00 |  |  |  | 15 | Customer 10 | Anually | 2020-10-10 00:00:00
 | Total |  |  |  |  |  | Total |  |  |  |  |  |  | Total
Spreadsheet: 82658f30-71a0-4bdd-853b-968f94ac41de
Sheet: Sheet1

Table S4. List of HVS-I mtDNA SNPs identified across populations used in this study. List of 185 SNPs across populations in the range 16090 and 16365 representing the most informative common set of HVS-I markers reported.
SNP Count = 185
16091
16092
16093
16094
16096
16102
16104
16108
16109
16111
16112
16114
16117
16124
16126
16129
16131
16132
16133
16134
16136
16137
16138
16139
16140
16141
16142
16144
16145
16146
16147
16148
16150
16152
16153
16154
16157
16158
16161
16162
16164
16165
16167
16168
16169
16170
16172
16173
16174
16176
16177
16178
16179
16181
16182
16184
16185
16186
16187
16188
16189
16191
16192
16194
16195
16197
16201
16203
16206
16207
16209
16212
16213
16214
16215
16216
16217
16218
16219
16220
16221
16222
16223
16224
16225
16227
16228
16229
16230
16231
16232
16233
16234
16235
16239
16240
16241
16242
16243
16244
16245
16246
16247
16248
16249
16250
16251
16252
16254
16255
16256
16257
16258
16259
16260
16261
16262
16263
16264
16265
16266
16267
16269
16270
16271
16272
16274
16275
16278
16280
16284
16286
16287
16288
16289
16290
16291
16292
16293
16294
16295
16296
16297
16298
16299
16300
16301
16302
16303
16304
16305
16309
16310
16311
16312
16313
16316
16317
16318
16319
16320
16324
16326
16327
16328
16329
16330
16335
16336
16340
16342
16343
16344
16345
16346
16352
16353
16354
16355
16356
16357
16359
16360
16362
16365
Spreadsheet: 274777d1383217866-perform-a-vlookup-between-worksheets-biscuits
Sheet: Sheet1

Biscuit type | Location | Model | Customer | Order status
Bourbon | Germany | Regular | Tesco | Live
Digestive | UK | Caramel | Tesco | Live
Wagon wheel | Uk | Jam | Tesco | Archived
Cadburrys finger | UK | Regular | Asda | Archived
jam rolls | Switzerland | Regular | Asda | Live
tunnocks wafer | Germany | Regular | Tesco | Live
oatcake | Switzerland | Regular | Asda | Live
[NAME] | UK | Regular | Asda | Live
club | Germany | Orange | Tesco | Live
pengine | Switzerland | Mint | Tesco | Live
Spreadsheet: 793483d1661505383-remove-unwanted-0-from-a-contact-formula-book1
Sheet: Manhole BoQ

 |  |  |  |  |  |  | HYDROBREAKS |  | CHAINS |  | AMPS |  | Access Ladders (Greater than 3m) |  | BACK DROPS
 | Precast concrete manholes Precast concrete straight shaft manholes; excavation, disposal On site, earthwork support, levelling and compacting bottoms,  225 thick RC30 grade in-situ concrete bed, precast concrete chamber rings with proprietary bitumen or resin mastic sealant, 150 thick RC30 grade in situ concrete surround, formwork, benching and channels with high strength concrete  topping minimum 20 thick, heavy duty precast concrete cover slab on class B engineering brick raising courses, 150 high, bedded in cement mortar, galvanised mild steel step irons (unless ladder indicated in desc below) at 300 centres, backfilling with granular material; manhole cover and frame. |  |  |  |  |  | Type | Provide Cost | Type | Provide Cost | Type | Provide Cost | Y/N | From MH Rates | Type | [NAME] to Provide Cost |  | [NAME] from | Depth Range to
on this row the 1.5 needs to be rounded to 1.50 and the 2 also needs rounding to 2.00. Also where there are no [NAME], Chains, Amps, Ladders, Backdrops, the text needs to be blank and not show all the zeros |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.5 | 2
as above for the 1.50. where there ar no ladders or backdrop, it needs to show nothing and not the zeros, So it should only show Hydrobrake; AMPS and then nothing |  |  |  |  |  |  | Hydrobrake |  |  | 0 | AMPS |  |  |  |  |  |  | 1.25 | 1.5
Spreadsheet: 69945d1270604394-pulling-data-from-another-sheet-with-drop-down-menu-copy-of-testsports
Sheet: Sheet1

Name: | [NAME]
Date: | Date
Address: | Address
Pick a sport: | NBA
Who will win the next title? | Celtics
12 | rows
2010-03-01 00:00:00 | @ | Celtics | CELTICS
2010-03-02 00:00:00 | vs | Cavaliers | CELTICS
2010-03-03 00:00:00 | vs | Magic | CELTICS
2010-03-04 00:00:00 | @ | Spurs | CELTICS
2010-03-05 00:00:00 | @ | Nets | CELTICS
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
2010-03-01 00:00:00 | @ | Celtics | MAGIC
2010-03-02 00:00:00 | vs | Cavaliers | MAGIC
Spreadsheet: 96944d1296172419-excel-2007-how-to-automatically-populate-data-test1
Sheet: Sheet4

 |  |  | 2010-02-01 00:00:00 | 2010-02-28 00:00:00 | 2010-03-01 00:00:00 | 2010-03-31 00:00:00
 | Assets
 |  | Acquisitions |  | 550000 |  | 645000
 |  | Premiums |  | 0 |  | 118000
 | Current Assets |  |  | 550000 |  | 763000
 | Cash from Investing Activities
 |  | Capital Calls |  | 551000 |  | 828000
 |  | Acquisitions |  | -550000 |  | -763000
 |  | Total Cash |  | 1000 |  | 65000
 | Total Assets |  |  | 551000 |  | 828000
 | Libabilities
 |  | Account Expense (paid) |  | 120.9 |  | 60074.96
Spreadsheet: 799570d1665148825-how-to-perform-a-three-way-check-book1
Sheet: Sheet1

EOB LIST | EOB/BATCH NUM. | CHECK NUM. | DUP./ UNIQUE | [NAME] | BILLER | PMT. SOURCE | EOB CHECK TOTAL | EOB AMT. | [NAME]. | CHECK TOTAL | PMT. AMT. | DIFF. | ADJ. DISC. | TRANSF. | Beacon AMT. | THREE WAY MATCH | NOTES
Fresno | FRE-001 | 621146851 | Duplicate | Fresno |  | HASC | 470.02 | 407.77 | 0 | 470.02 | 407.77 | 62.25 |  | 0 | Ext. Src. Pmt.
Fresno | FRE-001 | 621146851 | Duplicate | Fresno |  | HASC | 470.02 | 68.86 | 0 | 470.02 | 0 | 62.25 |  | 0 | Ext. Src. Pmt.
Fresno | FRE-001 | 621146851 | Duplicate | Fresno |  | HASC | 470.02 | -6.61 | 0 | 470.02 | 0 | 62.25 |  | 0 | Ext. Src. Pmt.
Fresno | FRE-002 | 2022080000000000 | Duplicate | Fresno |  | Beacon | 2195.45 | 2108.37 | 0 | 2195.45 | 2108.37 | 87.08 |  | 0 | 2195.45
Fresno | FRE-002 | 2022080000000000 | Duplicate | Fresno |  | Beacon | 2195.45 | 87.08 | 0 | 2195.45 | 0 | 87.08 |  | 0 | 2195.45
Fresno | FRE-003 | 1400490493 | Duplicate | Fresno |  | HASC | 257.05 | 235.88 | 0 | 257.05 | 235.88 | 0 |  | 0 | Ext. Src. Pmt.
Fresno | FRE-003 | 1400490493 | Duplicate | Fresno |  | HASC | 257.05 | 21.17 | 0 | 257.05 | 21.17 | 0 |  | 0 | Ext. Src. Pmt.
Fresno | FRE-004 | 27768 | Duplicate | Fresno |  | Check | 9387.82 | 5089.08 | 0 | 9387.82 | 5089.08 | 0 |  | 0 | Ext. Src. Pmt.
Fresno | FRE-004 | 27768 | Duplicate | Fresno |  | Check | 9387.82 | 4298.74 | 0 | 9387.82 | 4298.74 | 0 |  | 0 | Ext. Src. Pmt.
Fresno | FRE-005 | 4871446 | Duplicate | Fresno |  | HASC | 68.96 | 81 | 0 | 68.96 | 81 | -12.04 |  | 0 | Ext. Src. Pmt.
Fresno | FRE-005 | 4871446 | Duplicate | Fresno |  | HASC | 68.96 | -12.04 | 0 | 68.96 | 0 | -12.04 |  | 0 | Ext. Src. Pmt.
Fresno | FRE-006 | 2022080000000000 | Duplicate | Fresno |  | Beacon | 718.07 | 805.15 | 0 | 718.07 | 805.15 | -87.08 |  | 0 | 718.07
Fresno | FRE-006 | 2022080000000000 | Duplicate | Fresno |  | Beacon | 718.07 | -87.08 | 0 | 718.07 | 0 | -87.08 |  | 0 | 718.07
Fresno | FRE-007 | 621138669 | Unique | Fresno |  | HASC | 306.99 | 306.99 | 0 | 306.99 | 306.99 | 0 |  | 0 | Ext. Src. Pmt.
Spreadsheet: 763730d1642352849-data-validation-custom-formula-restricting-entry-fuel-consumption-v1
Sheet: Sheet1

BOB TRANSPORT
FUEL FILLING RECORD
SELLING SECTION |  |  |  |  |  |  |  |  |  |  | BUYING SECTION
DATE | VEHICLE NO | LAST READING | START ODO MTR | END ODO MTR | MILAGE KM | TANKER NO | FILLED QTY GALLON | BUYING PRICE | SELLING PRICE | PROFIT | TANKER NO | [NAME] | PRICE | BALANCE | TANKER NUMBER | USED GALLON | VEHICLE NO
2021-12-01 00:00:00 | 85744 |  | 500 | 650 |  | 1 | 850 |  | 1.5 |  | 1 | 1000 | 1.2 |  | 1
2021-12-02 00:00:00 | 25255 |  | 600 | 750 |  | 1 | 150 |  | 1.4 |  | 2 | 1200 | 1.3 |  | 2
2021-12-03 00:00:00 | 57584 |  | 850 | 950 |  | 1 | 500 |  | 1.3 |  | 3 | 1000 | 1.2 |  | 3
 |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  | 11 |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  | 12 |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  | 13 |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  | 14 |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  | 15 |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  | 16 |  |  |  | 16
Spreadsheet: 72484d1273166335-excel-2007-extracting-data-updated-dummy-sheet
Sheet: Summary

Data series 1 | Data series 2 | Data series 3 | Data series 4 | Data series 5 | Data series 6 | Data series 7 | Data series 8 | Data series 9 | Data series 10 | Data series 11
Sheet1, B9 | Sheet1, C10 | Sheet1, A17 | Sheet1, C17 | Sheet1, D17 | Sheet1, F17 | Sheet1, G17 | Sheet1, H17 | Sheet1, [NAME] | Sheet1, K17 | Sheet1, L17
Sheet1, B9 | Sheet1, C10 | Sheet1, A18 | Sheet1, C18 | Sheet1, D18 | Sheet1, F18 | Sheet1, G18 | Sheet1, H18 | Sheet1, J18 | Sheet1, K18 | Sheet1, L18
Sheet1, B9 | Sheet1, C10 | Sheet1, A19 | Sheet1, C19 | Sheet1, [NAME] | Sheet1, F19 | Sheet1, G19 | Sheet1, H19 | Sheet1, J19 | Sheet1, K19 | Sheet1, L19
Sheet1, B9 | Sheet1, C10 | Sheet1, A20 | Sheet1, C20 | Sheet1, D20 | Sheet1, F20 | Sheet1, G20 | Sheet1, H20 | Sheet1, J20 | Sheet1, K20 | Sheet1, L20
Sheet1, B9 | Sheet1, C10 | Sheet1, A21 | Sheet1, C21 | Sheet1, D21 | Sheet1, F21 | Sheet1, G21 | Sheet1, H21 | Sheet1, J21 | Sheet1, K21 | Sheet1, [NAME]
Sheet2, B9 | Sheet2, C10 | Sheet2, A17 | Sheet2, C17 | Sheet2, D17 | Sheet2, F17 | Sheet2, G17 | Sheet2, H17 | Sheet2, [NAME] | Sheet2, K17 | Sheet2, L17
Sheet3, B9 | Sheet3, C10 | Sheet3, A17 | Sheet3, C17 | Sheet3, D17 | Sheet3, F17 | Sheet3, G17 | Sheet3, H17 | Sheet3, [NAME] | Sheet3, K17 | Sheet3, L17
Sheet3, B9 | Sheet3, C10 | Sheet3, A18 | Sheet3, C18 | Sheet3, [NAME] | Sheet3, F18 | Sheet3, G18 | Sheet3, H18 | Sheet3, J18 | Sheet3, K18 | Sheet3, L18
Sheet3, B9 | Sheet3, C10 | Sheet3, A19 | Sheet3, C19 | Sheet3, [NAME] | Sheet3, F19 | Sheet3, G19 | Sheet3, H19 | Sheet3, J19 | Sheet3, K19 | Sheet3, L19
Sheet3, B9 | Sheet3, C10 | Sheet3, A20 | Sheet3, C20 | Sheet3, D20 | Sheet3, F20 | Sheet3, G20 | Sheet3, H20 | Sheet3, J20 | Sheet3, K20 | Sheet3, L20
etc… | etc… | etc… | etc… | etc… | etc… | etc… | etc… | etc… | etc… | etc…
Spreadsheet: 628268d1560473792-help-calendar-correction-employee-absence-schedule-current-6-13-19
Sheet: April

 | Employee Absence Schedule
 | Absence Type Key | V | Vacation |  |  | P | Pick Up Shift |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
 | April | Dates of Absence/Pick up |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019
 | Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 |  |  |  | Vacation Days Available | Total Vacation  Days Taken | Total Days Picked up | Total Sick Days
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | v |  |  |  |  | s |  |  |  |  |  |  | v
 | Lynda |  |  |  |  |  |  |  |  | v | v
 | [NAME]
 | Heather |  |  |  |  |  |  |  |  |  | p |  |  |  |  |  |  |  |  |  |  |  |  | p |  | p
 | [NAME] |  |  | s |  |  |  |  |  | p
 | Emili |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | p |  | p | p
 | Amber |  |  |  | s | s |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | p |  | v | v
 | Meredith |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | v | v | v | v
 | Julie
Spreadsheet: 1f6a368e-2649-47b1-b809-e60d507013cf
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5368.0 International Trade in Goods and Services, Australia
 | TABLE 16. PERIOD AVERAGE EXCHANGE RATES, Units of Foreign Currency per Australian Dollar
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Euro ; |  |  | Original | A2716728L | 1978-07-01 00:00:00 | 2012-07-01 00:00:00 | 409 | $ | INDEX | Month | 1
[NAME] ; |  |  | Original | A2716729R | 1978-07-01 00:00:00 | 2012-07-01 00:00:00 | 409 | $ | INDEX | Month | 1
United States Dollar ; |  |  | Original | A2716726J | 1978-07-01 00:00:00 | 2012-07-01 00:00:00 | 409 | $ | INDEX | Month | 1
United Kingdom Pound ; |  |  | Original | A2716727K | 1978-07-01 00:00:00 | 2012-07-01 00:00:00 | 409 | $ | INDEX | Month | 1
Special Drawing Right ; |  |  | Original | A2716730X | 1978-07-01 00:00:00 | 2012-07-01 00:00:00 | 409 | $ | INDEX | Month | 1
Trade Weighted Index ; |  |  | Original | A2716731A | 1978-07-01 00:00:00 | 2012-07-01 00:00:00 | 409 | Index Numbers | INDEX | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 546692d1510159324-how-do-i-make-excel-not-count-squared-or-superscripted-numbers-excel-sample2
Sheet: Group Sampras

 |  |  |  | W | L | SF | SA | GF | GA | Pts |  |  | 1 | [NAME] | 6 | 4 | 7 7
 |  | 1 | [NAME] |  |  |  |  |  |  |  |  |  | 7 | [NAME] | 3 | 6 | 6 5
 |  | 2 | Dominic Thiem
 |  | 3 | [NAME] |  |  |  |  |  |  |  |  |  | 4 | Dominic Thiem
 |  | 4 | [NAME] |  |  |  |  |  |  |  |  |  | 6 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 6 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Dominic Thiem
 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 6 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Dominic Thiem
Spreadsheet: 604017d1546258703-need-help-with-separating-data-on-a-pivot-report-book1
Sheet: Assumptions

 | ID | Assumption 1 | Cost per unit
 | 1 | Unable to sell stock | 75
 | 2 | Unable to transport stock | 50
 | 3 | New buyer for stock | 25
 | 4 | Compensation Scheme | 25
 | 5 | Assumption 5 | 75
 | 6 | Assumption 6 | 75
 | 7 | Assumption 7 | 30
 | 8 | Assumption 8 | 0.2
 | 9 | Assumption 9 | 80
 | 10 | Assumption 10 | 80
 | 11 | Assumption 11 | 85
 | 12 | Assumption 12 | 90
 | 13 | Assumption 13 | 90
 | 14 | Assumption 14 | 90
 | 15 | Assumption 15 | 95
 | 16 | Assumption 16 | 100
 | 17 | Assumption 17 | 100
 | 18 | Assumption 18 | 90
Spreadsheet: 858228d1706962142-looking-up-most-recent-values-from-two-columns-book1
Sheet: Sheet1

Orange | 5 | Peas | 6
Apple | 3 | Cabbage | 13 |  |  |  |  | Input | Result
Lettuce | 2 | Pear | 10 |  |  |  |  | lettuce | 1
Pear | 7 | Lettuce | 1 |  |  |  |  | cherry | 11
[NAME] | 11 | Lime | 4 |  |  |  |  | pear | 7
Spreadsheet: 019680fd-ac82-413c-b4fd-5d184bcc4b88
Sheet: Sheet1

Unnamed: 0 | IMPERIAL VALLEY COLLEGE | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | WOMEN'S SOCCER SCHEDULE
 | FALL 2012
DATE | DAY | OPPONENT | PLACE | TIME
SEPT 11 | TUESDAY | *MIRA COSTA COLLEGE | IVC | 15:15:00
SETP 14 | FRIDAY | *SAN DIEGO MESA COLLEGE | SDMC | 18:00:00
SEPT 18 | TUESDAY | *PALOMAR COLLEGE | IVC | 15:15:00
SEPT 19 | WEDNESDAY | COLLEGE OF THE DESERT | COD | 14:00:00
SEPT 21 | FRIDAY | BYE
SEPT 25 | TUESDAY | *GROSSMONT COLLEGE | GC | 13:00:00
SEPT 28 | FRIDAY | *MIRAMAR COLLEGE | MMC | 13:00:00
OCT 2 | TUESDAY | *SOUTHWESTERN COLLEGE | IVC | 15:15:00
OCT 5 | FRIDAY | *CUYAMACA COLLEGE | CC | 15:15:00
OCT 9 | TUESDAY | *SAN DIEGO CITY COLLEGE | SDCC | 15:15:00
OCT 12 | FRIDAY | *MIRA COSTA COLLEGE | MCC | 15:00:00
OCT 16 | TUESDAY | *SAN DIEGO MESA COLLEGE | IVC | 3:00PM
OCT 19 | FRIDAY | *PALOMAR COLLEGE -DH | PC | 15:00:00
OCT 23 | TUESDAY | BYE
OCT 26 | FRIDAY | *GROSSMONT COLLEGE | IVC | 15:00:00
OCT 30 | TUESDAY | *MIRAMAR COLLEGE | IVC | 15:00:00
NOV 2 | FRIDAY | *SOUTHWESTERN COLLEGE | SWC | 15:00:00
NOV 6 | TUESDAY | *CUYAMACA COLLEGE | IVC | 15:00:00
NOV 8 | THURSDAY | CHAFFEY COLLEGE | CHAFFEY | 13:00:00
NOV 9 | FRIDAY | *SAN DIEGO CITY COLLEGE | IVC | 14:30:00
* Denotes Conference Games |  | DH Denotes Double Headers
[NAME], Head Coach |  | (760) 355 - 6325
[NAME], Asst. Coach |  | (760) 355 - 6325
[NAME], Athletic Director |  | (760) 355 - 6341
[NAME], Secretary |  | (760) 355 - 6325
[NAME], [NAME] |  | (760) 355 - 6329
Athletic Fax |  | (760) 355 - 6514 |  | 2012-09-10 00:00:00
ATHLETICS DEPARTMENT 380 E. ATEN ROAD, IMPRIAL, CA 92251
Spreadsheet: 238266d1369437207-change-only-select-refs-in-pasted-formula-formula-test
Sheet: Sheet1

Name | Type A | Type B | Summary
Adam |  |  | xx
[NAME] |  |  | xy
[NAME] |  |  | xz
[NAME] |  |  | yy
[NAME] |  |  | yz
Fred |  |  | a
George |  |  | b
 | Key
 | x | x | xx
 | x | y | xy
 | x | z | xz
 | y | y | yy
 | y | z | yz
 | a | a | a
 | b | b | b
Spreadsheet: 677025d1589153652-simple-formula-part-deaux-book3
Sheet: Sheet1

 | 2020 | 2019 | [NAME] | Results
 | 75 |  |  | <-- Correct
 |  | 83 |  | <-- Correct
 | 83 | 75 |  | <-- Correct
 | 75 | 83 |  | <-- Correct
 |  |  |  | <-- This should be zero
Spreadsheet: fb2be2ec-f92c-41d2-bec7-8fb653037bec
Sheet: Segments

Johnson & Johnson and Subsidiaries
Supplementary Sales Data
([NAME]; Dollars in Millions) |  |  |  |  | FOURTH QUARTER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TWELVE MONTHS
 |  |  |  |  |  |  |  |  |  |  | Percent Change |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Percent Change
 |  |  | Pulls fm Rpt | Adj | 2011 |  | 2010 |  | Change $ |  | Total |  | Operations $ |  | Operations |  | Currency $ |  | Currency |  | Prior Q YTD | Pulls fm Rpt | Adj | 2011 |  | 2010 |  | Change $ |  | Total |  | Operations $ |  | Operations |  | Currency $ |  | Currency
Sales to customers by
segment of business
Consumer
U.S. |  | Great | 1248 |  | 1248 |  | 1219 |  | 29 |  | 2.4 | % | 29 |  | 2.4 |  | 0 |  | 0 |  | 3903 | 5151 |  | 5151 |  | 5519 |  | -368 |  | -6.7 | % | -368 |  | -6.7 |  | 0 |  | 0
International |  | Great | 2420 |  | 2420 |  | 2391 |  | 29 |  | 1.2 |  | 68 |  | 2.8 |  | -39 |  | -1.6 |  | 7312 | 9732 |  | 9732 |  | 9071 |  | 661 |  | 7.3 |  | 261 |  | 2.899999999999999 |  | 400 |  | 4.4
 |  | Great |  |  | 3668 |  | 3610 |  | 58 |  | 1.6 |  | 97 |  | 2.7 |  | -39 |  | -1.1 |  | 11215 |  |  | 14883 |  | 14590 |  | 293 |  | 2 |  | -107 |  | -0.7000000000000002 |  | 400 |  | 2.7
Pharmaceutical
U.S. |  | Great | 2887 |  | 2887 |  | 3149 |  | -262 |  | -8.3 |  | -262 |  | -8.3 |  | 0 |  | 0 |  | 9499 | 12352 | 34 | 12386 |  | 12519 |  | -133 |  | -1.1 |  | -133 |  | -1.1 |  | 0 |  | 0
International |  | Great | 3207 |  | 3207 |  | 2561 |  | 646 |  | 25.2 |  | 640 |  | 25 |  | 6 |  | 0.2 |  | 8775 | 12016 | -34 | 11982 |  | 9877 |  | 2105 |  | 21.3 |  | 1528 |  | 15.5 |  | 577 |  | 5.8
 |  | Great |  |  | 6094 |  | 5710 |  | 384 |  | 6.7 |  | 378 |  | 6.600000000000001 |  | 6 |  | 0.1 |  | 18274 |  |  | 24368 |  | 22396 |  | 1972 |  | 8.8 |  | 1395 |  | 6.200000000000001 |  | 577 |  | 2.6
Med Devices & Diagnostics
U.S. |  | -1 | 2851 |  | 2850 |  | 2861 |  | -11 |  | -0.4 |  | -11 |  | -0.4 |  | 0 |  | 0 |  | 8521 | 11372 | -1 | 11371 |  | 11412 |  | -41 |  | -0.4 |  | -41 |  | -0.4 |  | 0 |  | 0
International |  | 1 | 3642 |  | 3643 |  | 3463 |  | 180 |  | 5.2 |  | 160 |  | 4.600000000000001 |  | 20 |  | 0.6 |  | 10765 | 14408 |  | 14408 |  | 13189 |  | 1219 |  | 9.2 |  | 451 |  | 3.399999999999999 |  | 768 |  | 5.8
 |  | Great |  |  | 6493 |  | 6324 |  | 169 |  | 2.7 |  | 149 |  | 2.4 |  | 20 |  | 0.3 |  | 19286 |  |  | 25779 |  | 24601 |  | 1178 |  | 4.8 |  | 410 |  | 1.7 |  | 768 |  | 3.1
U.S. |  | Great | 6986 |  | 6985 |  | 7229 |  | -244 |  | -3.4 |  | -244 |  | -3.4 |  | 0 |  | 0 |  | 21923 | 28874 |  | 28908 |  | 29450 |  | -542 |  | -1.8 |  | -542 |  | -1.8 |  | 0 |  | 0
International |  | Great | 9270 |  | 9270 |  | 8415 |  | 855 |  | 10.2 |  | 868 |  | 10.4 |  | -13 |  | -0.2 |  | 26852 | 36156 |  | 36122 |  | 32137 |  | 3985 |  | 12.4 |  | 2240 |  | 7 |  | 1745 |  | 5.4
Worldwide |  | Great |  |  | 16255 |  | 15644 |  | 611 |  | 3.9 | % | 624 |  | 4 |  | -13 |  | -0.1 |  | 48775 | 65030 |  | 65030 |  | 61587 |  | 3443 |  | 5.6 | % | 1698 |  | 2.767068708948859 |  | 1745 |  | 2.83293129105114
Spreadsheet: 737717d1624551958-top-10-values-including-all-duplicates-book4
Sheet: Sheet1

MRA | 26
MRB | 8 |  |  | 1
MRC | 27 |  |  | 2
MRD | 18 |  |  | 3
MRE | 15 |  |  | 4
MRF | 16 |  |  | 5
MRG | 17 |  |  | 6
MRH | 29 |  |  | 7
MRI | 5 |  |  | 8
MRJ | 5 |  |  | 9
MRK | 28 |  |  | 10
MRL | 9
MRM | 27
MRN | 21
MRO | 22
MRP | 6
MRQ | 20
MRR | 20
MRS | 28
MRT | 1
MRU | 9
MRV | 7
MRW | 22
MRX | 28
MRY | 24
MRZ | 24