tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0a12855e-deea-48cd-be0f-26cb841dc0e7
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21
 | International Instructor Course
 |  | 27 - 29 September 2013
 |  | Warsaw, Poland
 |  |  | HOTEL ACCOMMODATION APPLICATION FORM
Name of School / Association |  |  |  |  |  |  | Name of contact person
[NAME] |  |  |  |  |  |  |  | [NAME]
 | [NAME] | Departure | indicate  requested | Indicate the persons to Share the Room |  |  |  |  |  | Room | Total | Total   Room
 | Date | Date | Room type | Name | Surname | Name | Surname | Name | Surname | Price x night | Nights | Price
Room 1 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | Single (B&B) |  | 55 | 1 | 0 | 0 | 1
Room2 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | Single (Full Board) |  | 75 | 0 | 0 | 0 | 0
Room 3 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | Double (B&B) |  | 40 | 0 | 0 | 0 | 0
Room 4 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | Double (Full Board) |  | 60 | 0 | 0 | 0 | 0
Room 5 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | Twin (B&B) |  | 40 | 0 | 0 | 0 | 0
Room 6 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | Twin (Full Board) |  | 60 | 0 | 0 | 0 | 0
Room 7 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | Triple (B&B) |  | 40 | 0 | 0 | 0 | 0
Room 8 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | Triple (Full Board) |  | 60 | 0 | 0 | 0 | 0
Room 9 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
Room 10 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
Room 11 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
Room 12 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
Room 13 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
Room 14 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
Room 15 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | TOTAL | 0
ATTENTION |  | SEND THIS APPLICATION FORM ON OR BEFORE August 26th 2013 to [EMAIL]
Spreadsheet: john_griffith__15911__11_13_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | 21.5 | 55 | 65 | 61.2 | 72.3 | 0.9 | 2001-11-13 14:31:00
 | CL F2 | 22 | 255 | 265 | 50 | 52 | 0.71 | 2001-11-13 14:31:00
 | CL G2 | 22 | 360 | 370 | 49.4 | 50.8 | 0.69 | 2001-11-13 14:31:00
 | CL H2 | 22 | 432 | 444 | 49.4 | 50.7 | 0.69 | 2001-11-13 14:31:00
 | CL J2 | 22 | 485 | 490 | 48.6 | 49.1 | 0.68 | 2001-11-13 14:31:00
 | CL K2 | 22 | 525 | 540 | 46.9 | 48.2 | 0.66 | 2001-11-13 14:31:00
 | CL M2 | 22 | 545 | 555 | 44.9 | 45.7 | 0.63 | 2001-11-13 14:31:00
 | CL N2 | 22 | 565 | 580 | 43.1 | 44.2 | 0.6 | 2001-11-13 14:31:00
 | CL Q2 | 22 | 570 | 585 | 40.9 | 41.9 | 0.57 | 2001-11-13 14:31:00
 | CL U2 | 22 | 572 | 587 | 39 | 40 | 0.55 | 2001-11-13 14:31:00
 | [NAME] | 22 | 575 | 590 | 37.2 | 38.1 | 0.52 | 2001-11-13 14:31:00
 | CL X2 | 22 | 580 | 595 | 35.9 | 36.9 | 0.5 | 2001-11-13 14:31:00
 | [NAME] | 22 | 590 | 600 | 35.3 | 35.9 | 0.49 | 2001-11-13 14:31:00
 | CL M3 | 21.5 | 575 | 595 | 29.6 | 30.6 | 0.41 | 2001-11-13 14:31:00
 | CL Z3 | 21.5 | 575 | 595 | 26.2 | 27.2 | 0.36 | 2001-11-13 14:31:00
Spreadsheet: 95188d1294850632-problem-with-pivot-table-top-10-filter-jason-pivot
Sheet: Sheet2

