tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 178830d1346934189-vlookup-table-master
Sheet: Sheet1

 | Select HOTEL
 | 1
 |  |  |  | CURRENT MODEL |  |  |  |  |  | PPHG PROPOSED |  |  |  |  |  |  | IMPACT |  |  |  |  |  |  | HOTEL 1
 | MEMBER SOURCE | RM | REV | FEE 1 |  | FEE 2 |  | FEE 3 |  | FEE 1 |  | FEE 2 |  | FEE 3 |  | STAY | [NAME] TO CURRENT |  |  |  |  |  |  | HOTEL 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOTEL 3
 | 1. SOURCE 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GHA FEE |  | PPHG FEE |  | PROGRAMME FEE
 | 2.  SOURCE 2
 | 3. SOURCE 3
 | 4.  SOURCE 4
 | GRAND TOTAL
 | HOTEL 1
 | MEMBER SOURCE | RM | REV | FEE 1 |  | FEE 2 |  | FEE 3 |  | FEE 1 |  | FEE 2 |  | FEE 3 |  | STAY | [NAME] TO CURRENT
 | 1. SOURCE 1 | 123434 | 8736487 | 0.025 |  | 0.01 |  | 0.035 |  | 5 |  | 0 |  | 5 |  | 5417.478260869565 | GHA FEE |  | PPHG FEE |  | PROGRAMME FEE
 | 2.  SOURCE 2 | 12344 | 8748745 | 0.025 |  | 0.01 |  | 0.035 |  | 0.015 |  | 0.01 |  | 0.025
 | 3. SOURCE 3 | 21323 | 45454 | 0.025 |  | 0.01 |  | 0.035 |  | 0.02 |  | 0.01 |  | 0.03
 | 4.  SOURCE 4 | 2323 | 45454 | 0.025 |  | 0.01 |  | 0.035 |  | 0.04 |  | 0.01 |  | 0.05
 | GRAND TOTAL
 | HOTEL 2
 | MEMBER SOURCE | RM | REV | FEE 1 |  | FEE 2 |  | FEE 3 |  | FEE 1 |  | FEE 2 |  | FEE 3 |  | STAY | [NAME] TO CURRENT
 | 1. SOURCE 1 | 65756765 | 343454 | 0.025 |  | 0.01 |  | 0.035 |  | 5 |  | 0 |  | 5 |  | 5417.478260869565 | GHA FEE |  | PPHG FEE |  | PROGRAMME FEE
 | 2.  SOURCE 2 | 454545 | 56565 | 0.025 |  | 0.01 |  | 0.035 |  | 0.015 |  | 0.01 |  | 0.025
 | 3. SOURCE 3 | 45454 | 3434 | 0.025 |  | 0.01 |  | 0.035 |  | 0.02 |  | 0.01 |  | 0.03
 | 4.  SOURCE 4 | 4545 | 5656 | 0.025 |  | 0.01 |  | 0.035 |  | 0.04 |  | 0.01 |  | 0.05
 | GRAND TOTAL
 | HOTEL 3
 | MEMBER SOURCE | RM | REV | FEE 1 |  | FEE 2 |  | FEE 3 |  | FEE 1 |  | FEE 2 |  | FEE 3 |  | STAY | [NAME] TO CURRENT
 | 1. SOURCE 1 | 56676454 | 23232 | 0.025 |  | 0.01 |  | 0.035 |  | 5 |  | 0 |  | 5 |  | 5417.478260869565 | GHA FEE |  | PPHG FEE |  | PROGRAMME FEE
 | 2.  SOURCE 2 | 342323 | 3433 | 0.025 |  | 0.01 |  | 0.035 |  | 0.015 |  | 0.01 |  | 0.025
 | 3. SOURCE 3 | 8787 | 656565 | 0.025 |  | 0.01 |  | 0.035 |  | 0.02 |  | 0.01 |  | 0.03
 | 4.  SOURCE 4 | 9898 | 232324 | 0.025 |  | 0.01 |  | 0.035 |  | 0.04 |  | 0.01 |  | 0.05
 | GRAND TOTAL
Spreadsheet: 104706d1302196406-consolidate-duplicate-rows-into-one-cell-test-success
Sheet: original

