tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 56772d1256861940-linking-worksheets-template
Sheet: Ranges

Status | L&G | MC | BHI | Month
Active | 0 | 0 | 0 | Jan
Complete | 1 | One | BC | Feb
Decline | 2 | Two | B | Mar
Gone Off | 3 | Three | C | Apr
 | 4 | Four |  | May
 | 5 |  |  | Jun
 | 6 |  |  | Jul
 | 7 |  |  | Aug
 | 8 |  |  | Sep
 | 9 |  |  | Oct
 |  |  |  | Nov
 |  |  |  | Dec
Spreadsheet: 0583fdbb-7309-41eb-b242-2dcfeb8b99c4
Sheet: Online Special Questions

Survey of all Currently enrolled students Fall 2012 -- Online Questions
 | [NAME] |  | Brighton |  | CCCS Online |  | Larimer |  | FRCC Online |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Online |  | Larimer |  | FRCC Online |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Online |  | Larimer |  | FRCC Online |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Online |  | Larimer |  | FRCC Online |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Online |  | Larimer |  | FRCC Online |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Online |  | Larimer |  | FRCC Online |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Online |  | Larimer |  | FRCC Online |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Online |  | Larimer |  | FRCC Online |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Online |  | Larimer |  | FRCC Online |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Online |  | Larimer |  | FRCC Online |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Online |  | Larimer |  | FRCC Online |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Online |  | Larimer |  | FRCC Online |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Online |  | Larimer |  | FRCC Online |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Online |  | Larimer |  | FRCC Online |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Online |  | Larimer |  | FRCC Online |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Online |  | Larimer |  | FRCC Online |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Online |  | Larimer |  | FRCC Online |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Online |  | Larimer |  | FRCC Online |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Online |  | Larimer |  | FRCC Online |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Online |  | Larimer |  | FRCC Online |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Online |  | Larimer |  | FRCC Online |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Online |  | Larimer |  | FRCC Online |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Online |  | Larimer |  | FRCC Online |  | Westminster |  | Total
 | [NAME] |  | Brighton |  | CCCS Online |  | Larimer |  | FRCC Online |  | Westminster |  | Total
Spreadsheet: ffa5631e-8c71-4db2-a2db-95ccc192ae97
Sheet: Sheet2

 | Aerobic Exercising | 24.119
 | Backpack/Wilderness Camp | 11.469
 | Baseball | 14.823
 | Basketball | 31.8
 | Bicycle Riding | 53.342
 | Billiards/Pool | 34.477
 | Boating, Motor/Power | 28.835
 | Bowling | 42.895
 | Camping (Vacation/Overnite) | 44.695
 | Canoeing | 8.4
 | Exercise Walking | 73.307
 | Exercising with Equipment | 47.823
 | Fishing | 45.636
 | Football (Tackle) | 8.953
 | Golf | 23.082
 | Hiking | 26.457
 | Hockey (Ice) | 2.064
 | Hunting w/Bow & Arrow | 5.495
 | Hunting with Firearms | 18.3
 | Roller Skating (In-line) | 25.505
 | Mountain Biking (off road) | 7.276
 | Muzzleloading | 3.152
 | Running/Jogging | 22.239
 | Skateboarding | 4.664
 | Skiing (Alpine) | 10.466
 | Skiing (Cross Country) | 3.385
 | Snowboarding | 3.1
 | Soccer | 13.876
 | Softball | 19.873
 | Swimming | 60.223
 | Target Shooting | 14.7
 | Tennis | 11.485
 | Volleyball | 18.535
 | Water Skiing | 7.37
 |  | 22.5
Spreadsheet: john_griffith__15677__05_14_01ON
Sheet: Sheet1