Fiscal Year | 2011
Period | (All)
Month | (All)
Row Labels | Sum of Tons
PHOSPHATE | 593248.79
SULFUR PRODUCTS | 69894.88
RUBBER | 48307.54000000001
SCRAP STEEL PRODUCTS | 38529.62
ORE, MICA, SCHIST | 23148.3
METAL PRODUCTS (EXCL SCRAP) | 21924.01
OTHER BULK | 15728.49
MILITARY | 2939.14
FOREST PRODUCTS | 1134.02
OTHER BREAKBULK | 118.6
Grand Total | 814973.3900000001
Spreadsheet: 833299d1686890980-finding-top-5-with-multiple-criteria-and-solving-for-duplicate-results-results-test-ans
Sheet: Sheet1 (2)

 |  | Example 1 |  |  |  |  |  |  |  |  |  |  | Example 2
 |  | State | Store | Day 1 |  | Top 5 Restaurants |  |  |  |  |  |  | State | Store | Day 1 |  | Top 5 Restaurants
 |  | CA | [NAME] 1 | 487 |  | CA | 1 |  |  |  |  |  | CA | [NAME] 1 | 487 |  | CA | 1
 |  | CA | [NAME] 2 | 790 |  |  | 2 |  |  |  |  |  | CA | [NAME] 2 | 790 |  |  | 2
 |  | CA | [NAME] 3 | 734 |  |  | 3 |  |  |  |  |  | CA | [NAME] 3 | 734 |  |  | 3
 |  | CA | [NAME] 4 | 790 |  |  | 4 |  |  |  |  |  | CA | [NAME] 4 | 790 |  |  | 4
 |  | CA | [NAME] 5 | 471 |  |  | 5 |  |  |  |  |  | CA | [NAME] 5 | 471 |  |  | 5
 |  | CA | [NAME] 6 | 856 |  | NV | 1 |  |  |  |  |  | CA | [NAME] 6 | 856
 |  | CA | [NAME] 7 | 457 |  |  | 2 |  |  |  |  |  | CA | [NAME] 7 | 457
 |  | CA | [NAME] 8 | 276 |  |  | 3 |  |  |  |  |  | CA | [NAME] 8 | 276
 |  | CA | [NAME] 9 | 407 |  |  | 4 |  |  |  |  |  | CA | [NAME] 9 | 407
 |  | CA | [NAME] 10 | 302 |  |  | 5 |  |  |  |  |  | CA | [NAME] 10 | 302
 |  | NV | [NAME] 1 | 114 |  | TX | 1
 |  | NV | [NAME] 2 | 401 |  |  | 2
 |  | NV | [NAME] 3 | 301 |  |  | 3
 |  | NV | [NAME] 4 | 507 |  |  | 4
 |  | NV | [NAME] 5 | 815 |  |  | 5
 |  | NV | [NAME] 6 | 815 |  | HI | 1
 |  | NV | [NAME] 7 | 277 |  |  | 2
 |  | NV | [NAME] 8 | 360 |  |  | 3
 |  | NV | [NAME] 9 | 204 |  |  | 4
 |  | NV | [NAME] 10 | 523 |  |  | 5
 |  | TX | [NAME] 1 | 699 |  | FL | 1
 |  | TX | [NAME] 2 | 377 |  |  | 2
 |  | TX | [NAME] 3 | 482 |  |  | 3
 |  | TX | [NAME] 4 | 960 |  |  | 4
 |  | TX | [NAME] 5 | 247 |  |  | 5
 |  | TX | [NAME] 6 | 721
 |  | TX | [NAME] 7 | 534
 |  | TX | [NAME] 8 | 960
 |  | TX | [NAME] 9 | 366
 |  | TX | [NAME] 10 | 284
 |  | HI | HI Store 1 | 691
 |  | HI | HI Store 2 | 313
 |  | HI | HI Store 3 | 568
 |  | HI | HI Store 4 | 180
 |  | HI | HI Store 5 | 446
 |  | HI | HI Store 6 | 407
 |  | HI | HI Store 7 | 714
 |  | HI | HI Store 8 | 828
 |  | HI | HI Store 9 | 531
 |  | HI | HI Store 10 | 300
 |  | FL | FL Store 1 | 640
 |  | FL | FL Store 2 | 176
 |  | FL | FL Store 3 | 471
 |  | FL | FL Store 4 | 337
 |  | FL | FL Store 5 | 115
 |  | FL | FL Store 6 | 241
 |  | FL | FL Store 7 | 797
 |  | FL | FL Store 8 | 819
 |  | FL | FL Store 9 | 470
 |  | FL | FL Store 10 | 244