number | first | last | original price
100001 | [NAME] | [NAME] | 25
100001 | [NAME] | [NAME] | 50
100001 | [NAME] | [NAME] | 45
100002 | doug | michaels | 50
100003 | morgan | dames | 25
100004 | [NAME] | loss | 75
100005 | carol | reeves | 25
100006 | [NAME] | borne | 50
100007 | debra | minke | 15
100007 | debra | minke | 25
100007 | debra | minke | 150
100008 | vincent | [NAME] | 100
100008 | vincent | [NAME] | 100
100008 | vincent | [NAME] | 100
100008 | vincent | [NAME] | 100
Spreadsheet: rick_buy__32796__NP Daily Marks
Sheet: COB 091201

The New Power Company
Credit Exposure Summary
As of COB September 12, 2001
Enron Entity | Fin. MTM | Phy. MTM | Net Del. (1) | Net Exp.
Enron Energy Services, Inc. | 3162708 | 38794805 | 301295
Enron North America Corp. | 39107018 | 4743404 | 13419280
Enron Power Marketing, Inc. | 0 | 7225515
 |  |  | In Collateral (2) | -109300000
 |  |  | Treashold | -15000000
 |  |  | Total Exposure
(1) Net Del. For EPMI capacity payments have been adjusted to reflect EnPower's marks
(2) Per Master Netting Agreement Collateral in the amount of $109.3MM is applied across Enron Entities
Spreadsheet: 677476d1589371916-mobile-file-extractions-for-marketting-book2
Sheet: Sheet1

<span title="Ali, [NAME], Sm Habib Products, +[PHONE], +254 740 060786, +255 682 049 156, +255 683 411 786, +255 684 349 523, +255 686 020 797, +255 688 340 236, +255 688 786 987, +255 713 216 135, +255 713 620 831, +255 715 624 420, +255 717 800 012, +255 742 786 162, +255 742 862 105, +255 754 311 156, +255 754 489 064, +255 754 786 442, +255 783 328 801, +255 783 680 300, +255 784 760 000, +255 784 770 717, +255 784 786 308, +255 784 786 555, +255 784 881 041, +255 786 786 789, +255 787 045 046, +91 80996 95725, +91 88537 86666, +91 98480 36207, +91 98482 91525, You" class="O90ur _3FXB1">Ali, [NAME], Sm Habib Products, +[PHONE], +254 740 060786, +255 682 049 156, +255 683 411 786, +255 684 349 523, +255 686 020 797, +255 688 340 236, +255 688 786 987, +255 713 216 135, +255 713 620 831, +255 715 624 420, +255 717 800 012, +255 742 786 162, +255 742 862 105, +255 754 311 156, +255 754 489 064, +255 754 786 442, +255 783 328 801, +255 783 680 300, +255 784 760 000, +255 784 770 717, +255 784 786 308, +255 784 786 555, +255 784 881 041, +255 786 786 789, +255 787 045 046, +91 80996 95725, +91 88537 86666, +91 98480 36207, +91 98482 91525, You</span>
Spreadsheet: 842768d1694762463-sum-up-columns-based-on-specific-dates-amoi42-aligw
Sheet: Sheet1

Equipment Code | WO Number | WO Description | WO Priority | WO Status | Odometer | Start Date | Finish date | Total Downtime |  |  | Start Date | Finish Date | Highest Dowtime | WO Description | Expected result
VL1 |  | SAFETY INSPECTION | P3 | Not Shown |  | 2022-04-11 00:00:00 | 2022-04-11 00:00:00 | 0 |  | VL1 | 2022-04-12 00:00:00 | 2022-04-18 00:00:00 | 1 |  | DOOR REPLACE
VL1 |  | DOOR REPLACE | P3 | Completed | 72294 | 2022-04-12 07:30:00 | 2022-04-12 08:30:00 | 0.9999999999417923 |  |  | 2022-05-09 00:00:00 | 2022-05-23 00:00:00 | 3 |  | AC REPAIRS
VL1 |  | HEADLIGHT (BULB) REPLACED | P1 | Completed | 72477 | 2022-04-18 07:20:00 | 2022-04-18 07:50:00 | 0.5000000000582077 |  |  | 2023-01-01 00:00:00 | 2023-09-12 00:00:00 | 6120 |  | ACCIDENT DAMAGE
VL1 |  | SAFETY INSPECTION | P3 | Completed | 72790 | 2022-04-26 07:45:00 | 2022-04-26 09:45:00 | 2
VL1 |  | SAFETY INSPECTION | P3 | Completed | 73223 | 2022-05-09 08:01:00 | 2022-05-09 09:01:00 | 1.000000000116415 |  |  |  |  |  | Results in cell O4 and O5 are not correct.
VL1 |  | AC REPAIRS | P3 | Completed | 73641 | 2022-05-23 13:35:29 | 2022-05-23 16:35:54 | 3
VL1 |  | ACCIDENT DAMAGE | P1 | Waiting Parts |  | 2023-06-05 10:00:00 |  | 10708.77714444447 |  |  | [NAME] used | INDEX($C$2:$C$8, MATCH(MAXIFS($I$2:$I$8,$G$2:$G$8,">=" &L2,$H$2:$H$8,"<=" &M2,$A$2:$A$8,$K$2),$I$2:$I$8, 0))
Spreadsheet: 466339d1466128278-if-and-large-query-if-and-large-query
Sheet: Sheet1

