tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 754119d1635954373-search-the-nearest-number-in-a-range-with-a-criteria-beaglepapa
Sheet: Tabelle1

Eingabe-Parameter |  |  |  | [NAME], wo ein Getriebe sitzen kann |  |  | [NAME] auf dem Kragarm | KL | Getriebe | PA | Gültig Ja/Nein? | Getriebe | Gültig Ja/Nein? | Getriebe | Gültig Ja/Nein? | Getriebe | Gültig Ja/Nein? | Getriebe | Gültig Ja/Nein? | Getriebe | Gültig Ja/Nein? | Getriebe | Gültig Ja/Nein? | Getriebe | Gültig Ja/Nein? | [NAME] PA | Kontrolle Trackerlänge
 |  |  |  |  |  |  |  |  | 1 |  |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8
Modulbreite | 1134 |  |  | zwischen |  |  | 1
Modulabstand | 16
Stringlänge | 30
Pfostenanzahl | 6
[NAME] | 50
Breite Getriebe | 250 | ("Tabu-Zone" = 2 x 125)
Trackerlänge (berechnet)
Pfostenabstand PA (theoretisch opt.) |  | (bei KL = 0,35 * PA)
[NAME] (theoretisch opt.) |  | (Kontrolle: |  | (inkl. [NAME])
Pfostenabstand PA ([NAME]. rechts)
[NAME] ([NAME]. rechts)
Spreadsheet: 845155d1696679239-calculating-minutes-and-rewards-over-time-rewards-and-sanctions
Sheet: Week 2

Name | Reward | 5 Min | 10 Min | No. Time outs | Total Min in time out this week | Orange | Red | Reward Total | Average Reward For Week | Total no. Time outs
Test | 30 | 1 | 2 |  |  | Yes | Yes | 20
Kelly | 26 | 2 | 0 |  |  |  |  | 25
[NAME] | 19 | 3 | 1 |  |  |  |  | 15
Arya | 15 | 3 | 0 |  |  | Yes |  | 30
[NAME] | 7 | 0 | 2 |  |  |  | Yes | 10
Spreadsheet: 217009d1361966827-multiples-table-on-sheet-help-with-print-and-filter-sample
Sheet: Sheet1

Products Inventory
Quantity | Description |  | Quantity | Description
1 | Prod 1 |  | 0 | Prod 1
0 | Prod 2 |  | 5 | Prod 2
18 | Prod 3 |  | 10 | Prod 3
12 | Prod 4 |  | 7 | Prod 4
0 | Prod 5 |  | 4 | Prod 5
4 | Prod 6 |  | 0 | Prod 6
6 | Prod 7 |  | 0 | Prod 7
Quantity | Description |  | Quantity | Description
4 | Prod 8 |  | 0 | Prod 8
18 | Prod 9 |  | 0 | Prod 9
24 | Prod 10 |  | 4 | Prod 10
6 | Prod 11 |  | 9 | Prod 11
0 | Prod 12 |  | 9 | Prod 12
3 | Prod 13 |  | 0 | Prod 13
0 | Prod 14 |  | 8 | Prod 14
Spreadsheet: 822942d1679604862-if-function-example
Sheet: Sheet1

 |  | Steel Cost |  | 0.98 |  |  |  |  | 0.290348 |  | LB/In Cube Galv
 |  |  |  |  |  |  |  |  | 0.0396 |  | Gauge
Tap
area
SIZE | 3 | 3 | 4 | 4 | 5 | 5 | 6 | 6 | 7 | 7 | 8 | 8
3
4 |  |  |  |  |  |  |  |  |  |  | Min.
5
6
7
8
9
10
11
12
13
Spreadsheet: 273247d1382645071-if-then-and-formula-masters
Sheet: Sheet1

0 |  |  |  |  | 0 | no master
102999 |  |  |  |  | 103000 | masters [NAME]
103000 |  |  |  |  | 135000 | masters [NAME]
134999 |  |  |  |  | 167000 | masters diamond
135000
166999
167000
200000
Spreadsheet: 21115d1208267231-need-vlookup-to-miss-blanks-test
Sheet: Table

WHAT I WANT TO APPEAR
 | Ars |  | Ast
G0 | [NAME] | G0 | [NAME]
[NAME] | Łukasz Fabiański | [NAME] | [NAME]
G2 | [NAME] | G2 | [NAME]
G3 | Vito Mannone | D0 | [NAME]
D0 | [NAME] | D1 | [NAME]
D1 | [NAME] | D2 | [NAME]
D2 | [NAME] | D3 | [NAME]
D3 | [NAME] | D4 | Curtis Davies
D4 | [NAME] | D5 | Zatyai Knight
D5 | [NAME] | D6 | [NAME]
D6 | Emmanuel Eboué | M0 | [NAME]
D7 | [NAME] | M1 | [NAME]
D8 | [NAME] | M2 | [NAME]
D9 | [NAME] | M3 | [NAME]
D10 | [NAME] | M4 | [NAME]
D11 | [NAME] | M5 | [NAME]
D12 | Abu Ogogo | M6 | [NAME]
D13 | Kerrea Gilbert | M7 | [NAME]
D14 | [NAME] | F0 | [NAME]
M0 | [NAME] | F1 | [NAME]
M1 | Cesc Fábregas | F2 | [NAME]
M2 | Tomáš Rosický | F3 | [NAME]
M3 | [NAME] | F4 | [NAME]
M4 | Aliaksandr Hleb | F5 | [NAME]
M5 | [NAME]
M6 | Mathieu Flamini
M7 | [NAME]
M8 | [NAME]
M9 | [NAME]
M10 | [NAME]
M11 | [NAME]
M12 | [NAME]
[NAME] | [NAME]
F0 | Eduardo
F1 | [NAME]
F2 | [NAME]
F3 | [NAME]
Spreadsheet: 730492d1619717596-chained-xlookup-and-reverse-partial-lookup-search-lookup-sku-prefix-and-reverse-partial-lookup-colour-code-suffix
Sheet: A

SKU | Prefix | [NAME] | Colour code | Lookup result expected
B1063/24-1 | B1063 | 1 |  | [NAME])
B1063/24-2 | B1063 | 2 |  | Silver(2)
B1063/24-22 | B1063 | 22 |  | Old Gold(22)
B72/24-1 | B72 | 1 |  | Black(1)
P910/14-2 | P910 | 2 |  | Natural(2)
B500/24-22 | B500 | 22 |  | Gold(22)
B900/40-22 | B900 | 22 |  | Old Gold(22)
K100/24-22 | K100 | 22 |  | Blue(22)
B500/32-22 | B500 | 22 |  | Gold(22)
K101-GLD | K101 | GLD |  | GOLD
Spreadsheet: 02bd0bd2-505f-4d45-bbee-d474c58834ac
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
 | 5671.0 Lending Finance, Australia
 | TABLE 45. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (SA), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413770V | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413771W | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413772X | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413773A | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413774C | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413775F | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413776J | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413778L | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413779R | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413780X | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 826651d1682127480-check-whether-all-the-words-in-a-cell-appear-in-another-cell-even-if-ordered-differently-workbook_data