Spreadsheet: 275754d1383636042-summing-delimited-numbers-lucrin-sample
Sheet: Sheet1

1/9/18/2/15/5/7/3
5/5/3/2
3/5/6/7/8/9/1/2/3/4/5/6/7/8/9/2/1/3/4/5/6/7/8/2/3/4/5
1/2/2/2/2
2
1/2/3/4/
2/4/5/
6////6////6/6/6/
8\\\///8\\\///
9/9/9/9++++9+++9
1//?????2
total sum
Spreadsheet: 269622d1381234243-sumifs-not-working-as-i-would-like-book2
Sheet: Sheet1

 | Customer | Job | Revenue | Associated Costs | Start Date | End Date
 | Customer 1 | Monthly Support | 75 | 15 | 2013-05-01 00:00:00 | 2100-01-01 00:00:00
 | Customer 2 | New Server | 7152 | 2158.37 | 2013-09-13 00:00:00 | 2013-09-13 00:00:00
 | Customer 2 | Monthly Support | 175 | 18.7 | 2013-05-01 00:00:00 | 2013-05-31 00:00:00
 | Customer 2 | Monthly Support | 130 | 0 | 2013-06-01 00:00:00 | 2100-01-01 00:00:00
 | Customer 3 | Monthly Support | 50 | 10 | 2013-05-01 00:00:00 | 2100-01-01 00:00:00
 | Customer 4 | Monthly Support | 100 | 0 | 2013-05-01 00:00:00 | 2100-01-01 00:00:00
Spreadsheet: benjamin_rogers__905__ny prices 09_17_01
Sheet: Dec Data

 |  |  |  |  |  |  |  |  |  |  | 16 Hr Avg |  |  |  |  |  | [NAME]
 |  | Day Ahead Prices |  |  |  |  |  |  |  |  | NYISO |  | Net |  | [NAME]. |  | Bids | MW's | Generation |  | Temps (NYC)
Date |  | Zone A | % | Zone G | % | Zone J | % | PJM | % |  | Load |  | Imports |  | MW's |  | (Offered) | Change | Bids % |  | Hi/Lo |  | Outages
2001-12-01 00:00:00 |  | 23.58 |  | 30.84 |  | 31.68 |  |  |  |  | 16803 |  | 0.405
 |  | 23.47 |  | 26.69 |  | 27.1 |  |  |  |  | 16456 |  | 0.461
 |  | 22.68 |  | 26.25 |  | 29.48 |  |  |  |  | 19715 |  | 0.42
 |  | 23.16 |  | 26.65 |  | 27.3 |  |  |  |  | 19725 |  | 0.403
 |  | 23.34 |  | 27.34 |  | 29.19 |  |  |  |  | 19640 |  | 0.675
 |  | 22.17 |  | 26.99 |  | 28.29 |  |  |  |  | 19531 |  | 0.598
 |  |  |  |  |  |  |  |  |  |  | 19153
 |  |  |  |  |  |  |  |  |  |  | 17222
 |  |  |  |  |  |  |  |  |  |  | 17000
 |  |  |  |  |  |  |  |  |  |  | 20052
 |  |  |  |  |  |  |  |  |  |  | 20251
 |  |  |  |  |  |  |  |  |  |  | 20276
 |  |  |  |  |  |  |  |  |  |  | 20303
 |  |  |  |  |  |  |  |  |  |  | 19946
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44/34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47/32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44/33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42/34
1st Week Avg
2nd Week Avg
3rd Week Avg
4th Week Avg
5th Week Avg
[NAME]
Spreadsheet: 147314d1332729661-help-with-vlookup-lookup_file
Sheet: Sheet1