N
Commodity: | ON - NAT. GAS OPTS.
Month | STRIKE | BID | OFFER | Volatility | Future
M01-P/C | 435 | 32 | 35
N01-P/C | 440 | 63 | 65
Q01-P/C | 445 | 83 | 85
U01-P/C | 450 | 101 | 104
V01-P/C | 450 | 116 | 118
X01-P/C | 470 | 134 | 139
[NAME]-P/C | 485 | 154 | 157
F02-P/C | 490 | 169 | 174
G02-P/C | 480 | 173 | 178
H02-P/C | 460 | 160 | 167
J02-P/C | 425 | 120 | 125
K02-P/C | 420 | 113 | 120
M02-P/C | 420 | 115 | 119
U02-P/C | 430
Spreadsheet: kim_ward__20819__citizens
Sheet: Sheet1

 | Buyer: | Citizens
 | [NAME]: | ENA
 | Delivery Point: | San Juan
 |  |  |  |  |  | San Juan
 |  |  |  | Volume MMbtu/day | Nymex | Basis | Total Fixed Price
 |  |  | 2001-04-01 00:00:00 | 700 | 5.266 | -0.25
 |  |  | 2001-05-01 00:00:00 |  | 5.314 | -0.32
 |  |  | 2001-06-01 00:00:00 |  | 5.352 | -0.33
 |  |  | 2001-07-01 00:00:00 |  | 5.392 | -0.33
 |  |  | 2001-08-01 00:00:00 |  | 5.422000000000001 | -0.33
 |  |  | 2001-09-01 00:00:00 |  | 5.39 | -0.33
 |  |  | 2001-10-01 00:00:00 |  | 5.394 | -0.34
 |  |  | 2001-11-01 00:00:00 |  | 5.484 | -0.14
 |  |  | 2001-12-01 00:00:00 |  | 5.589 | -0.14
 |  |  | 2002-01-01 00:00:00 |  | 5.614 | -0.14
 |  |  | 2002-02-01 00:00:00 |  | 5.391 | -0.14
 |  |  | 2002-03-01 00:00:00 |  | 5.034 | -0.14
 |  |  | 2002-04-01 00:00:00 |  | 4.644 | -0.135
 |  |  | 2002-05-01 00:00:00 |  | 4.533 | -0.135
 |  |  | 2002-06-01 00:00:00 |  | 4.548 | -0.135
 |  |  | 2002-07-01 00:00:00 |  | 4.588 | -0.135
 |  |  | 2002-08-01 00:00:00 |  | 4.595 | -0.135
 |  |  | 2002-09-01 00:00:00 |  | 4.569 | -0.135
 |  |  | 2002-10-01 00:00:00 |  | 4.564 | -0.135
 |  |  | 2002-11-01 00:00:00 |  | 4.681 | -0.115
 |  |  | 2002-12-01 00:00:00 |  | 4.791 | -0.115
 |  |  | 2003-01-01 00:00:00 |  | 4.834000000000001 | -0.115
 |  |  | 2003-02-01 00:00:00 |  | 4.714 | -0.115
 |  |  | 2003-03-01 00:00:00 |  | 4.554 | -0.115
 |  |  | 2003-04-01 00:00:00 |  | 4.364 | -0.105
Spreadsheet: 745203d1629804377-vlookup-to-identify-if-a-coutnry-is-in-the-eu-or-not-book1
Sheet: Sheet1

United Kingdom
Germany
United Arab Emirates
France | EU |  | Finland
Finland | EU
Italy | EU
Russia | NONE-EU
Belgium
Ireland
Spain
USA
Norway
Sweden
Mexico
Singapore
Australia
Turkey
Lithuania
Greece
Netherlands
Northern Ireland
Spreadsheet: 66367d1267029861-graph-719403b
Sheet: Sheet1

ADC | Temp | New ADC | New Temp |  | ADC's
339 | 0 | 521 | 111.6090357092069 | 12 | 511 | 100 |  |  |  |  |  |  |  |  |  |  |  | 10 | 0.6666666666666666
357 | 10 |  |  | 13 | 526 | 110 |  |  |  |  |  |  |  |  |  |  | 511 | 100
375 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 512 | 100.6666666666667
384 | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 513 | 101.3333333333333
393 | 30 |  |  | Step | 0.6666666666666666 |  |  |  |  |  |  |  |  |  |  |  | 514 | 102
411 | 40 |  |  | Amount | 6.666666666666666 |  |  |  |  |  |  |  |  |  |  |  | 515 | 102.6666666666667
429 | 50 |  | New Values | 521 | 106.6666666666667 |  |  |  |  |  |  |  |  |  |  |  | 516 | 103.3333333333334
445 | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 517 | 104
462 | 70 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 518 | 104.6666666666667
478 | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 519 | 105.3333333333334
495 | 90 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 520 | 106
511 | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 521 | 106.6666666666667
526 | 110 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 522 | 107.3333333333334
540 | 120 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 523 | 108.0000000000001
556 | 130 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 524 | 108.6666666666667
571 | 140 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 525 | 109.3333333333334
584 | 150 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 526 | 110.0000000000001
598 | 160
609 | 170
623 | 180
635 | 190
647 | 200
658 | 210
658 | 210
Spreadsheet: 99576d1298194556-graph-axis-problem-homework2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Psid
 | Distance | Psi | VR | VA | VT |  |  | kappa 1 |  | radius
 |  |  |  |  |  |  |  |  |  | conc
 |  | 25.7 |  |  |  |  |  |  |  | temp | 298
 |  | 25.7 |  |  |  |  |  |  |  | A
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
 |  | 25.7