Sheet: Sheet1

 | Cats Pier Tree 54 68s
[NAME] values | Response | Comment
54 Trees | 1 | 54 is an exact match, Trees is a plural match (where A1 contain the plural) | 1
[NAME] | 1 | [NAME] is an exact match, Cat is a reverse plural match (where  B1 is the plural) | 1
54s Tree | 0 | Rejected as numbers can't have plurals (A1 contains the false plural, 54s) | 0
68 Tree | 0 | Rejected as numbers can't have plurals (B1 contains the false plural, 68s) | 0
Cats Pier Tr | 0 | Rejected as Tr is not a full word match with Tree | 0
Spreadsheet: 90057d1289821253-lock-columns-to-scroll-and-insert-rows-in-only-one-column-non-trade-days
Sheet: All_Dates

Date | Using VLOOKUP | Set to 0 | Set to previous
2010-10-28 00:00:00 | 123.4567 | 123.4567 | 123.4567
2010-10-29 00:00:00 | #N/A | 0 | 123.4567
2010-10-30 00:00:00 | #N/A | 0 | 123.4567
2010-10-31 00:00:00 | 124.4567 | 124.4567 | 124.4567
2010-11-01 00:00:00 | 125.4567 | 125.4567 | 125.4567
2010-11-02 00:00:00 | 126.4567 | 126.4567 | 126.4567
2010-11-03 00:00:00 | 127.4567 | 127.4567 | 127.4567
2010-11-04 00:00:00 | 128.4567 | 128.4567 | 128.4567
2010-11-05 00:00:00 | 129.4567 | 129.4567 | 129.4567
2010-11-06 00:00:00 | 130.4567 | 130.4567 | 130.4567
2010-11-07 00:00:00 | 131.4567 | 131.4567 | 131.4567
2010-11-08 00:00:00 | 132.4567 | 132.4567 | 132.4567
2010-11-09 00:00:00 | 133.4567 | 133.4567 | 133.4567
2010-11-10 00:00:00 | #N/A | 0 | 133.4567
2010-11-11 00:00:00 | #N/A | 0 | 133.4567
2010-11-12 00:00:00 | #N/A | 0 | 133.4567
2010-11-13 00:00:00 | 134.4567 | 134.4567 | 134.4567
2010-11-14 00:00:00 | 135.4567 | 135.4567 | 135.4567
2010-11-15 00:00:00 | 136.4567 | 136.4567 | 136.4567
2010-11-16 00:00:00 | 137.4567 | 137.4567 | 137.4567
2010-11-17 00:00:00 | 138.4567 | 138.4567 | 138.4567
2010-11-18 00:00:00 | 139.4567 | 139.4567 | 139.4567
2010-11-19 00:00:00 | 140.4567 | 140.4567 | 140.4567
2010-11-20 00:00:00 | 141.4567 | 141.4567 | 141.4567
2010-11-21 00:00:00 | 142.4567 | 142.4567 | 142.4567
2010-11-22 00:00:00 | 143.4567 | 143.4567 | 143.4567
2010-11-23 00:00:00 | 144.4567 | 144.4567 | 144.4567
2010-11-24 00:00:00 | 145.4567 | 145.4567 | 145.4567
2010-11-25 00:00:00 | 146.4567 | 146.4567 | 146.4567
2010-11-26 00:00:00 | 147.4567 | 147.4567 | 147.4567
2010-11-27 00:00:00 | 148.4567 | 148.4567 | 148.4567
Spreadsheet: matt_motley__26423__EMR Prices
Sheet: Sheet1

 |  | Peak |  | Off-Peak