Number | % | Category | Large 1 | Large 2 | Results
4 | 0.34 | 84.49999999999999 |  |  | 4
2 | 0.2741935483870968 | 77.74 |  |  | 2
3 | 0.06 | 24.32 |  |  | 1
1 | 0.1024096385542169 | 62.52999999999999 |  |  | 7
7 | 0.07391304347826087 | 69.28999999999999
5 | 0.0648854961832061 | 56.61499999999999
6 | 0.02048192771084337 | 56.61499999999999
8 | 0.02004716981132075 | 54.925
9 | 0.0005188146610919523 | 54.925
10 | 0.0005188146610919523 | 53.23499999999999
Spreadsheet: 0ed960a0-b3ca-49aa-8a5f-4fc2c078f738
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6273 | 5555 | Yekaterina | Shatnaya | KAZ | 0 | 00:19:31 | 00:02:16 | 01:12:37 | 00:00:48 | 00:38:34 | 1 | 02:13:46
6273 | 27368 | Ekaterina | Akimova | RUS | 0 | [NAME] | 00:02:24 | 01:12:23 | 00:00:46 | 00:44:12 | 2 | 02:18:20
6273 | 41587 | [NAME] | Uayisova | KAZ | 0 | 00:19:44 | 00:02:29 | 01:19:55 | 00:00:41 | 00:44:39 | 3 | 02:27:29
6273 | 41842 | Karolina | Solovyova | KAZ | 0 | [NAME] | 00:02:15 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 871072d1717510896-how-to-extract-data-from-sheet-if-row-is-marked-for-extraction-extract_data
Sheet: Sheet with formula

 | Should result in:
 | A | 68.9 | a
 |  |  |  | 5263.36 | 0.09 | 31.55 | 0.23 | x
 |  |  |  | 5320.12 | 0.14 | 68.15 | 0.23 | x
 | B | 159200 | a
 |  |  |  | 4457 | 2 | 0.0028 |  | x
Spreadsheet: 482657d1475169466-workbook-sheet-linking-issues-index-example-tms
Sheet: B2 to B20

 |  | =INDEX('Job Work Sheet'!$B$1:$B$20, ROW())
Spreadsheet: 705726d1606284305-conditional-formatting-of-cells-of-data-block-based-on-cell-value-in-data-block-condform
Sheet: Target

 | 2020
 | Condition 1 | Value |  | Uncert | Unit
 | Number | 0
 | Reference | 43101
 | N1 | 313000 | ± | 0 | g
 | N2 | 1.9652 | ± | 0 | g
 | N3 | 94.8872 | ± | 0 | g
 | N4 | 94.8872 | ± | 0 | g
 | N5 | 94.8872 | ± | 0 | g
 | [NAME] | 94.8872 | ± | 0 | g
 | N7 | 94.8872 | ± | 0 | g
 | 2020
 | Condition 2 | Value |  | Uncert | Unit
 | Number | 0
 | Reference | 43101
 | N1 | 313000 | ± | 0 | g
 | N2 | 1.9652 | ± | 0 | g
 | N3 | 94.8872 | ± | 0 | g
 | N4 | 94.8872 | ± | 0 | g
 | N5 | 94.8872 | ± | 0 | g
 | [NAME] | 94.8872 | ± | 0 | g
 | N7 | 94.8872 | ± | 0 | g
 | 2019
 | Condition 1 | Value |  | Uncert | Unit
 | Number | 0
 | Reference | 43101
 | N1 | 313000 | ± | 0 | g
 | N2 | 1.9652 | ± | 0 | g
 | N3 | 94.8872 | ± | 0 | g
 | N4 | 94.8872 | ± | 0 | g
 | N5 | 94.8872 | ± | 0 | g
 | [NAME] | 94.8872 | ± | 0 | g
 | N7 | 94.8872 | ± | 0 | g