Spreadsheet: 702452d1604354184-lookup-if-time-between-lookup-shift2
Sheet: find shift

lookup table |  |  |  |  | data entry | data entry | calc |  | expected result
area | min | [NAME] | shift |  | area | time | shift
a | 600 | 1800 | 1 |  | b | 0615
b | 620 | 1820 | 1 |  | c | 0630 |  |  | 1
c | 630 |  | 1 |  | a | 1830 |  |  | 3
d | 530 |  | 1 |  | d | 1731 |  |  | 3
e | 550 |  | 1 |  | d | 1200 |  |  | 1
 |  |  |  |  | e | 1830 |  |  | 3
if shift (D) not =1, return 3 |  |  |  |  | a | 2200 |  |  | 3
 |  |  |  |  | c | 0625 |  |  | 3
 |  |  |  |  | b | 1020 |  |  | 1
 |  |  |  |  | c | 0815 |  |  | 1
 |  |  |  |  | e | 1430 |  |  | 1
 |  |  |  |  |  | if time (G) between min (B) & max ( C)
 |  |  |  |  |  | lookup area (F) from (A)
 |  |  |  |  |  | result (D) in (H)
Spreadsheet: 872654d1719007855-getting-data-from-one-workbook-to-another-ghm-team
Sheet: Girls

 | Name | 100 | 200 | 800 | 1500 | Shot | Discus | Long | High
2012
12 Years
 |  | 100 | 200 | 800 | 1500 | Shot | Discus | Long | High
2013
11 Years
 |  | 100 | 200 | 800 | 1500 | Shot | Discus | Long | High
2014
10 Years
2015 |  | 100 | 200 | Long
9 Years
Spreadsheet: 50959d1250549389-vlookup-putting-all-names-in-order-slashsummerseries
Sheet: Standings