Region | Delivery Date | Low | High | Low | High
Red numbers indicate flat, 24-hour products.
NW/N. Rockies | 2002-01-31 00:00:00 | 18.9 | 20.5 | 17.75 | 18.75
Mid-Columbia | 2002-01-31 00:00:00 | 18.9 | 20.5 | 17.75 | 18.75
COB | 2002-01-31 00:00:00 | 21.25 | 22.95 | 18 | 19.5
N. California | 2002-01-31 00:00:00 | 23.5 | 25.25 | 19 | 21
Midway/Sylmar | 2002-01-31 00:00:00 | NA | NA | NA | NA
S. California | 2002-01-31 00:00:00 | 23.75 | 25.5 | 18.5 | 21
Mead | 2002-01-31 00:00:00 | 25 | 26.25 | 18.25 | 21
Palo Verde | 2002-01-31 00:00:00 | 23 | 26 | 14.75 | 17
Inland SW | 2002-01-31 00:00:00 | 23 | 26.25 | 14.75 | 21
4-Corners | 2002-01-31 00:00:00 | 23.75 | 26.75 | 15 | 17
Central Rockies | 2002-01-31 00:00:00 | 20.75 | 23.5 | 13 | 14.5
Spreadsheet: 78e860fe-a9a6-4af5-a013-6333059056c6
Sheet: Old Forest