TAKEN | TEMPLATE
299 | 450
292 | 572
ITL5 | 817
572 | 1848
609 | 268
ITL2 | 303
450 | 483
268 | 888
303 | 1082
817 | 292 | 1
607 | 601
ITL3 | 602
1848 | 603
888 | 604
1082 | 605
ITL1 | 607
483 | 608
603 | 609
604 | 610
73 | 200
451 | 213
257 | 224
605 | 230
602 | 27
608 | 32
610 | 41
439 | 6
601 | 73
6 | 95
213 | ITL1
32 | ITL2
179 | ITL3
224 | ITL4
230 | ITL5 | 1
41 | 179
27 | 257
95 | 431
431 | 439
200 | 451
401 | 107
402 | 1168
403 | 1285
404 | 129
405 | 1295
406 | 1306
407 | 1309
410 | 131
411 | 132
414 | 133
415 | 135
416 | 137
417 | 148
418 | 149
419 | 159
421 | 162
422 | 186
423 | 187
424 | 188
425 | 189
426 | 190
427 | 191
428 | 193
429 | 194
430 | 197
431 | 201
433 | 202
434 | 207
435 | 208
436 | 209
438 | 211
440 | 215
441 | 216
442 | 219
443 | 220
444 | 224
447 | 225
451 | 226
454 | 229
455 | 230
463 | 233
464 | 235
603 | 236
608 | 237
609 | 2373
610 | 2374
611 | 240
616 | 2403
620 | 241
633 | 2412
634 | 242
635 | 245
510 | 251
507 | 257
509 | 258
 | 2583
 | 259
 | 261
 | 263
 | 265
 | 266
 | 267
 | 268
 | 270
 | 273
 | 274
 | 275
 | 279
 | 281
 | 284
 | 287
 | 288
 | 289
 | 292
 | 294
 | 295
 | 296
 | 297
 | 298
 | 299 | 1
 | 301
 | 302
 | 304
 | 307
 | 312
 | 314
 | 317
 | 320
 | 321
 | 322
 | 323
 | 329
 | 332
 | 401
 | 402
 | 403
 | 404
 | 405
 | 406
 | 407
 | 408
 | 410
 | 411
 | 414
 | 415
 | 416
 | 417
 | 418
 | 419
 | 421
 | 422
 | 423
 | 424
 | 425
 | 426
 | 427
 | 428
 | 429
 | 430
 | 431
 | 433
 | 434
 | 435
 | 436
 | 438
 | 440
 | 441
 | 442
 | 443
 | 444
 | 447
 | 451
 | 454
 | 455
 | 463
 | 464
 | 501
 | 503
 | 505
 | 507
 | 509
 | 510
 | 512
 | 513
 | 514
 | 515
 | 516
 | 517
 | 518
 | 519
 | 520
 | 521
 | 522
 | 523
 | 524
 | 525
 | 526
 | 527
 | 528
 | 529
 | 530
 | 533
 | 535
 | 537
 | 538
 | 539
 | 541
 | 542
 | 544
 | 546
 | 548
 | 549
 | 550
 | 551
 | 552
 | 553
 | 555
 | 558
 | 560
 | 603
 | 608
 | 609
 | 610
 | 611
 | 616
 | 619
 | 620
 | 625
 | 626
 | 627
 | 628
 | 630
 | 633
 | 634
 | 635
 | 636
Spreadsheet: 756760d1637763624-move-data-from-one-sheet-to-another-which-matches-two-criteria-example-spreadsheet-4-
Sheet: Master sheet (no load)