Expert Standings | Points | Name
1 | 217.000079 | [NAME]
2 | 212.00008 | [NAME]
3 | 208.000081 | [NAME]
4 | 202.000084 | [NAME]
5 | 201.000082 | [NAME]
6 | 200.000085 | [NAME]
7 | 118.000086 | [NAME]
8 | 114.000089 | [NAME]
9 | 112.000087 | [NAME]
10 | 111.000088 | [NAME]
11 | 109.000092 | [NAME]
12 | 107.00009 | Sawyer
13 | 106.000091 | leonard Vergara
14 | 104.000095 | [NAME]
15 | 101.000094 | [NAME]
16 | 100.000083 | [NAME]
17 | 99.000093 | [NAME]
18 | 98.000096 | Brando
19 | 0.000115 | 0
20 | 0.000114 | 0
21 | 0.000113 | 0
22 | 0.000112 | 0
23 | 0.000111 | 0
24 | 0.00011 | 0
25 | 0.000109 | 0
26 | 0.000108 | 0
27 | 0.000107 | 0
Novice Standings | Points | Name
1 | 244.000023 | [NAME]
2 | 239.000022 | [NAME]
3 | 236.000024 | [NAME]
4 | 231.000028 | [NAME]
5 | 230.000025 | [NAME]
6 | 227.000029 | [NAME]
7 | 222.000027 | [NAME]
8 | 215.00003 | [NAME]
9 | 207.000036 | [NAME]
10 | 206.000031 | [NAME]
11 | 203.000035 | [NAME]
12 | 125.000041 | [NAME]
13 | 120.000043 | [NAME]
14 | 117.000042 | [NAME]
15 | 117.00004 | [NAME]
16 | 115.000044 | [NAME]
17 | 114.000046 | [NAME]
18 | 113.000047 | [NAME]
19 | 111.00005 | [NAME]
20 | 111.000026 | [NAME]
21 | 110.000048 | Percival Delumen
22 | 109.000045 | [NAME]
23 | 107.000049 | [NAME]
24 | 105.000055 | Grimmis
25 | 105.000032 | [NAME]
26 | 104.000052 | [NAME]
27 | 104.000033 | [NAME]
28 | 103.000051 | [NAME]
29 | 103.000034 | [NAME]
30 | 102.000054 | [NAME]
31 | 100.000037 | [NAME]
32 | 99.000053 | [NAME]
33 | 99.000038 | [NAME]
34 | 98.000056 | [NAME]
35 | 98.000039 | [NAME]
36 | 7.7e-05 | 0
37 | 7.6e-05 | 0
38 | 7.5e-05 | 0
39 | 7.4e-05 | 0
40 | 7.3e-05 | 0
41 | 7.2e-05 | 0
42 | 7.1e-05 | 0
43 | 7e-05 | 0
44 | 6.9e-05 | 0
45 | 6.8e-05 | 0
46 | 6.7e-05 | 0
47 | 6.6e-05 | 0
48 | 6.5e-05 | 0
49 | 6.4e-05 | 0
50 | 6.3e-05 | 0
Junior Standings | Points | Name
1 | 201.000005 | Kitty
2 | 200.000007 | [NAME]
3 | 109.000009 | Amanda Panda
4 | 107.000008 | Collin andrews
5 | 104.000011 | [NAME]
6 | 103.000012 | [NAME]
7 | 102.000014 | [NAME]
8 | 100.000013 | Helen Brand
9 | 100.000006 | Kelly J
10 | 99.00001 | Leah Craft
11 | 2e-05 | 0
12 | 1.9e-05 | 0
13 | 1.8e-05 | 0
14 | 1.7e-05 | 0
15 | 1.6e-05 | 0
16 | 1.5e-05 | 0
Spreadsheet: 202904d1356798138-drop-down-list-to-automatically-fill-cells-to-right-copy-of-book1
Sheet: Data

 | STAFF | skill 1 | skill 2 | skill3 | skill 4 | skill 5 | skill 6 | skill 7 | skill 8
 | [NAME] | YES | 1 |  | yes | yes | yes | yes | yes
 | Damon | YES | 2 |  | yes | yes | yes | yes | yes
 | [NAME] | NO | 3 |  | no | no | no | no | no
 | [NAME] | NO | 4 |  | no | no | no | no | no
Spreadsheet: 708483d1607867648-vlookup-multiple-answer-bok1
Sheet: Blad1

Enhet | Datum | Ordernr | Kundnamn | Angöring namn - sista | Angöring adress - sista | Angöring postort - sista | Chaufförsinstruktion | [NAME] | Godstyp | Vikt | [NAME] | Pallplats
3010 | 2020-12-08 00:00:00 | 123456 | WIDÉNS ÅKERI I KALMAR AB | CITY GROSS UDDEVALLA | Östra torpvägen 2 | UDDEVALLA |  | Kylt | SJÖPALL | 880 | 3 | 3
3020 | 2020-12-08 00:00:00 | 123457 | [NAME] ALLT I FISK AB | CITY GROSS YTTERBY | Ytterbyvägen 2 | UDDEVALLA |  | Kylt | PALL | 150 | 1 | 1
3010 | 2020-12-08 00:00:00 | 1 | aaa | CITY GROSS UDDEVALLA | Östra torpvägen 2 | UDDEVALLA |  | Kylt | PALL | 150 | 1 | 1
3010 | 2020-12-08 00:00:00 | 2 | sss | CITY GROSS UDDEVALLA | Östra torpvägen 2 | UDDEVALLA |  | Kylt | PALL | 150 | 1 | 1
3010 | 2020-12-08 00:00:00 | 3 | ddd | CITY GROSS UDDEVALLA | Östra torpvägen 2 | UDDEVALLA |  | Kylt | PALL | 150 | 1 | 1
3010 | 2020-12-08 00:00:00 | 4 | [NAME] | CITY GROSS UDDEVALLA | Östra torpvägen 2 | UDDEVALLA |  | Kylt | PALL | 150 | 1 | 1
3010 | 2020-12-08 00:00:00 | 5 | ggg | CITY GROSS UDDEVALLA | Östra torpvägen 2 | UDDEVALLA |  | Kylt | PALL | 150 | 1 | 1
3010 | 2020-12-08 00:00:00 | 6 | hhh | CITY GROSS UDDEVALLA | Östra torpvägen 2 | UDDEVALLA |  | Kylt | PALL | 150 | 1 | 1
Spreadsheet: 703073d1604735171-inventory-tracking-formulas-and-formula-for-discounts-or-bulk-buying-example
Sheet: Sales