Analytical Key | [NAME] (ABMI) | Species (Scientific Name) | Intactness (%) | Occurrence in the Boreal Plains Ecozone (%) | Relative to Reference | Threat
BaybreastedWarbler | Bay-breasted [NAME] | Dendroica castanea | 89.1285479204144 | 12.48 | Below | ESRD - Sensitive | AB ESCC 2010 - In Process
BlackthroatedGreenWarbler | Black-throated [NAME] | Dendroica virens | 81.0424685531994 | 13.91 | Below | ESRD - Sensitive | AB ESCC 2010 - Species of Special Concern
BlueheadedsolitaryVireo | Blue-headed (solitary) [NAME] | Vireo solitarius | 79.6153402789282 | 30.54 | Below | ESRD - Secure
BorealChickadee | Boreal Chickadee | Poecile hudsonica | 76.3833226604492 | 32.35 | Below | ESRD - Secure
BrownCreeper | [NAME] | Certhia americana | 74.2538270216494 | 6.3 | Below | ESRD - Sensitive
CapeMayWarbler | Cape May [NAME] | Dendroica tigrina | 91.670615012646 | 24.2 | Below | ESRD - Sensitive | AB ESCC 2010 - In Process
GoldencrownedKinglet | Golden-crowned [NAME] | Regulus satrapa | 74.9627561142707 | 15.93 | Below | ESRD - Secure
PineSiskin | Pine Siskin | Carduelis pinus | 93.8683708682385 | 36.74 | Below | ESRD - Secure
RedbreastedNuthatch | Red-breasted Nuthatch | Sitta canadensis | 98.9766426713838 | 39.06 | Below | ESRD - Secure
SwainsonsThrush | Swainson's Thrush | Catharus ustulatus | 92.5273018002356 | 80.2 | Below | ESRD - Secure
WesternTanager | Western Tanager | Piranga [NAME] | 92.9643263538652 | 40.39 | Below | ESRD - Sensitive
WhitewingedCrossbill | White-winged Crossbill | [NAME] leucoptera | 92.9384248887636 | 47.19 | Below | ESRD - Secure
WinterWren | [NAME] | Troglodytes troglodytes | 96.9931564605766 | 31.54 | Below | ESRD - Secure
 |  | Average Intactness
Spreadsheet: 08688de9-7591-437f-b361-5cf25a09ce50
Sheet: LIHTC Calculation

CALCULATION OF TAX CREDIT
 | Project Name:
 | Date:
Tax credits are calculated on an annual basis. The total tax credit receive is equal to 10 times the annual credit
 |  |  | Yes | No
Qualified Census Tract (QCT) or Difficult to Develop Area (DDA) ?
 | Enter QCT number
 | Enter DDA area
Indicate whether your project is qualified for:
30% Net Present Value |  | (Place X under "Yes" if applicable)
70% Net Present Value |  | (Place X under "Yes" if applicable)
Both 30% & 70% |  | (Place X under "Yes" if applicable)
 |  |  | 0.3 | 0.7 | Total
Total Project Costs |  | Use applicable column (30%, 70% or both) for data entry
 | Less land; amortized and other ineligible costs *
Eligible Basis
 | Less portion of federal grant used to finance qualifying developments
 | Less amounts of nonqualified nonrecourse financing
 | Less nonqualifying costs or units of higher quality
 | Less Section 48 Rehabilitation Tax Credit
 | Less Historic Tax Credit (Rresidential Portion Only)
Total Eligible Basis
 | (Change to 130% if high cost or qualified census tract) |  | 1 | 1
Adjusted Eligible Basis
 | Multiplied by the applicable fraction |  | 1 | 1
Total Qualified Basis
 | Multiplied by the applicable percentage       (Month/Year used?   0/0)
Total Amount Of Tax Credit Allowable
Total Amount Of Tax Credit Requested
Total Tax Credits for 10 Years
Tax Credit Yield
Tax Credit Equity
 | Percentage of Limited Partnership proceeds