Site details |  |  |  |  |  |  |  | 2021-11-01 00:00:00 |  |  |  | 2021-11-02 00:00:00 |  |  |  | 2021-11-03 00:00:00 |  |  |  | 2021-11-04 00:00:00 |  |  |  | 2021-11-05 00:00:00
Route | Route order | Status | Company | Code | Site | Address | Postcode | Level of completion | To charge | Cost | Profit | Level of completion | To charge | Cost | Profit | Level of completion | To charge | Cost | Profit | Level of completion | To charge | Cost | Profit | Level of completion | To charge | Cost | Profit
Text | Text | Text | Text | Text | Site 1 | Text | Text
Text | Text | Text | Text | Text | Site 2 | Text | Text
Text | Text | Text | Text | Text | Site 3 | Text | Text
Text | Text | Text | Text | Text | Site 4 | Text | Text
Text | Text | Text | Text | Text | Site 5 | Text | Text
 |  | This is an example of the master sheet with some of the pre excisitng columns in place. Note that the site order is not the same.
Spreadsheet: fbea23b4-6237-4622-9315-103b07e54f27
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
2905 | 7804 | Corinne | [NAME] | RSA | 21 | 00:23:21 | 00:00:17 | 01:00:09 | 00:00:17 | 00:41:27 | 1 | 02:05:32
2905 | 12801 | Fabienne | St Louis | MRI | 22 | 00:25:57 | 00:00:16 | 01:02:54 | 00:00:29 | 00:49:45 | 2 | 02:19:24
Spreadsheet: 586287d1534289083-data-validation-dropdown-and-disable-cell-copy-of-book-1-asdubai-
Sheet: data

Job Pending Description | Priority | Current Status | Closing Date | Time Status | Q-Status | [NAME] | Delivery Status | Delivery Date | [NAME]
Quotation | High | work in progress | 2018-08-02 00:00:00 | Due & Past Due | jhgfsf# | jhgfsf# | partial delivery | 2018-01-02 00:00:00 | abc
LPO | High | pending | 2018-08-16 00:00:00 | Still time | jhgfsf# | jkshg | pending delivery | 2018-01-03 00:00:00 | def
Others | High | task completed | 2018-08-01 00:00:00 | Closed | M,DBZBF | GJFH
if QUOTATION & LPO was selected in column A, delivery status to delivery remarks column H,I AND J you can use the dropdown list and input the date and remarks
if OTHERS was selected in column A, delivery status to delivery remarks column H,I AND J will be disable and you cannot input any data
Spreadsheet: 791986d1660681145-check-tab-not-checking-out-help
Sheet: NORTHERN

 | CENTRAL |  |  | MID-ATLANTIC |  |  | MIDWEST |  |  | NEW ENGLAND |  |  | NJ METRO |  |  | NORTHERN PLAINS |  |  | NY METRO |  |  | OHIO VALLEY |  |  | TOTAL NORTHERN |  |  |  | Check