Date | Product | Units Sold | Price | Value
Spreadsheet: 61589d1262526555-two-y-axis-both-using-same-data-series-frost-20iwi-20graphsv1-1-
Sheet: sbm1%

 | WDR Zone 1 |  | WDR Zone 2 |  | WDR Zone 3 |  | WDR Zone 4
 | Cambridge | London | Grendon Underwood | Wallingford | [NAME] | [NAME] | [NAME] | Rawtenstall |  | gren 1% | gren 2% |  | gren 10%
None | 23.15 | 16.5 | 89.36 | 52.45 | 49.81 | 41.84 | 48.68 | 45.82 |  | 90.2 |  | 91.04
WF | 79.86 | 68.25 | 109.46 | 83.5 | 94.57 | 79.69 | 69.9 | 92.7 |  | 110.26 | 111.05 | 111.05 | 117.12
MW | 78.09 | 68.2 | 109.46 | 83.86 | 94.57 | 80.32 | 70.17 | 86.17 |  | 110.28 |  | 111.07
EPS | 80.5 | 68.59 | 109.76 | 84.44 | 95.75 | 81.21 | 70.67 | 93.87 |  | 110.58 |  | 111.38
PF | 79.73 | 68.97 | 109.82 | 84.22 | 96.56 | 81.48 | 71.73 | 87.33 |  | 110.66 |  | 111.46
SBM free water saturation (Wf) |  |  |  | 190 | kg/m3
75% of Wf Fmax |  |  |  | 142.5 | kg/m3
 |  |  |  |  |  |  |  | 57.61052631578947 | %Wf of Wf for Wood fibre [NAME] with no moisture sources
 |  |  |  |  |  |  |  | 58.03157894736842 | 0.01
 |  |  |  |  |  |  |  | 58.44736842105263 | 0.02
II |  |  |  |  |  |  |  | 61.6421052631579 | %Wf of Wf for Wood fibre Grendon with 10% WDR @5mm
Spreadsheet: 832725d1686566056-need-formula-to-individual-calculate-of-ratings-1-to-5-from-16-people-polls-ratings_skill
Sheet: Dashboard

Name | Ownership rating | [NAME] | [NAME] | Wick | Scott | [NAME] | Participant | % | Missing Participants
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Missing Partipant
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Rating first Person
Wick
Scott
 |  | expected result
Name | Ownership rating | [NAME] | [NAME] | Wick | Scott | [NAME] | Participant | % | Missing Participants
[NAME] | 5 |  | 3 | 4 | 1 |  |  |  | 0 |  |  |  | Missing Partipant
[NAME] | 5 | 5 |  | 3 | 4 |  |  |  | 0 |  |  |  | Rating first Person
Wick | 5 | 1 | 2 |  | 5 |  |  |  | 0
Scott | 5 | 5 | 2 |  |  |  |  |  | 1
Spreadsheet: 870136d1716687214-average-pass-rates-for-multiple-users-and-questions-example-1-tim2773-
Sheet: Output

Question number | (All) |  | ←Able to select any question number |  |  |  | Question Number | Q2
ID number | % pass rate |  |  |  |  |  | ID number | % Pass Rate
1 | 0.75 |  |  |  |  |  | 1 | 0.5
2 | 0.5 |  |  |  |  |  | 2 | 0.75
3 | 0.6666666666666666 |  |  |  |  |  | 3 | 0.3333333333333333
4 | 0.5 |  |  |  |  |  | 4 | 0.5
5 | 0 |  |  |  |  |  | 5
6 | 0 |  |  |  |  |  | 6 | 1
7 | 1 |  |  |  |  |  | 7
8 | 0 |  |  |  |  |  | 8 | 0.5
Grand Total | 0.4736842105263158 |  |  |  |  |  | Grand Total | 0.5263157894736842
Spreadsheet: kate_symes__18396__Notification 0101
Sheet: Jan 01

 | Highlighted names = new to list since last distribution |  |  | Changes for January 2001 |  |  |  | GCP  Name Changes, Mergers, [NAME], and Acquisitions |  |  | N/C = No Change