Net Tax Credit Investor Proceeds
* If total ineligible costs does not equal total costs less reasonable basis from Uses of Funding form, explain here.
Spreadsheet: 883804d1732533313-looking-for-function-to-find-how-many-times-an-instance-in-a-list-is-chosen-test
Sheet: Jarrell_2024

 |  |  | Selection s  day 2
 |  |  | (PG #)
29 |  |  | 29t
32 | t |  | 32t
38 |  |  | 38t
39 |  |  | 39
42 |  |  | 42
45 | t |  | 45t
45 | b |  | 45b
47 | t |  | 47t
47 | b |  | 47b
47 | b |  | 47b
48 | t |  | 48t
49 | t |  | 49t
49 | b |  | 49b
53 |  |  | 53
54 | t |  | 54t
58 |  |  | 58
60 |  |  | 60
68 | t |  | 68t
68 | b |  | 68b
73 | t |  | 73t
74 | b |  | 74b
77 | t |  | 77t
78 |  |  | 78
86 |  |  | 86
91 |  |  | 91
96 |  |  | 96
98 |  |  | 98
99 |  |  | 99
101 | t |  | 101t
101 | b |  | [NAME]
107 |  |  | 107
115 |  |  | 115
121 |  |  | 121
122 |  |  | 122
123 | t |  | 123t
128 |  |  | 128
129 |  |  | 129
133 |  |  | 133
137 |  |  | 137
138 | t |  | 138t
138 | b |  | 138b
140 |  |  | 140
142 |  |  | 142
148 |  |  | 148
159 |  |  | 159
163 | t |  | 163t
163 |  |  | 163
168 |  |  | 168
172 |  |  | 172
176 | t |  | 176t
182 |  |  | 182
183 |  |  | 183
186 |  |  | 186
192 |  |  | 192
196 |  |  | 196
199 |  |  | 199
200 |  |  | 200
203 |  |  | 203
210 |  |  | 210
215 |  |  | 215
216 |  |  | 216
217 |  |  | 217
220 |  |  | 220
222 |  |  | 222
230 |  |  | 230
235 |  |  | 235
239 |  |  | 239
240 |  |  | 240
268 | b |  | 268b
268 |  |  | 268
269 |  |  | 269
270 |  |  | 270
274 |  |  | 274
276 |  |  | 276
277 |  |  | 277
282 |  |  | 282
283 |  |  | 283
288 |  |  | 288
298 |  |  | 298
299 |  |  | 299
306 |  |  | 306
319 |  |  | 319
331 | b |  | 331b
332 |  |  | 332
335 |  |  | 335
343 | b |  | 343b
355 |  |  | 355
356 |  |  | 356
365 |  |  | 365
372 |  |  | 372
373 |  |  | 373
376 |  |  | 376
377 |  |  | 377
380 | t |  | 380t
380 | b |  | 380b
383 |  |  | 383
392 |  |  | 392
404 |  |  | 404
406 |  |  | 406
410 |  |  | 410
411 |  |  | 411
414 |  |  | 414
421 |  |  | 421
422 | t |  | 422t
422 | b |  | 422b
424 |  |  | 424
425 |  |  | 425
427 |  |  | 427
434 |  |  | 434
436 | t |  | 436t
442 | t |  | 442t
444 | t |  | 444t
463 |  |  | 463
464 |  |  | 464
477 |  |  | 477
478 |  |  | 478
485 |  |  | 485
505 |  |  | 505
514 |  |  | 514
520 |  |  | 520
522 |  |  | 522
524 |  |  | 524
535 | t |  | 535t
541 |  |  | 541
543 |  |  | 543
552 |  |  | 552
553 |  |  | 553
558 |  |  | 558
559 |  |  | 559
568 |  |  | 568
569 |  |  | 569
571 |  |  | 571
572 |  |  | 572
576 |  |  | 576
Spreadsheet: debra_perlingiere__8421__Interconn Resources Omnibus
Sheet: Baby Credit Form  

ECT COUNTERPARTY CREDIT APPROVAL  FORM
Counterparty's Name : |  |  |  |  |  |  |  | Ctypty | Ult. Parent
Address: |  |  |  |  |  |  | S&P
 |  |  |  |  |  |  | MOODY'S
Ultimate Parent: |  |  |  |  |  |  | E - Rating
Address: |  |  |  |  |  |  | Most Recent Financials:
RECOMMENDATION:
 |  | CTRPTY CREDIT FACILITIES
 |  |  |  | Previous Guidance |  | New  Guidance
 |  | Instrument Description: |  | Facility |  | Facility
 |  | Physical Delivery
 |  | Physical MTM
 |  | Financial MTM
 |  | Liquids Delivery & MTM
 |  | Power or SO2 Delivery
 |  | Power or SO2 MTM
 |  | Int'l Fuel Oil Delivery
 |  | Int'l Fuel Oi MTM
 |  | TOTAL CTYPTY LIMIT
 |  | FOR TOTAL RELATIONSHIP CREDIT LIMITS SEE PARENT COMPANY FILE
Master/ Other Requiring Compliance Check? |  |  |  | N/AP |  | YES |  | NO
If YES, Conterparty in Compliance as of |  |  | . | YES |  |  | NO
IF NOT IN COMPLIANCE, SEE COMPLIANCE CHECK FORM DATED                                        .
PREPARED BY: |  |  |  |  |  | DATE
 |  | NAME |  |  | TITLE
APPROVED BY: |  |  |  |  |  | DATE
 |  | NAME |  |  | TITLE
(filename: t:\credit\forms2\star1.XLS)
Spreadsheet: 2617181e-9afc-4f79-968f-f120edd4ac3d
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 14998417924 | Bishop [NAME] | I Still Believe | 2009-06-02 | Compact Disc | Gospel | 15.99 | Y | Available
Taseis | 14998417993 | Bishop [NAME] | I Still Believe | 2009-06-02 | Music DVD | Gospel | 15.99 | Y | Available
Spreadsheet: 34593d1231907471-auto-load-data-problem-board
Sheet: Sheet1

 |  |  |  |  |  | Other
 |  | BOARD CARRIED OVER |  |  |  | Board
 |  | TOTAL BOARD |  |  |  | Gas
 |  | TOTAL PAID |  |  |  | Movie Rental
 |  |  |  |  |  | Food
Date |  | Note | Paid | Added On | BOARD OWING | Phone [NAME]
Spreadsheet: 775913d1649378959-lookup-type-formula-required-dealing-with-merged-cells-and-data-formatted-as-text-forum-example
Sheet: Unit Three

This report displays the completion of a course by staff in a specific unit. Only some of the courses attended are being reported on. If the staff member has not attended the course the Course Name column will be blank.
Number of unique employees listed in the Unit |  |  | % complete
Course AAA | (Completed)
Course ABC | (Completed)
Course EFG | (Completed)
Course XYZ | (Completed)
Immediate CPR
Compulsory Clinical Training/Pain-Nurses/Midwives
Compulsory Clinical Training/Pain-Nurses/Midwives
UNIT_NAME: Three |  |  |  |  |  |  | 2 | Years
EmpNumber | FullName | PosTitle | [NAME] | Date completed course | Course Name | Status | Next Due Date
Spreadsheet: 298308d1392755557-find-a-value-in-a-table-with-multiple-values-test-excel-data-search-sheet
Sheet: ON-2

Ontario Production line number |  | ON-2
Date | PO # | Buyer | Division Line | Model | Trailer Description | Serial # | Build Location/Line | Est. Delivery Date | [NAME] | Min Day | [NAME] | Earliest D date | Latest D date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-01-01 00:00:00
Spreadsheet: 846053d1697352214-return-corresponding-values-and-notes-comments-with-matching-criteria-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Input Area Name | Area9
Activities List | [NAME] | Area2 | Area3 | Area4 | Area5 | Area6 | Area7 | Area8 | Area9 |  |  | Required output |  |  | Notes
Activity1 | R | R | R | R | R | R | R | R | R |  |  |  | Activity1
Activity2 |  |  |  |  |  |  |  |  |  |  |  |  | Activity3 | Activity3 | [NAME] 3
Activity3 | R | R | R | R | R | R | R | R | R |  |  |  | Activity7 | Activity7
Activity4 | R | R | R |  |  |  |  | R |  |  |  |  | Activity9 | Activity9
Activity5 | R | R | R |  |  |  |  | R |  |  |  |  | Activity10 | Activity10 | Crosscheck with [NAME]
Activity6 | R | R | R |  |  |  |  |  |  |  |  |  | Activity13 | Activity13
Activity7 | R | R | R | R | R | R | R | R | R |  |  |  | Activity14 | Activity14
Activity8 | R | R |  |  |  |  |  |  |  |  |  |  | Activity16 | Activity16
Activity9 | R | R | R | R | R | R | R | R | R |  |  |  | Activity31 | Activity31
Activity10 | R | R | R | R | R | R | R | R | R |  |  |  | Activity44 | Activity44 | move it from "R" to "O" category, i.e. Optional
Activity11 | R | R
Activity12 | R | R | R
Activity13 | R | R | R | R | R | R | R | R | R
Activity14 | R | R | R | R | R | R | R | R | R
Activity15 | R | R
Activity16 | R | R | R | R | R | R | R |  | R
Activity17 | R | R | R |  |  |  |  | R
Activity18 | R | R
Activity19 | R | R | R
Activity23 |  | R | R
Activity24 |  | R | R
Activity25 | R |  |  | R
Activity26 | R
Activity27 | R
Activity28 | R
Activity29 | R
Activity30 | R
Activity31 | R |  |  | R | R | R | R | R | R
Activity32 | R |  |  | R
Activity33 | R
Activity34 | R |  |  |  |  |  |  | R
Activity35 | R |  |  |  |  |  |  | R
Activity36 | R |  |  | R | R | R | R
Activity37 | R |  | R
Activity38 | R
Activity39 | R
Activity40 | R
Activity41 | R |  |  |  |  |  |  | R
Activity42 | R
Activity43 | R
Activity44 | R |  |  |  | R | R | R |  | R
Activity45 | R |  |  | R | R | R | R
Activity46 | R |  |  |  | R
Activity47
Activity48
Activity49
Activity50 |  |  | R
Activity51 |  |  |  | R
Spreadsheet: 9953c751-6a54-477e-b53f-3dcfaf73da94
Sheet: Sheet1

WB | Monday | Tuesday | Wednesday | Thursday | Friday
6th September
13th September
20th September
27th September
4th October
11th October
18th October |  |  |  | Invasion Games - MB/H
25th October
1st November
8th November
15th November
22nd November
29th November |  |  |  |  | Boccia & New Age Kurling Festival - (P)
6th December
13th December
20th December
27th December
3rd January
10th January
17th January
24th January |  | Athletics & UKAA Awards - MB
31st January
7th February
14th February
21st  February
28th February
7th March
14th March |  | Aquasplash Festival - H Ac
21st March
28th March
4th April
11th April
18th April
25th April |  |  |  | Netwall Games/Racket Skills - Havant Ac
2nd May
9th May
16th May
23rd May |  | Boccia & New Age Kurling Festival - H Ac
30th May
6th June
13th June
20th June |  |  | CAD
27th June - NSSW
4th July
11th July
18th July
25th July
Spreadsheet: 75286d1275880980-identifying-data-within-data-boroughs
Sheet: Sheet1

Employee ID | Office number | Borough
 |  | The first letter of each school number indicates the borough that the office is in.  Determine which borrough each office is located in. (X: Bronx, M: Manhattan, Q: Queens, R: Staten Island, K: Brooklyn)
111213 | M497
111910 | K195
112310 | X525
112410 | Q496
113610 | X430
115210 | K012
115315 | Q217
116510 | K361
117110 | X184
117610 | K440
117910 | M164
119110 | Q090
Spreadsheet: 729576d1619178760-if-function-with-one-result-being-a-dropdown-choice-based-on-criteria-if-with-data-validation-query
Sheet: Sheet1

 |  |  |  |  |  |  | Invoices with Multiple names on it.
 | Data name | Invoice | Name |  |  |  | Invoice | Names
 | [NAME] | 1 |  |  |  |  | 2 | [NAME]
 | [NAME] | 2 |  |  |  |  | 2 | [NAME]
 | [NAME] | 2 |  |  |  |  | 5 | [NAME]
 | Amelia D | 3 |  |  |  |  | 5 | [NAME]
 | [NAME] | 4 |  |  |  |  | 5 | [NAME]
 | [NAME] | 5 |  |  |  |  | 5 | [NAME] A
 | [NAME] | 5 |  |  |  |  | 5 | Coco C
 | Tbl_Data column b&C is data report driven
 | Tbl_Data column d is where I am developing the formula
 | [NAME] is Manually created after investigating invoices.
 | Some invoices have only one name, some invoices have multiple names.
 | The data only ever shows the first name on the invoice.
 | Tbl_Names is a manual breakout of invoices with Manual names.
 | The goal is to create a formula, that if the invoice number in the Tbl_Data shows on Tbl_Names, a data validation dropdown shows up in column D for only the names related to that particular invoice Number
 | If the invoice is not in Tbl_names, it should show the name in Column B.
 | looking for
 | Data name | Invoice | Name
 | [NAME] | 1 | [NAME]
 | [NAME] | 2 | - Data validation dropdown could chose from [NAME] or [NAME] R
 | [NAME] | 2 | - Data validation dropdown could chose from [NAME] or [NAME] R
 | Amelia D | 3 | Amelia D
 | [NAME] | 4 | [NAME]
 | [NAME] | 5 | - Data validation dropdown could chose from [NAME], [NAME], [NAME], [NAME]
 | [NAME] | 5 | - Data validation dropdown could chose from [NAME], [NAME], [NAME], [NAME]