EVENT NAME | Q3 | Q4 | 2H | Q3 | Q4 | 2H | Q3 | Q4 | 2H | Q3 | Q4 | 2H | Q3 | Q4 | 2H | Q3 | Q4 | 2H | Q3 | Q4 | 2H | Q3 | Q4 | 2H | Q3 | Q4 | 2H |  | Q3 | Q4 | 2H
CEILING FANS
SPRING GIFT CENTER
OUTDOOR CLEANING TRAIN
GRILL EVENT
Q2 SPECIAL BUYS
SUMMER PAINT EVENT
HURRICANE TRAIN
POWER TRAIN WAVE 3
TOOL DAYS
BACK TO CAMPUS
BRUSHFIRE AND BLACKOUT TRAIN
Q2 CLEANING TRAIN
POWER TRAIN WAVE 4
Q3 SPECIAL BUYS
SUMMER CLEANING TRAIN
SUMMER STORAGE
GARAGE STORAGE
BATTERY TRAIN
SUMMER BATH
HEATED GEAR AND WORKWEAR
LABOR DAY PAINT
HALLOWEEN
HALLOWEEN HOOKUP
FIRE & SAFETY
POWER TRAIN WAVE 5
FALL CLEANUP
HOLIDAY HOOKUP
DECO HOLIDAY
HOLIDAY SPECIAL BUYS
[NAME]
SMART HOME TRAIN
WINTER STORAGE
Q4 TOOL STORAGE
2023 Q1 EVENTS
TOTAL EVENTS
MAP
OFF-SHELF TOTAL
Spreadsheet: 140886d1328923648-large-database-yfeb-food-total-values
Sheet: 2-18-12

 | Breakfast | Quantity | Measure | Food Item | Cost | Daily Points
 | Daily Total
 | Lunch | Quantity | Measure | Food Item | Cost | Daily Points
 | Dinner | Quantity | Measure | Food Items | Cost | Daily Points
Spreadsheet: 872231d1718635880-create-unique-header-and-its-data-below-on-different-column-create-header-list-and-its-datalist
Sheet: Sheet1

Region | Name |  |  | Desired Result as Dynamic Array |  |  |  | Assume tblRegionName increase in data size |  |  |  |  | Desired Result as Dynamic Array (with new data size)
North | [NAME]
North | Doe |  |  | North |  |  |  | Region | Name |  |  |  | North
North | [NAME] |  |  |  | [NAME] |  |  | North | [NAME] |  |  |  |  | [NAME]
South | [NAME] |  |  |  | Doe |  |  | North | Doe |  |  |  |  | Doe
 |  |  |  | South |  |  |  | South | [NAME] |  |  |  | South
Note tblRegionName |  |  |  |  | [NAME] |  |  | South | [NAME] |  |  |  |  | [NAME]
is on another workbook |  |  |  |  | [NAME] |  |  | West | [NAME] |  |  |  |  | [NAME]
 |  |  |  | Total Region |  |  |  | West | [NAME] |  |  |  | West
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | Total Region Beginning |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | Total Region Net Change |  |  |  |  |  |  |  |  | Total Region
 |  |  |  | Total Region End
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Region Beginning
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Region Net Change
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Region End
 |  |  |  |  | [NAME]
 |  |  |  |  | Doe
 |  |  |  | South
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  | West
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  | Total Region
 |  |  |  | Total Region beginning
 |  |  |  | Total Region Net Change
 |  |  |  | Total Region End
Spreadsheet: 116389d1311794657-excel-2007-help-with-an-if-function-excel-forum-help-2
Sheet: Sheet1

 |  |  |  | Control
 |  |  |  | Check
2011 |  | 2011 |  |  |  |  |  |  |  |  |  |  |  | Control | Comments
Budget | Allocate | Jan | Feb | Mar | Apr | May | Jun | July | Aug | Sept | Oct | Nov | Dec | Check
2500 | Monthly | here | here | here | here | here | here | here | here | here | here | here | here |  | have monthly divide the budget number by 12 and input that in each month
6500 | Custom | 0 | 0 | 0 | 0 | 1000 | 4000 | 1500 | 0 | 0 | 0 | 0 | 0 |  | for custom, just enter in the data myself
5000 | Quarterly | here |  |  | here |  |  | here |  |  | here |  |  |  | have quarterly divide by 4 and input in jan, apr, july, oct
9800 | Semiannually |  |  |  |  |  | here |  |  |  |  |  | here |  | have semi divide by 2 and input in jun and dec
100000 | Anually | here |  |  |  |  |  |  |  |  |  |  |  |  | have anually input in jan
Spreadsheet: 717734d1612816945-trying-to-concatenate-multipe-cells-that-woudl-then-build-a-reference-to-a-named-cell-defnined-named-cell-name-being-called-by-concatenation-of-multiple-other-cells
Sheet: Employee

 | Employee | Sales plan
 | [NAME] | NBZ
 | [NAME] | STD
 | [NAME] | ENT