GCP DB |  | OLD RECORD INFORMATION |  |  |  |  |  |  | NEW RECORD INFORMATION
Update |  |  |  |  |  | Type of | [NAME] of |  |  |  |  |  | System Chg Updated
Complete | COUNTERPARTY NAME | BA # | CP # | SHORTNAME |  | CHANGE | Change | COUNTERPARTY NAME | BA # | CP# | SHORTNAME | COMMENTS | Name | ERMS SN
 | Name Overlay Only
 | Tempest Reinsurance Company Limited | 64833 | 64388 | TEMPESTREICOM |  | Name | 2000-09-07 00:00:00 | ACE Tempest Reinsurance Ltd. | N/C | N/C | ACETEMREICOM | Have Certificate of Incorporation on Change of Name | 2000-12-28 00:00:00
Spreadsheet: 45abb700-0a11-412d-a6cd-7cae1a3a4f40
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | APPROPRIATION TRANSACTION | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  | CITY  OF  KANSAS  CITY,  MISSOURI
 |  |  | DEPARTMENT: |  |  | Finance
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  | 2006-01-18 00:00:00 |  | JOURNAL ID:
LEDGER GROUP: |  |  |  |  | APPROP
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
AL |  | 3450 |  | 129620 |  | B |  |  |  | 179333 |  | I
AL |  | 3450 |  | 129631 |  | B |  |  |  | 36449 |  | I
AL |  | 3450 |  | 129632 |  | B |  |  |  | 57352 |  | I
AL |  | 3450 |  | 129998 |  | X |  |  |  | 1866 |  | I
AL |  | 3450 |  | 897600 |  | B |  |  |  | 7980000 |  | I
06 |  | 3090 |  | 897228 |  | B |  |  |  | 500000 |  | D
06 |  | 3090 |  | 129998 |  | X |  |  |  | 500000 |  | I
06 |  | 1000 |  | 129064 |  | B |  |  |  | 238000 |  | D
06 |  | 1000 |  | 129998 |  | X |  |  |  | 238000 |  | I
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 9731000
 | HOK-300 Wyandotte- Parking Garage
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  | 2006-01-18 00:00:00 |  | JOURNAL ID: |  | C
 |  |  |  |  |  |  |  |  |  |  |  | (same as above, except
LEDGER GROUP: |  |  |  |  | ADMIN |  |  | BUDGET PERIOD: |  |  |  | prefixed by a C)
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
AL |  | 3450 |  | 129620 |  | 743050 |  |  |  | 179333 |  | I
AL |  | 3450 |  | 129631 |  | 743050 |  |  |  | 36449 |  | I
AL |  | 3450 |  | 129632 |  | 743150 |  |  |  | 57352 |  | I
AL |  | 3450 |  | 129998 |  | 905330 |  |  |  | 1866 |  | I
AL |  | 3450 |  | 897600 |  | 611060 |  | 89000402 |  | 7980000 |  | I
06 |  | 3090 |  | 897228 |  | 611060 |  | 89004224 |  | 500000 |  | D
06 |  | 3090 |  | 129998 |  | 903450 |  |  |  | 500000 |  | I
06 |  | 1000 |  | 129064 |  | 618520 |  |  |  | 238000 |  | D
06 |  | 1000 |  | 129998 |  | 905330 |  |  |  | 238000 |  | I
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 9731000
[NAME]: |  |  |  |  |  |  |  |  |  |  |  | NET
 |  | [NAME]