Spreadsheet: 830169d1684760284-need-formula-that-sums-2-tables-based-on-date-xlookup-2-tables-sums
Sheet: Sheet1

 |  |  |  | Month | Tx | Amount |  | Month | Tx | Amount |  | Month | Total | Answers
 |  |  |  | Jan | xuau | 505 |  | Jan | asnm | 901 |  | Jan
 |  |  |  | Feb | asdi | 401 |  | Feb | sijuw | 511 |  | Feb
 |  |  |  | Mar | sauw | 607 |  | Mar | ijsua | 17 |  | Mar
 |  |  |  | Apr | [NAME] | 112 |  | Apr | wujg | 182 |  | Apr
 |  |  |  | May | iuuw | 551 |  | May | dbgs | 254 |  | May
 |  |  |  | Jun | isjij | 124 |  | Jun | jusuh | 689 |  | Jun
 |  |  |  | Jul | qjkiw | 512 |  | Jul | [NAME] | 385 |  | Jul
 |  |  |  | Aug | [NAME] | 534 |  | Aug | sjnnj | 905 |  | Aug
 |  |  |  | Sep | smikn | 212 |  | Sep | ijsuj | 391 |  | Sep
 |  |  |  | Oct | nsknj | 908 |  | Oct | uhjwuh | 837 |  | Oct
 |  |  |  | Nov | [NAME] | 362 |  | Nov | iqji | 276 |  | Nov
 |  |  |  | Dec | whuhq | 819 |  | Dec | wiuhy | 398 |  | Dec
Spreadsheet: jeffrey_a_shankman__13918__Pick Sheet - Week 17
Sheet: Week 3

NFL PICKS OF THE WEEK - 2001
Name:
Phone Number where we can reach you on Sunday morning:
Last Person Standing Team Pick:
SEND TO:   E-mail - [EMAIL] |  |  |  | Phone - (707) 255-4813 |  |  | Fax - (707) 255-4832
WEEK 3  - First Game is Sunday @ 10 a.m.
Sunday, September 23
 |  | Visitor |  |  |  | Home
 |  | Carolina Panthers |  |  |  | Atlanta Falcons
 |  | Minnesota Vikings |  |  |  | Chicago Bears
 |  | Baltimore Ravens |  |  |  | Cincinnati Bengals
 |  | Detroit Lions |  |  |  | [NAME]
 |  | San Diego Chargers |  |  |  | Dallas Cowboys
 |  | Buffalo Bills |  |  |  | Indianapolis Colts
 |  | New York Giants |  |  |  | Kansas City Chiefs
 |  | Oakland Raiders |  |  |  | [NAME]
 |  | Tennessee Titans |  |  |  | [NAME]
 |  | New York Jets |  |  |  | New England Patriots
 |  | St. Louis Rams |  |  |  | San Francisco 49er's
 |  | Philadelphia Eagles |  |  |  | [NAME]
 |  | Denver Broncos |  |  |  | Arizona Cardinals
Monday, September 24
 |  | Washington Redskins |  |  |  | Green Bay Packers
Tiebreaker |  |  |  | Total |  |  | Total should = 119
Entries must be received by the beginning of the first game of the week (earlier is perfectly ok!)
Always start by giving the team that you think is most likely to win 15 points and go down from there.
If there are only 14 games in a week, your lowest pick will be "2" instead of "1"
Bye Week: | New Orleans Saints
 | Pittsburgh Steelers
 | Tampa Bay Buccaneers