Spreadsheet: 136988d1326903026-help-with-vlookup-and-if-in-the-same-statment-help-if-and-vlookup
Sheet: P

 | Test P
 | ID | NIF |  | Nome | Conc | Observações
 | 1 | 1131 | 0170283_11V2 | ANA |  | Recusa: Alteração do Perfil de Risco
 | 2 | 1132 | 0169519_11V2 | ANA |  | Recusa: Alteração perfil [NAME] (autorização de risco)
 | 3 | 1133 | 01779959_11v2 | ANA |  | Exemplar a Enviar páginas 3 e 4
 | 4 | 1134 | 01779959_11v3 | ANA |  | Falta: Cópia de BI
 | 5 | 1135 | 01779959_11v4 | ANA |  | Falta: NIB  do Contrato
 | 6 | 1136 | 01779959_11v5 | ANA |  | Falta: Valor Correcto do Custo
 | 7 | 1137 | 01779959_11v6 | ANA |  | Copia BI legivel
 | 8 | 1138 | 01779959_11v7 | ANA |  | Contrato com Valor Correcto
 | 9 | 1139 | 01779959_11v8 | ANA |  | Contrato com [NAME]
 | 10 | 1140 | 01779959_11v9 | ANA |  | Tipo de contrato
Spreadsheet: 689435d1596395526-formulae-based-on-references-to-an-array-changes-when-adding-a-row-to-pivot-table-forum-workbook
Sheet: Sheet1

1 | 4 | 7
2 | 6 | 0
4 | 8 | 9
3 | 5 | 9
8 | 1 | 5
2 | 6 | 0
4 | 7 | 9
1 | 5 | 0
6 | 3 | 1
7 | 8 | 2
Spreadsheet: 84b511a5-8139-4f77-b6a3-e1e200dc648d
Sheet: Sheet1

Item Description | Weight | Arm | Moment | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Aircraft Empty Weight | 1747.5 | 41.6 | 72.696 | Approximate Basic Empty Weight for this model 1747.5
Usable fuel ([NAME] 53 gal) | 0 | 48.095 | 0 | Useable fuel on board |  | 0 | Gallons
Pilot and Front Pax | 0 | 37.058 | 0
Rear Pax | 0 | 73 | 0 | Fuel Burned Enroute |  | 0 | Gallons
*Baggage A (120 lbs [NAME].) | 0 | 90 | 0
*Baggage B (50 lbs [NAME].) | 0 | 130 | 0
[NAME] | 1747.5 |  | 72.696
Fuel burn for taxi, startup | -8 | 48.1 | -0.3848
Take Off Weight | 1739.5 |  | 72.3112
Fuel burn enroute | 0 | 46.55 | 0
Landing Weight | 1739.5 |  | 72.3112
Take-Off Center of Gravity | 41.57010635240011
Landing Center of Gravity | 41.57010635240011
Remaining Useful Load | 810.5
*The maximum allowable combined weight capacity for baggage in areas A and B is 120 pounds.
Enter Data in Gray shaded
Boxes Only
Spreadsheet: 3ef5822c-a60a-4cca-88ac-38d8a7f16869
Sheet: Sheet1