APPROVED BY: |  |  |  |  |  | DATE |  | APPROVED BY:  DEPARTMENT HEAD |  |  |  |  |  | DATE
Spreadsheet: 866180d1713158850-finding-partial-match-in-databse-with-filter-and-xloopup-testsheet-database-v3
Sheet: Sheet1

 | Explanation
 | In Range B7:B9 you can select a filter (list) you want to use as filter. In this case either Hobbies or Interests.
 | In range C7:C9 you can type in which hobby or interest you are looking for. |  |  |  |  | FILTER(Database!N2:CW2;(XLOOKUP(B$5;Database!M1:CW1;Database!M2:CW2)=C5)
 | Filter (list) | Criteria (freefill) |  | Name | Hobby_1 | Hobby_2 | Hobby_List | Interest_List |  | All_Hobbies | All_Interests
 | Hobby_List | Bowling |  | [NAME] | Tennis | Hockey |  | Reading |  | Tennis | Reading
 | Interest_List | Walking |  | [NAME] | Bowling | n/a |  | Bowling |  | Bowling | Bowling
 |  |  |  | [NAME] | n/a | n/a |  | Traveling |  | Baseball | Traveling
 |  |  |  | Rachel | Baseball | Bowling |  | Walking |  | Hockey | Walking
 |  |  |  |  |  |  |  |  |  | Darts
 | In the table below the people that meet all the requirement you are filtering for will pop-up. |  |  |  |  |  |  |  |  | n/a
 | Matches |  |  |  |  |  | '(XLOOKUP(B$5;Database!M1:CW1;Database!M2:CW2)=C5)
 | Name | Hobby_1 | Hobby_2 | Hobby_List | Interest_List
 |  | Bowling | n/a | Bowling n/a | Bowling |  |  | Bowling | n/a | Bowling n/a | Bowling
 | Rachel | Baseball | Bowling | Baseball Bowling | Walking |  | Rachel | Baseball | Bowling | Baseball Bowling | Walking
 |  |  |  |  |  |  | False
 |  |  |  |  |  |  | False
 | ISSUE: |  |  |  |  |  | False
 | The freefill values in C7:C9 need to be an EXACT (undesired) match with [NAME]:H9 instead of a PARTIAL (desired) match to have the people show up in the above table. Typing in 'Bowling n/a' in C7 will show [NAME].
 | GOAL:
 | Desired result when typing in 'Bowling; in C6: |  |  |  |  |  | =IF(AND(B5="";C5="");"Please use at least one filter.";IF(AND(B5<>"";C5="");"Please select a criteria for your filter.";FILTER(Database!N2:CW2;(XLOOKUP(B$5;Database!M1:CW1;Database!M2:CW2)=C5)*(XLOOKUP(B$6;Database!M1:CW1;Database!M2:CW2)=C6)*(XLOOKUP(B$7;Database!M1:CW1;Database!M2:CW2)=C7)*(XLOOKUP(B$8;Database!M1:CW1;Database!M2:CW2)=C8)*(XLOOKUP(B$9;Database!M1:CW1;Database!M2:CW2)=C9)*(XLOOKUP(B$10;Database!M1:CW1;Database!M2:CW2)=C10)*(XLOOKUP(B$11;Database!M1:CW1;Database!M2:CW2)=C11)*(XLOOKUP(B$12;Database!M1:CW1;Database!M2:CW2)=C12)*(XLOOKUP(B$13;Database!M1:CW1;Database!M2:CW2)=C13)*(XLOOKUP(B$14;Database!M1:CW1;Database!M2:CW2)=C14)*(XLOOKUP(B$15;Database!M1:CW1;Database!M2:CW2)=C15)*(XLOOKUP(B$16;Database!M1:CW1;Database!M2:CW2)=C16)*(XLOOKUP(B$17;Database!M1:CW1;Database!M2:CW2)=C17)*(XLOOKUP(B$18;Database!M1:CW1;Database!M2:CW2)=C18)*(XLOOKUP(B$19;Database!M1:CW1;Database!M2:CW2)=C19)*(XLOOKUP(B$20;Database!M1:CW1;Database!M2:CW2)=C20)*(XLOOKUP(B$21;Database!M1:CW1;Database!M2:CW2)=C21)*(XLOOKUP(B$22;Database!M1:CW1;Database!M2:CW2)=C22)*(XLOOKUP(B$23;Database!M1:CW1;Database!M2:CW2)=C23);"No Influencers have been found that meet your criteria. Consider widening your filter selection.")))
 | Matches
 | Name | Hobby_1 | Hobby_2 | Hobby_List | Interest_List
 | [NAME] | Bowling | n/a | Bowling n/a | Bowling
 | Rachel | Bowling | Baseball |  | Walking