Spreadsheet: 134753d1325613988-dependent-drop-down-selections-on-different-sheets-within-the-same-workbook-copy-of-sample-worksheet
Sheet: DO NOT USE

 | Region |  | Name |  | RenewalStatus |  | FundingType |  | National | Regional East |  | Regional West
 | <Select> |  |  |  |  |  |  |  | <Select> | Alabama |  | Arizona
 | National |  |  |  |  |  |  |  | Alabama | Connecticut (North) |  | California
 | Regional East |  |  |  |  |  |  |  | Arizona | Connecticut (South) |  | Nevada
 | Regional West |  |  |  |  |  |  |  | Arkansas | Florida |  | Washington
 |  |  |  |  |  |  |  |  | California | Georgia |  | Oregon
 |  |  |  |  |  |  |  |  | Colorado | Maine |  | Kentucky
 |  |  |  |  |  |  |  |  | Connecticut | Maryland |  | Kansas
 |  |  |  |  |  |  |  |  | Delaware | Massachusetts |  | Missouri
 |  |  |  |  |  |  |  |  | Florida | Mississippi |  | Nebraska
 |  |  |  |  |  |  |  |  | Georgia | New Hampshire |  | Tennessee
 |  |  |  |  |  |  |  |  | Hawaii | New Jersey |  | Taft-Hartley
 |  |  |  |  |  |  |  |  | Idaho | New York |  | Indiana
 |  |  |  |  |  |  |  |  | Illinois | North Carolina |  | Illinois
 |  |  |  |  |  |  |  |  | Indiana | Rhode Island |  | Iowa
 |  |  |  |  |  |  |  |  | Iowa | South Carolina |  | Michigan
 |  |  |  |  |  |  |  |  | Kansas | Vermont |  | Minnesota
 |  |  |  |  |  |  |  |  | Kentucky | Virginia |  | Ohio
 |  |  |  |  |  |  |  |  | Louisiana | Washington D.C. |  | Wisconsin
 |  |  |  |  |  |  |  |  | Maine |  |  | West Virginia
 |  |  |  |  |  |  |  |  | Maryland |  |  | Pennsylvania
 |  |  |  |  |  |  |  |  | Massachusetts |  |  | Texas
 |  |  |  |  |  |  |  |  | Michigan |  |  | Oklahoma
 |  |  |  |  |  |  |  |  | Minnesota |  |  | Louisiana
 |  |  |  |  |  |  |  |  | Mississippi |  |  | New Mexico
 |  |  |  |  |  |  |  |  | Missouri |  |  | Colorado
 |  |  |  |  |  |  |  |  | Montana |  |  | Utah
 |  |  |  |  |  |  |  |  | Nebraska
 |  |  |  |  |  |  |  |  | Nevada
 |  |  |  |  |  |  |  |  | New Hampshire
 |  |  |  |  |  |  |  |  | New Jersey
 |  |  |  |  |  |  |  |  | New Mexico
 |  |  |  |  |  |  |  |  | New York
 |  |  |  |  |  |  |  |  | North Carolina
 |  |  |  |  |  |  |  |  | North Dakota
 |  |  |  |  |  |  |  |  | Ohio
 |  |  |  |  |  |  |  |  | Oklahoma
 |  |  |  |  |  |  |  |  | Oregon
 |  |  |  |  |  |  |  |  | Pennsylvania
 |  |  |  |  |  |  |  |  | Rhode Island
 |  |  |  |  |  |  |  |  | South Carolina
 |  |  |  |  |  |  |  |  | South Dakota
 |  |  |  |  |  |  |  |  | Taft-Hartley
 |  |  |  |  |  |  |  |  | Tennessee
 |  |  |  |  |  |  |  |  | Texas
 |  |  |  |  |  |  |  |  | TPA/Emerging Markets
 |  |  |  |  |  |  |  |  | Utah
 |  |  |  |  |  |  |  |  | Vermont
 |  |  |  |  |  |  |  |  | Virginia
 |  |  |  |  |  |  |  |  | Washington
 |  |  |  |  |  |  |  |  | Washington D.C.
 |  |  |  |  |  |  |  |  | West Virginia
 |  |  |  |  |  |  |  |  | Wisconsin
 |  |  |  |  |  |  |  |  | Wyoming
Spreadsheet: 430268d1447445996-trying-to-combined-data-from-separate-sheets-combine-worksheets-into-master-worksheet
Sheet: Vendor 1

0 | Item Number | Distributor | Description | UM | Size | Case Qty | Cost/ea | Cost/UM | Cost/Case | Type | Use | Frequency | Not Applicable
 | 101 | v1 | Cleaner 8 oz Can | can | 8 | 12 |  |  | 200 | [NAME] | Expendable | 2
 | 102 | v1 | Nitrile Glove | box | 100 | 10 |  |  | 50 | Glove | Expendable | 1
 | 103 | v1 | Paper 800ft | roll | 800 | 4 |  |  | 40 | Towel | Expendable | 3
 | 104 | v1 | 55 gallon thick | roll | 25 | 10 |  |  | 35 | [NAME] | Expendable | 1
 | 105 | v1 | Lobby broom plastic | ea | 1 | 1 |  |  | 5 | Broom | Non-Expendable | 0