TOUR | [NAME] | CONTACT | PHONE NO. | LENGTH OF TOUR
OSU College of Engineering (CEAT) | Oklahoma State | Dr. [NAME] | [PHONE] | 1 hour
[NAME] Products | Oklahoma State | [NAME] | [PHONE] | 1 hour
Herbarium/OSU Vertebrates | Oklahoma State | [NAME] | [PHONE] | 1 hour
Heritage Hall Museum | Oklahoma State | [NAME] | [PHONE] | 1 hour
[NAME] Print Shop (airport) Please do not cancel without calling in advance. | [NAME] near airport | [NAME] | [PHONE] x320 | 1 hour
National Wrestling Hall of Fame | Oklahoma State | [NAME] | [PHONE] | 1 hour
Sheerar Museum of Stillwater History | 702 Duncan St. | [NAME] or [NAME] | [PHONE] | self tour
[NAME] | [NAME], OK | Christy Daugherty | [PHONE] | 1 hour
Kicker | 3100 [NAME] | [NAME] | [PHONE] | 1 hour
OSU Tours Gallagher Iba/Boone Pickens | Oklahoma State | [NAME] | [PHONE] | 1 hour
Armstrong World Industries | [NAME] | [NAME] | [PHONE] | 1 hour
[NAME]  [NAME], extra mansion tour, $1 students, $2 adults | Pawnee, OK | [NAME] | [PHONE] | 1 hour
Spreadsheet: bb0a2d1e-abbb-474b-a5d1-a84bde5db187
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
PECH | Test | PECH | Peach, IgE | Peach, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday, 9 a.m.-8 p.m., Saturday 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
PECH | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
PECH | Result | PECH | Peach, IgE | Peach, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6205-9
Spreadsheet: joe_parks__14898__TXULSP Avail Cap Elec Gen
Sheet: available capacity

 |  |  | Today's Date:
 | Lone Star Pipeline
Estimated Available Capacity on the TXU Lone Star Pipeline system
Gas Day runs from 9:00 a.m. to 9:00 a.m.
All volumes are expressed in [NAME]/d
The data below is TXU Lone Star Pipeline's best estimate of available capacity based on current operational data.  The available capacity listed
at the various [NAME])  is subject to the nomination process and the operational conditions existing at the time a nomination is confirmed.
The volumes listed below do not represent individual point capacity availability.   All transportation service will be performed subject to the terms
and conditions of your Transportation Agreement.
Please contact TXU Lone Star Pipeline's Transportation Administration Department before scheduling any imbalance makeup.  When
nominating imbalance makeup, please indicate what portion of your nomination is intended as imbalance makeup.  For more information, please
contact your TXU Lone Star Pipeline Transportation Administrator.
Please visit our web site at www.txulsp.com for nomination information and for a list of Major Interconnect Points on our system.
 | Receipt Area Capacity
 | Gas Day | Gas Day
 | 2002-03-25 00:00:00
From the Waha Area | 200000
East of Waha to | 50000
to the Maryneal Compressor
East of Maryneal Compressor | 50000
[NAME] | 100000
(Waller and Ft. Bend Counties)
Line V (30") | 50000
(Ennis to [NAME])
Lines L8A | 0
(Limestone and Freestone Cty)
Line P | 15000
([NAME] Area - for local consumption only)
[NAME] and O (East Texas) | 25000
 | * Carthage Plant OK for 25,000
Spreadsheet: 231719d1367204724-extract-entire-rows-from-list-based-on-criteria-example-1
Sheet: Sheet1

Extract entire rows where column A contains the word "SPX"
SPX | 0.52 | AB
SPX | 0.54 | CD
SGA | 1.23
SGA | 1.2
SPX | 0.62 | EF
DD | 5.2
[NAME] | 3.33
L | 21.2
Result | Result
SPX | 0.52 | AB
SPX | 0.54 | CD
SPX | 0.62 | EF
Spreadsheet: 47969d1247149261-conditional-formatting-borders-tomme
Sheet: New Employee

Name | Rate Per Hour | Contracted Hours
[NAME] | 6 | 39
[NAME] | 15 | 30
[NAME] | 5.5 | 30
Gemma | 0.01 | 30
[NAME] | 7 | 14
[NAME] | 12 | 13
[NAME] | 5 | 10
Millie | 5.5 | 40
Spreadsheet: 125089d1318873571-excel-2007-hlookup-returning-na-hlookup1
Sheet: Sheet2

Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
The red cells are the result I am looking for