Spreadsheet: 695456d1600226046-index-match-for-dynamically-change-in-date-rows-based-on-each-month-template-with-formula
Sheet: 2018 07

Member Work hours Summary by Project - July 2018 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CGI
From: | 2018-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer: | 119000330 - Munich Re America Services Inc.
To: | 2018-07-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project: | 300000000003702 - Enterprise Data Strategy
Member [NAME] | Type |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Hrs | Non-bill | Total
Riley,[NAME] | Billable |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8
Total Hours:
 | Regular Hours:
 | OT Hours:
Approver Signature |  | Date
Week Ending | Saturday
Spreadsheet: 76584d1277139129-excel-2003-formula-to-find-in-pivot-and-rate-with-number-rank
Sheet: Sheet1

 | Turnover -- Hiring Source
Current Region | (All)
 |  | Status
Source | Data | Active | Terminated-Inv | Terminated-Inv RIF | Terminated-Vol | Transfer-Int | Grand Total
College-AS Tgt | Count of Source | 0 | 0 | 0 | 0.008771929824561403 | 0 | 0.008771929824561403
 | Count of Source2 |  |  |  | 1 |  | 1
College-Corp Tgt | Count of Source | 0.008771929824561403 | 0.008771929824561403 | 0.04385964912280702 | 0.03508771929824561 | 0 | 0.09649122807017543
 | Count of Source2 | 1 | 1 | 5 | 4 |  | 11
College-Non Tgt | Count of Source | 0.04385964912280702 | 0.008771929824561403 | 0.008771929824561403 | 0.008771929824561403 | 0.008771929824561403 | 0.07894736842105263
 | Count of Source2 | 5 | 1 | 1 | 1 | 1 | 9
External Liberty Website | Count of Source | 0.1228070175438596 | 0.05263157894736842 | 0.07894736842105263 | 0.1491228070175439 | 0 | 0.4035087719298245
 | Count of Source2 | 14 | 6 | 9 | 17 |  | 46
Intern Conversion | Count of Source | 0.01754385964912281 | 0 | 0 | 0.01754385964912281 | 0 | 0.03508771929824561
 | Count of Source2 | 2 |  |  | 2 |  | 4
Internal | Count of Source | 0.07894736842105263 | 0 | 0.01754385964912281 | 0.05263157894736842 | 0 | 0.1491228070175439
 | Count of Source2 | 9 |  | 2 | 6 |  | 17
Referral | Count of Source | 0.1140350877192982 | 0.008771929824561403 | 0.02631578947368421 | 0.03508771929824561 | 0 | 0.1842105263157895
 | Count of Source2 | 13 | 1 | 3 | 4 |  | 21
Rehire | Count of Source | 0.03508771929824561 | 0 | 0.008771929824561403 | 0 | 0 | 0.04385964912280702
 | Count of Source2 | 4 |  | 1 |  |  | 5
Total Count of Source |  | 0.4210526315789473 | 0.07894736842105263 | 0.1842105263157895 | 0.3070175438596491 | 0.008771929824561403 | 1
Total Count of Source2 |  | 48 | 9 | 21 | 35 | 1 | 114
Spreadsheet: 266275d1379567365-federal-tax-withholding-formula-slightly-off-calc
Sheet: 9_20_13

PAY CYCLE |  | THRU
Paycheck Date
[NAME] | 13
OT Rate | 20.48
Regular Hours
Overtime
Holiday Hours Worked
Shift Differential | X
Gross Pay
Pre-Tax Deductions
FRS REG CLASS
MED FLEX 2013 | 60
P/T DENT-S | 6.19
P/T HEALTH-S | 26.78
P/T VISION SINGLE | 3
FEDERAL WITHOLDING TAX
SOCIAL SECURITY TAX
MEDICARE
TOTAL WITHHOLDINGS
NET PAY
Percentage Taxed
Spreadsheet: mike_grigsby__27851__Phillip_Email_New2
Sheet: Sheet1

West Desk P&L Summary
 | Today is: |  | Today | Yesterday | MTD | YTD
 | MGMT-WEST | [NAME] |  | 67438.64610000022
 | FT-PGE |  |  | -421690.7939999996
 | WC-CAL | [NAME] |  | -492969.0615399224
 | WC-PERM | Sanchez |  | 0
 | WT-SOCAL | Holst |  | -58068.69609999777
 | WT-CAL | Ermis |  | 403206.4446000457
 | Denver | Reitmeyer |  | 606781.5309999995
 | FT-REGS | Tholt |  | 116190.1765000002
 | WC-ROX | South |  | 65715.16779999992
 | WT-ROX | Lenhart |  | 34555.51300000012
 | WC-SJ | Gay |  | -37317.01309998159
 | WT-SJ | Kuykendahl |  | -100365.8747999999
 | WC-SOCAL | [NAME] |  | 78819.49040000001
 | WC-NOCAL | Wolfe |  | -30949
 |  | Total: |  | 231346.5298601444
Spreadsheet: drew_fossum__8687__Fixed3_113000
Sheet: ENA_13

[NAME]
FUEL HEDGING BOOK
Enron North America_13
Prod. | Contract | Contract | Fixed |  | Fuel | Settled | futures_113000 | (Gains) and Losses
Date | Number | Name | Price |  | Dth | Price | Price | Total | Realized | Unrealized
 |  |  |  |  |  | El Paso Prmn |  | (4) | (4) | (4)
2001-01-01 00:00:00 |  | ENA | 3.585
2001-02-01 00:00:00 |  | ENA | 3.585
2001-03-01 00:00:00 |  | ENA | 3.585
2001-04-01 00:00:00 |  | ENA | 3.585
2001-05-01 00:00:00 |  | ENA | 3.585
2001-06-01 00:00:00 |  | ENA | 3.585
2001-07-01 00:00:00 |  | ENA | 3.585
2001-08-01 00:00:00 |  | ENA | 3.585
2001-09-01 00:00:00 |  | ENA | 3.585
2001-10-01 00:00:00 |  | ENA | 3.585
2001-11-01 00:00:00 |  | ENA | 3.585
2001-12-01 00:00:00 |  | ENA | 3.585
 |  |  |  |  |  | El Paso Prmn
2001-01-01 00:00:00 |  | Over-retention | 3.585
2001-02-01 00:00:00 |  | Over-retention | 3.585
2001-03-01 00:00:00 |  | Over-retention | 3.585
2001-04-01 00:00:00 |  | Over-retention | 3.585
2001-05-01 00:00:00 |  | Over-retention | 3.585
2001-06-01 00:00:00 |  | Over-retention | 3.585
2001-07-01 00:00:00 |  | Over-retention | 3.585
2001-08-01 00:00:00 |  | Over-retention | 3.585
2001-09-01 00:00:00 |  | Over-retention | 3.585
2001-10-01 00:00:00 |  | Over-retention | 3.585
2001-11-01 00:00:00 |  | Over-retention | 3.585
2001-12-01 00:00:00 |  | Over-retention | 3.585
(4)Gain and [NAME] are a measurement of the effectiveness of meeting the stated hedge objective.
Spreadsheet: 818418d1676818693-or-function-in-table-format-doesnt-work-example-35-ans2
Sheet: Sheet1

 | (Worked) Scenario1: Indicator =1
 |  |  |  |  |  | Expected: |  |  |  | [NAME]:
 |  | Transit | GL | Indicator |  | Transit | GL | Indicator |  | Transit | GL | Indicator
 |  | 11111 | 123456
 |  | 22222 | 2222214
 |  | 33333 | 12123123 | 1 |  | 33333 | 12123123 | 1 |  | 33333 | 12123123 | 1
 | (Doesn't Worked) Scenario2: Indicator =1 or Indicator [NAME]
 |  |  |  |  |  | Expected: |  |  |  | [NAME]:
 |  | Transit | GL | Indicator |  | Transit | GL | Indicator |  | Transit | GL | Indicator
 |  | 11111 | 123456 | -1 |  | 11111 | 123456 | -1 |  |  | 123456 | -1
 |  | 22222 | 2222214
 |  | 33333 | 12123123 | 1 |  | 33333 | 12123123 | 1 |  | 33333 | 12123123 | 1
Spreadsheet: 841304d1693493579-match-date-on-two-different-pages-and-paste-data-in-columns-ef-file
Sheet: 1-22 Night

 | CR1 | Priority | Headcount
1 | Alinity RV | 17 | 0.25
2 | Alinity RV | 16 | 0.25
3 | Alinity RV | 15 | 0.25
4 | Alinity RV | 14 | 0.25
5 | Alinity RV | 13 | 0.25
12 | [NAME] | 20 | 0.25
13 | [NAME] | 21 | 0.25
9 | Architect RV | 12 | 0.25
15 | Architect SC | 18 | 0.25
16 | Architect RV | 11 | 0.25
17 | Alinity RV | 19 | 0.25
50 | Baxter SIV Assy | 22 | 2
31 | Architect RV | 10 | 0.25
8 | Alinity RV | 9 | 0.25
10 | Architect RV | 8 | 0.25
11 | [NAME] | 24 | 0.25 |  |  | sat | 15 | day
18 | Architect RV | 7 | 0.25 |  |  | [NAME] | 15 | day
19 | Architect RV | 6 | 0.25 |  |  | fri | 14
20 | Siemens | 23 | 3 |  |  | sat | 10
21 | Architect RV | 5 | 0.25 |  |  | [NAME] | 13
22 | Architect RV | 4 | 0.25
23 | Architect RV | 3 | 0.25
30 | Architect RV | 2 | 0.25
7 | Architect SC | 1 | 0.25
Total
 | CR2 | Priority
73 | PP1 | 5 | 0.25
74 | 6ul | 4 | 0.25
77 | PCR Tube | 3 | 0.25
78 | Side Cassette A mold | 2 | 0.25
79 | [NAME] | 1 | 0.25
87 | [NAME] | 6 | 0.25
52 | Architect RV | 10 | 0.25
53 | Architect RV | 11 | 0.25
61 | [NAME] | 15 | 0.25
66 | [NAME] | 16 | 0.5
83 | Ceph OM#1
84 | Ceph MB#1 | 8 | 0.25
86 | [NAME] | 9 | 0.25
62 | NP227 | 12 | 0.25
63 | NP Birdcage | 13 | 0.25
64 | Siemens 1ML | 14 | 0.25
67 | [NAME] | 17 | 0.25
69
88 | [NAME] | 7 | 0.25
89 | Top Frame B mold
106
107
108
109
Total
Spreadsheet: 63773d1264632816-vlookup-task-total
Sheet: Sheet1

 | Week1 | Week2 | Week3 | Week4 | Total
Task1 |  |  |  |  | 1900-01-01 00:00:00
[NAME] |  |  |  |  | 1900-01-01 00:00:00
Task3 |  |  |  |  | 1900-01-01 00:00:00
Task4 |  |  |  |  | 1900-01-01 00:00:00
Task5 |  |  |  |  | 1900-01-01 00:00:00
Task6 |  |  |  |  | 1900-01-01 00:00:00
Task7 |  |  |  |  | 1900-01-01 00:00:00
Task8 |  |  |  |  | 1900-01-01 00:00:00
Total | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Spreadsheet: 140886d1328923648-large-database-yfeb-food-total-values
Sheet: 2-2-12

 | Breakfast | Quantity | Measure | Food Item | Cost | Daily Points
 |  | 1 | cup | cheerios
 | Daily Total | 0.75 | cup | milk
 | Lunch | Quantity | Measure | Food Item | Cost | Daily Points
 |  | 1 | slice | [NAME]
 |  | 1 | slice | ham
 |  | 2 | slice | carrot
 |  | 15 | gram | brie
 |  | 5 | pieces | Ak Mak Crackers | 0 | 1.5
 | Dinner | Quantity | Measure | Food Items | Cost | Daily Points
 |  | 86 | gram | [NAME] | 0.71 | 5
 |  |  |  | beef broth | 0 | 0
 |  |  |  | french beans | 0 | 0
 |  | 2 | slices | Multi Grain Bread | 0 | 6
 |  | 10 | gram | [NAME]
 |  | 0.13 |  | Celery Root | 0.5 | 0
Spreadsheet: 80401d1280596089-matching-two-columns-and-returning-third-value-example
Sheet: Sheet2

Hi All, I need your help In the table below, I want populate column Incidents (3rd colum) after matching SID. For example, for SID ABC, the 3rd column incident should be populated by 23.
SID | USERS | Incidents | SID | Incidents
ABC | 150 |  | DEF | 1
DEF | 200 |  | KNM | 11
GHI | 400 |  | LMJ | 123
LMJ | 59 |  | GHI | 34
KNM | 25 |  | ABC | 23