tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 133940d1324849403-extract-by-desending-order-copy_123-tvbn
Sheet: Database

LOT DETAILS
S | Date | Month | Year | Bname | [NAME] | [NAME] | Lot No | Shift | Code | Moisture | Protein | [NAME] | TVBN | TVBN Rounded | Bag No FROM | Bag No TO | Total       Bags | Issued | Remaining Bags | Fish Item | Status
1 | 2011-10-30 00:00:00 |  |  | S | 5 |  | 117 | Gopal |  | 5.66 | 63.55 |  | 117.88 |  | 5601 | 6000 |  |  |  | Sardin
 | 2011-11-11 00:00:00 |  |  | S | 6 |  | 136 | Gopal |  | 6.55 | 62.75 |  | 124.71 |  | 3201 | 3600 |  |  |  | Chalt
 | 2011-11-13 00:00:00 |  |  | S | 6 |  | 139 | Gopal |  | 6.36 | 63.41 |  | 118.53 |  | 4401 | 4800 |  |  |  | Head
 | 2011-11-13 00:00:00 |  |  | S | 6 |  | 140 | Praveen |  | 6.95 | 64.19 |  | 130.77 |  | 4801 | 5200 |  |  |  | Mix
 | 2011-11-14 00:00:00 |  |  | S | 6 |  | 142 | Praveen |  | 6.75 | 63.92 |  | 144.02 |  | 5601 | 6000 |  |  |  | Sardin
 | 2011-11-15 00:00:00 |  |  | S | 7 |  | 144 | Praveen |  | 6.27 | 64.57 |  | 140.86 |  | 6401 | 6800 |  |  |  | Sardin
 | 2011-11-16 00:00:00 |  |  | S | 7 |  | 145 | Gopal |  | 6.64 | 65.37 |  | 163.67 |  | 6801 | 7200 |  |  |  | Mix
 | 2011-11-16 00:00:00 |  |  | S | 7 |  | 146 | Praveen |  | 6.66 | 62.95 |  | 148.92 |  | 7201 | 7600 |  |  |  | Mix
 | 2011-11-17 00:00:00 |  |  | S | 7 |  | 147 | Gopal |  | 7.17 | 64.57 |  | 153.89 |  | 7601 | 8000 |  |  |  | Mix
 | 2011-11-18 00:00:00 |  |  | S | 7 |  | 150 | Praveen |  | 6.2 | 65.3 |  | 158.84 |  | 8801 | 9200 |  |  |  | Mix
 | 2011-11-19 00:00:00 |  |  | S | 7 |  | 151 | Gopal |  | 6.03 | 66.3 |  | 178.32 |  | 9201 | 9600 |  |  |  | Mix
 | 2011-11-21 00:00:00 |  |  | S | 7 |  | 154 | Gopal |  | 6.63 | 65.29 |  | 166.94 |  | 401 | 800 |  |  |  | Mix
 | 2011-11-21 00:00:00 |  |  | S | 7 |  | 155 | Praveen |  | 7 | 63.69 |  | 153.94 |  | 801 | 1200 |  |  |  | Mix
 |  |  |  |  |  |  |  |  | Gopal | A01
 |  |  |  |  |  |  |  |  | Praveen | B01
Spreadsheet: 51164d1250707047-two-conditions-and-one-result-book2
Sheet: Sheet1

Date | Criteria | Amount
2009-12-01 00:00:00 | F | 2200 |  | Sumif function "FR" for one criteria | 24000
2009-12-02 00:00:00 | FR | 2400 |  | Sumif function for a date range | 27000
2009-12-03 00:00:00 | FR | 2600 |  | Sumif function for combination of Criteria and Date | 24000
2009-12-04 00:00:00 | FR | 2800 |  |  | 24000
2009-12-05 00:00:00 | FR | 3000
2009-12-06 00:00:00 | FR | 3200
2009-12-07 00:00:00 | F | 3400
2009-12-08 00:00:00 | F | 3600
2009-12-09 00:00:00 | F | 3800
2009-12-10 00:00:00 | F | 4000
2009-12-11 00:00:00 | O | 4200
2009-12-12 00:00:00 | O | 4400
2009-12-13 00:00:00 | O | 4600
2009-12-14 00:00:00 | FR | 4800
2009-12-15 00:00:00 | O | 5000
2009-12-16 00:00:00 | FR | 5200
2009-12-17 00:00:00 | O | 5400
Spreadsheet: 864525d1711653229-count-instances-or-frequency-multiple-sheets-counting-position-appearances-in-baseball-excel-help-forum-roster-template-2024-03-22-mattg-
Sheet: Game 2

Date: |  | 2024-05-01 00:00:00 |  |  | Field: |  |  | Start Time: |  | 18:00:00
Home: |  |  |  |  | 3rd | Set Up
Visitors: |  |  |  |  | 1st | Clean Up
 |  |  |  |  | Inning
 |  | Player |  |  | Coach Pitch |  |  |  |  |  | Innings on Bench | Innings in Infield | Inninings in Outfield |  |  |  | [NAME]
Order | Column1 | First | Last | # | 1 | 2 | 3 | 4 | 5 | 6
1 | 12 | [NAME] |  |  | 1B (3) | 1B (3) | 1B (3) | LF (7) | LF (7) | LF (7) |  |  |  |  | P (1)
2 | 11 | Ty |  |  | 2B (4) | 2B (4) | 2B (4) | RF (9) | RF (9) | RF (9) |  |  |  |  | C (2)
3 | 1 | [NAME] |  |  | 3B (5) | 3B (5) | 3B (5) | LCF () | LCF () | LCF () |  |  |  |  | 1B (3)
4 | 2 | [NAME] |  |  | LF (7) | LF (7) | LF (7) | 1B (3) | 1B (3) | 1B (3) |  |  |  |  | 2B (4)
5 | 4 | [NAME] |  |  | P (1) | P (1) | P (1) | [NAME] () | [NAME] () | [NAME] () |  |  |  |  | 3B (5)
6 | 5 | Willie |  |  | X | RF (9) | RF (9) | 3B (5) | 3B (5) | 3B (5) |  |  |  |  | SS (6)
7 | 10 | [NAME] |  |  | RF (9) | X | SS (6) | SS (6) | C (2) | C (2) |  |  |  |  | LF (7)
8 | 9 | [NAME] |  |  | SS (6) | SS (6) | X | 2B (4) | 2B (4) | 2B (4) |  |  |  |  | CF (8)
9 | 6 | Babe |  |  | LCF () | LCF () | LCF () | X | SS (6) | SS (6) |  |  |  |  | RF (9)
10 | 7 | [NAME] |  |  | C (2) | C (2) | [NAME] () | P (1) | X | P (1) |  |  |  |  | SF (10)
11 | 8 | [NAME] |  |  | [NAME] () | [NAME] () | C (2) | C (2) | P (1) | X |  |  |  |  | EH ()
12 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | LCF ()
13 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ()
Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roster pulled from list on roster tab
 | 9
 | 9
Notes:
 |  |  |  | Players on [NAME]
 |  | Only pull a players first name from the drop down
Spreadsheet: 814306d1674269311-look-up-same-requirements-output-different-results-automation-test-gk2
Sheet: Schedule

Date | Day | Helper 1 | Helper 2 | Helper 3 | D22550
2022-06-12 00:00:00 | Sunday
2022-06-13 00:00:00 | Monday
2022-06-14 00:00:00 | Tuesday
2022-06-15 00:00:00 | Wednesday
2022-06-16 00:00:00 | Thursday
2022-06-17 00:00:00 | Friday
2022-06-18 00:00:00 | Saturday
2022-06-19 00:00:00 | Sunday
2022-06-20 00:00:00 | Monday
2022-06-21 00:00:00 | Tuesday
2022-06-22 00:00:00 | Wednesday
2022-06-23 00:00:00 | Thursday
2022-06-24 00:00:00 | Friday
2022-06-25 00:00:00 | Saturday
2022-06-26 00:00:00 | Sunday
2022-06-27 00:00:00 | Monday
2022-06-28 00:00:00 | Tuesday
2022-06-29 00:00:00 | Wednesday
2022-06-30 00:00:00 | Thursday
2022-07-01 00:00:00 | Friday
2022-07-02 00:00:00 | Saturday
Spreadsheet: 713243d1610617459-certain-words-in-a-cell-determine-which-column-is-meant-example
Sheet: Sheet1

 | Price | TP | SL |  | Shares | Exit | PnL
 | 17 | 19 | 16 |  | 5 | TP
 | 8 | 9 | 7 |  | 10 | SL
 | 135 | 175 | 120 |  | 2 | TP
 |  |  |  |  |  |  | Depending on the letters in column G, I want them to consider either column D or C. And than I want that number subtracted by the number in column A (same row) and than multiplied by the number in column F.
 |  |  |  |  |  |  | In other words, I just want to type either "TP" or "SL" into the cells in column G and I want the result in column H as the example in row 2
Spreadsheet: 859259d1707721399-rank-and-count-values-in-a-range-from-the-same-range-across-multiple-sheets-rank-and-count-dj
Sheet: 8

Rep
Cooper
Willow
Mark4
Piper
[NAME]
Luna
[NAME]
Carmen3
Xavier
Ivy
Roman
Esme
Tom5
Bob2
Felix
[NAME]
Jasper
Abigail1
Sawyer
Serenity
Spreadsheet: 542854d1508147209-i-want-to-get-the-highest-value-of-the-particular-product-sold-in-the-master-clarification
Sheet: MASTER INVENTORY

CATEGORY | VLOOKUP | BRAND | ITEM | UNITS | PUR.PRICE
Dal | [NAME] | Amman | T.Dal | 1kg | 73
Dal | AmmanT.Dal500gm | Amman | T.Dal | 500gm
Dal | AmmanT.Dal250gm | Amman | T.Dal | 250gm
Dal | AmmanT.Dal100gm | Amman | T.Dal | 100gm
Dal | [NAME] | Vaidoriyum | U.Dal | 1kg
Dal | VaidoriyumU.Dal500gm | Vaidoriyum | U.Dal | 500gm
Dal | VaidoriyumU.Dal250gm | Vaidoriyum | U.Dal | 250gm
Dal | VaidoriyumU.Dal100gm | Vaidoriyum | U.Dal | 100gm
Dal | SasthaM.Dal1kg | Sastha | M.Dal | 1kg
Dal | SasthaM.Dal500gm | Sastha | M.Dal | 500gm
Dal | SasthaM.Dal250gm | Sastha | M.Dal | 250gm
Dal | SasthaM.Dal100gm | Sastha | M.Dal | 100gm
Dal | SasthaC.Dal1kg | Sastha | C.Dal | 1kg
Spreadsheet: 730335d1619642457-tracking-order-dates-excel-date-question
Sheet: Sheet1

Current Date
DATE ORDERED | DATE EXPECTED | [NAME]
23/03/2021 |  | True
30/03/2021 |  | False
14/04/2021 |  | False
27/04/2021 |  | False
date expected (column B), is 3 weeks from date ordered.
I need column B to be conditionally formatted to automatically highlight if
order is late. That is if the expected date arrives and I haven't checked the check-box.
But if I check the check-box, I want to conditional formatting highlight
function to be ignored.  As checking it means the order has arrived.
Spreadsheet: 770127d1645816788-need-formula-to-calculate-sick-day-entitlement-based-on-anniversary-date-sick-day-example
Sheet: Sheet1

Employee ID | Employee First Name | Employee Last Name | Date Of Hire | 90 days from DOH | Location | Sick Days at Start of Provision (Jan 1, 2022) | Sick Days Based on Anniversary Date | Sick Days Taken | Sick Days Left 2022
15179 | [NAME] | Smith | 2009-07-15 00:00:00 |  | Sample-Financial-Location | 5
49872 | [NAME] | Doe | 2009-08-01 00:00:00 |  | Sample-Financial-Location | 5
92636 | [NAME] | Boom | 2013-02-11 00:00:00 |  | Sample-Financial-Location | 5
25615 | [NAME] | Wood | 2013-03-01 00:00:00 |  | Sample-Financial-Location | 5
15652 | [NAME] | Hortons | 2022-02-15 00:00:00 |  | Sample-Financial-Location | 0
59220 | First | Last | 2022-02-15 00:00:00 |  | Sample-Financial-Location | 0
Spreadsheet: 85523d1285621746-vlookup-if-statement-example
Sheet: PRODUCTS

Product Name | Month | VLOOKUP/IF
Product 1 | 2010-01-01 00:00:00
Product 2 | 2009-12-01 00:00:00
Product 10 | 2010-01-01 00:00:00
Product 4 | 2010-02-01 00:00:00
Product 5 | 2010-03-01 00:00:00
Product 3 | 2010-04-01 00:00:00
Product 7 | 2010-06-01 00:00:00
Product 8 | 2010-04-03 00:00:00
Product 9 | 2010-05-01 00:00:00
Product 10 | 2010-04-05 00:00:00
Product 3 | 2009-12-01 00:00:00
Product 12 | 2010-06-01 00:00:00
Product 10 | 2010-04-08 00:00:00
Spreadsheet: 00b1ceb6-866d-43a5-9f36-4fbf8b127fe4
Sheet: 16a

Product |  | TOTAL
Single - Name* | Corporate
 | Loans
 | Municipal
 | Recovery
 | Sovereign
Index Tranche | Asia
 | Europe
 | North America
Index | Asia
 | Europe
 | North America
TOTAL |  | N/A**
Estimated swap dollar volumes, week ending December 7, by product type (total value of trades in millions of USD), all participant types, tenors and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 23e0b705-4015-484e-a1f3-0f4c5ff5f8da
Sheet: Sheet1

City Officials Statements | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
For Quarter Ending 12/31/08
(As of 1/29/2009)
Name | Title | Personal Benefits Reported | City Benefits Reported
Adams, Sam | City Commissioner | 2045
Ames, [NAME] | At-will staff for Comm. Adams
Baugh, [NAME] | Planning Commission Member
Birge, [NAME] | At-will staff for Comm. Adams |  | 150
Blackmer, [NAME] | City Auditor | 1406
Cortese, [NAME] | Portland Planning Commission Member | 316.04 | 97
Fish, [NAME] | City Commissioner
Hanson, [NAME] | Portland Planning Commission Member
Kuhn, [NAME] | At-will staff for Comm. Fish | 30
[NAME], [NAME] | At-will staff for Comm. Adams
Leonard, [NAME] | City Commissioner
[NAME], [NAME] | At-Will staff for Comm. Adams
Marriott, [NAME] | Director of Bureau of Environmental Services
[NAME], [NAME] | At-will staff for Comm. Adams
Neal, Clay | At-will staff for Comm. Adams
Oppenheim, [NAME] | At-will staff for Comm. Adams | 25
Potter, [NAME] | Mayor | 388.97 | Yes, Values Not Given
[NAME], [NAME] | At-will staff for Comm. Adams
Saltzman, [NAME] | City Commissioner | 25
[NAME], [NAME] | Director of Bureau of Development Services
Schneider, Kimberly | At-will staff for Comm. Adams
[NAME], [NAME] | Director of Bureau of Police | 85
Uwagbae, Grace | At-will staff for Mayor [NAME]
Waas [NAME], Nate | At-will staff for Mayor [NAME]
Spreadsheet: 124999d1318794976-excel-2007-data-sorting-example-of-issue
Sheet: HD Table

 | Pivot Table
Date | Average of Value | Count of Value
1983 | 101.5343915343915 | #N/A
1984 | 105.472 | #N/A
1985 | 112.908 | #N/A
1986 | 111.78 | #N/A
1987 | 114.7023809523809 | #N/A
1988 | 110.8253968253968 | #N/A
1989 | 109.2430278884462 | #N/A
1990 | 117.1150793650794 | #N/A
1991 | 104.7628458498024 | #N/A
1992 | 120.2795275590551 | #N/A
1993 | 110.836 | #N/A
1994 | 113.5019920318725 | #N/A
1995 | 105.144 | #N/A
1996 | 108.7896825396825 | #N/A
1997 | 110.8650793650794 | #N/A
1998 | 106.4143426294821 | #N/A
1999 | 107.704 | #N/A
2000 | 111.6345381526104 | #N/A
2001 | 111.1781376518219 | #N/A
2002 | 109.684 | #N/A
2003 | 109.868 | #N/A
2004 | 108.566265060241 | #N/A
2005 | 107.7290836653386 | #N/A
2006 | 104.8313253012048 | #N/A
2007 | 108.7211155378486 | #N/A
2008 | 108.4110671936759 | #N/A
2009 | 109.6388888888889 | #N/A
2010 | 108.2103174603175 | #N/A
2011 | 112.9137055837563 | #N/A
Spreadsheet: 0a805602-a27a-4620-9383-c5440c47562a
Sheet: 12a

Product1 | Cleared2 | Uncleared | TOTAL
Cross_Currency Basis | 0 | 34932 | 34932
Cross_Currency Fixed-Fixed | 0 | 452 | 452
Cross_Currency Fixed-Float | 0 | 9175 | 9175
TOTAL | -
Spreadsheet: 0d534186-f24a-4488-b037-ef364731a399
Sheet: Sheet1

STATE OF WEST VIRGINIA | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
OFFICES OF THE INSURANCE COMMISSIONER
HEALTH MAINTENANCE ORGANIZATION
ANNUAL/QUARTERLY COUNTY ENROLLMENT WORKSHEET
Chapter 33, Article 25A of the West Virginia Code
Company Name: |  |  |  |  | For Year/Quarter  Ending:
County | Number of Contracted Primary Care Providers In County | Percentage of Market Penetration      (Number of Enrollees/Population)                    End of Year/Qtr |  |  | Number of PEIA Enrollees | Number of Medicaid Enrollees | Number of Medicare Enrollees | Number of Other Enrollees | Total Number of Enrollees at the End of the Year/Qtr
 |  | Number of Enrollees | Population | Percentage
Barbour |  | 0 |  |  |  |  |  |  | 0
Berkeley |  | 0 |  |  |  |  |  |  | 0
Boone |  | 0 |  |  |  |  |  |  | 0
Braxton |  | 0 |  |  |  |  |  |  | 0
Brooke |  | 0 |  |  |  |  |  |  | 0
Cabell |  | 0 |  |  |  |  |  |  | 0
[NAME] |  | 0 |  |  |  |  |  |  | 0
Clay |  | 0 |  |  |  |  |  |  | 0
Doddridge |  | 0 |  |  |  |  |  |  | 0
Fayette |  | 0 |  |  |  |  |  |  | 0
Gilmer |  | 0 |  |  |  |  |  |  | 0
Grant |  | 0 |  |  |  |  |  |  | 0
[NAME] |  | 0 |  |  |  |  |  |  | 0
Hampshire |  | 0 |  |  |  |  |  |  | 0
Hancock |  | 0 |  |  |  |  |  |  | 0
Hardy |  | 0 |  |  |  |  |  |  | 0
[NAME] |  | 0 |  |  |  |  |  |  | 0
[NAME] |  | 0 |  |  |  |  |  |  | 0
[NAME] |  | 0 |  |  |  |  |  |  | 0
Kanawha |  | 0 |  |  |  |  |  |  | 0
Lewis |  | 0 |  |  |  |  |  |  | 0
Lincoln |  | 0 |  |  |  |  |  |  | 0
Logan |  | 0 |  |  |  |  |  |  | 0
Marion |  | 0 |  |  |  |  |  |  | 0
[NAME] |  | 0 |  |  |  |  |  |  | 0
Mason |  | 0 |  |  |  |  |  |  | 0
McDowell |  | 0 |  |  |  |  |  |  | 0
Mercer |  | 0 |  |  |  |  |  |  | 0
Mineral |  | 0 |  |  |  |  |  |  | 0
Mingo |  | 0 |  |  |  |  |  |  | 0
Monongalia |  | 0 |  |  |  |  |  |  | 0
Monroe |  | 0 |  |  |  |  |  |  | 0
Morgan |  | 0 |  |  |  |  |  |  | 0
[NAME] |  | 0 |  |  |  |  |  |  | 0
Ohio |  | 0 |  |  |  |  |  |  | 0
Pendleton |  | 0 |  |  |  |  |  |  | 0
Pleasants |  | 0 |  |  |  |  |  |  | 0
Pocahontas |  | 0 |  |  |  |  |  |  | 0
Preston |  | 0 |  |  |  |  |  |  | 0
Putnam |  | 0 |  |  |  |  |  |  | 0
Raleigh |  | 0 |  |  |  |  |  |  | 0
Randolph |  | 0 |  |  |  |  |  |  | 0
[NAME] |  | 0 |  |  |  |  |  |  | 0
Roane |  | 0 |  |  |  |  |  |  | 0
Summers |  | 0 |  |  |  |  |  |  | 0
[NAME] |  | 0 |  |  |  |  |  |  | 0
[NAME] |  | 0 |  |  |  |  |  |  | 0
Tyler |  | 0 |  |  |  |  |  |  | 0
Upshur |  | 0 |  |  |  |  |  |  | 0
Wayne |  | 0 |  |  |  |  |  |  | 0
[NAME] |  | 0 |  |  |  |  |  |  | 0
Wetzel |  | 0 |  |  |  |  |  |  | 0
Wirt |  | 0 |  |  |  |  |  |  | 0
Wood |  | 0 |  |  |  |  |  |  | 0
Wyoming |  | 0 |  |  |  |  |  |  | 0
Total | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 792235d1660803990-formulas-for-if-and-depending-few-conditions-with-a-result-abc123-2-
Sheet: Sheet1

 | Existing or New Staff | Induction Date | Due Date to complete | Selected Class | Selected date | Actual Date completed | Status
 | Existing | 2019-01-02 00:00:00 |  | [NAME] | 2019-02-02 00:00:00 | 2019-02-10 00:00:00
 | Existing | 2019-01-02 00:00:00 |  | Bengali | 2019-01-30 00:00:00
 | Existing | 2019-01-02 00:00:00 |  | English | 2013-02-28 00:00:00
 | New | 2022-08-17 00:00:00 |  | [NAME] | 2024-08-08 00:00:00
 | Existing | 2021-07-10 00:00:00 |  | [NAME] | 2021-09-06 00:00:00
 | New | 2022-08-15 00:00:00 |  | Bengali | 2022-08-16 00:00:00 | 2022-08-17 00:00:00
 | New |  |  | [NAME]
 | Existing |  |  | Bengali
Spreadsheet: 852515d1702512821-separate-and-group-sequential-and-non-sequential-numbers-separate-between-sequential-and-non-sequential
Sheet: Sheet1

Sample Data 1 |  | Desired Result |  |  | Sample Data 2 |  | Desired Result |  |  |  | Sample 1 |  |  | Sample 2
 |  | From | To |  |  |  | From | To
1 |  | 1 | 3 |  | 17 |  | 17 |  |  |  |  | 3
2 |  | 5 |  |  | 19 |  | 19 | 20 |  |  | 5 |  |  | 19 | 20
3 |  | 7 | 9 |  | 20 |  | 24 |  |  |  | 7 | 9 |  | 24
5 |  | 11 |  |  | 24 |  | 26 | 27 |  |  | 11 |  |  | 26 | 27
7 |  | 13 |  |  | 26 |  | 29 | 32 |  |  | 13 |  |  | 29 | 32
8 |  | 15 | 20 |  | 27 |  | 34 |  |  |  | 15 | 20 |  | 34
9 |  |  |  |  | 29
11 |  |  |  |  | 30
13 |  |  |  |  | 31
15 |  |  |  |  | 32
16 |  |  |  |  | 34
17
18
19
20
Spreadsheet: 778884d1651417415-index-match-multiple-matches-into-separate-columns-agenda-teams-aligw
Sheet: Sheet1

 | Participants (Lifelong learners) | Random | Group
 | [NAME]
 | BR
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | WX
 | Kye
 | Round 1 |  | Topic
 | Salesperson |  | Prospect
1 |  |  |  | << The other member of group one needs to be in this cell to the left
2
3
4
 | Round 2 |  | Topic
 | Salesperson |  | Prospect
1
2
3
4
Spreadsheet: 155661d1337003405-matchup-macro-formula-macro_test
Sheet: Sheet1

 | 5055625201610 | 5055625201610 | 10400411 | X-Acto No 11 Fine Point Blade Pk15 (Each) | 2012-05-10 00:00:00
 | 5055625201627 | 5055625201627 | 10400416 | X-ACTO No 16 Scoring [NAME] of 15 Carded | 2012-05-10 00:00:00
 | 5055625201634 | 5055625201634 | 10400421 | X-ACTO No 11 Stainless Steel Dispenser of 15 Carded | 2012-05-10 00:00:00
 | 5055625201641 | 5055625201641 | 10400492 | X-ACTO No 92 Heavy Duty Utility Blade Dispenser of 15 Carded | 2012-05-10 00:00:00
 | 5055625201658 | 5055625201658 | 10400511 | X-ACTO No 11 X-Life Classic Fine Point Blade Box Of 500 | 2012-05-10 00:00:00
 | 5055625201665 | 5055625201665 | 10400602 | X-ACTO No 2 Large Fine Point [NAME] of 100 | 2012-05-10 00:00:00
 | 5055625201672 | 5055625201672 | 10400610 | X-ACTO No 10 General Purpose [NAME] Of 100 | 2012-05-10 00:00:00
 | 5055625201689 | 5055625201689 | 10400611 | X-Acto X611 No 11 Fine Point Blade Boxed Pack of 100 | 2012-05-10 00:00:00
 | 5055625201696 | 5055625201696 | 10400616 | X-ACTO No 16 Scoring [NAME] Of 100 | 2012-05-10 00:00:00
 | 5055625201702 | 5055625201702 | 10400617 | X-ACTO No 17 Leightweight Chiseling Blade Box Of 100 | 2012-05-10 00:00:00
 | 5055625201719 | 5055625201719 | 10400618 | X-ACTO No 18 Heavyweight Wood Chiseling Blade Box Of 100 | 2012-05-10 00:00:00
 | 5055625201726 |  |  | 10400618 | X-ACTO No 18 Heavyweight Wood Chiseling Blade Box Of 100 | 2012-05-10 00:00:00
 | 5055625201733 |  |  | 10400617 | X-ACTO No 17 Leightweight Chiseling Blade Box Of 100 | 2012-05-10 00:00:00
 | 5055625201740 |  |  | 10400616 | X-ACTO No 16 Scoring [NAME] Of 100 | 2012-05-10 00:00:00
 | 5055625201757 |  |  | 10400611 | X-Acto X611 No 11 Fine Point Blade Boxed Pack of 100 | 2012-05-10 00:00:00
 | 5055625201764 |  |  | 10400610 | X-ACTO No 10 General Purpose [NAME] Of 100 | 2012-05-10 00:00:00
 | 5055625201771 |  |  | 10400602 | X-ACTO No 2 Large Fine Point [NAME] of 100 | 2012-05-10 00:00:00
 | 5055625201788 |  |  | 10400511 | X-ACTO No 11 X-Life Classic Fine Point Blade Box Of 500 | 2012-05-10 00:00:00
 | 5055625201795 |  |  | 10400492 | X-ACTO No 92 Heavy Duty Utility Blade Dispenser of 15 Carded | 2012-05-10 00:00:00
 | 5055625201801 |  |  | 10400421 | X-ACTO No 11 Stainless Steel Dispenser of 15 Carded | 2012-05-10 00:00:00
 | 5055625201818 |  |  | 10400416 | X-ACTO No 16 Scoring [NAME] of 15 Carded | 2012-05-10 00:00:00
 | 5055625201825 |  |  | 10400411 | X-Acto No 11 Fine Point Blade Pk15 (Each) | 2012-05-10 00:00:00
Spreadsheet: daren_farmer__5757__HPLN0309
Sheet: Sheet1

HPLN0309.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - March 09, 2001
 |  |  |  |  |  | **Friday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-03-09 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 140353d1328715388-help-creating-mileage-calculation-formula-with-blank-cells-multiple-lines-ifta_mln
Sheet: 41

Resource # | Date | Employee # | Job # | Department | Leave | Enter IL | Arrive at Job | Enter WI | Return | [NAME] | [NAME] | Total Miles | Fuel Added | Fuel Added Cost | Fuel Added Type | Notes
TRUCK 41 | 2012-01-01 00:00:00 | 1234 | LS11-0003 | Landscape | 10000 | 10011 | 10055 | 10065 |  | 51 | 65 | 116
TRUCK 41 | 2012-01-01 00:00:00 | 1234 | LS10-0002 | Landscape |  |  | 10075 | 10105 | 10116
TRUCK 41
TRUCK 41 | 2012-01-02 00:00:00 | 1234 | LS11-0004 | Landscape | 10000 |  | 10021 |  |  | 13 | 55 | 68
TRUCK 41 | 2012-01-02 00:00:00 | 1234 | LS10-0005 | Landscape |  |  | 10028
TRUCK 41 | 2012-01-02 00:00:00 | 1234 | LS11-0006 | Landscape |  | 10035 | 10045 | 10055 | 10068
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
TRUCK 41
Spreadsheet: 131314d1322859827-populating-data-from-one-sheet-to-another-book1
Sheet: data

 |  |  |  |  | A1 | A2 | B1 | B2 | F
Element | Product | topic | Percentage
A1 | gear | basketball | 0.03 |  | Y
A2 | bats | baseball | 0.1
A2 | bats | baseball | 0.02
A2 | bats | baseball | 0.06 |  |  | Y
A2 | bats | baseball | 0.45 |  |  | Y
B1 | helmets | football | 0.76 |  |  |  | Y
B1 | helmets | football | 0.66 |  |  |  | Y
B1 | helmets | football | 0.34 |  |  |  | Y
B1 | helmets | football | 0.12 |  |  |  | Y
B1 | helmets | football | 0.35
B2 | pads | hockey | 0.23 |  |  |  |  | Y
B2 | pads | hockey | 0.33 |  |  |  |  | Y
B2 | pads | hockey | 0.12 |  |  |  |  | Y
B2 | pads | hockey | 0.15
B2 | pads | hockey | 0.89
F | clubs | golf | 0.18 |  |  |  |  |  | Y
F | clubs | golf | 0.56 |  |  |  |  |  | Y
F | clubs | golf | 0.9 |  |  |  |  |  | Y
F | clubs | golf | 1 |  |  |  |  |  | Y
Spreadsheet: 271940d1382113554-creating-arrays-from-multiple-worksheets-example
Sheet: #4

COMBINED SORTED |  |  |  |  | SHEET #1,#2 & #3 SORTED
HIGHEST |  |  |  |  | HIGHEST
1 |  |  |  |  | 1
2 |  |  |  |  | 2
3 |  |  |  |  | 3
4 |  |  |  |  | 4
5 |  |  |  |  | 5
6 |  |  |  |  | 6
7 |  |  |  |  | 7
8 |  |  |  |  | 8
9 |  |  |  |  | 9
10 |  |  |  |  | 10
11 |  |  |  |  | 11
12 |  |  |  |  | 12
13 |  |  |  |  | 13
14 |  |  |  |  | 14
15 |  |  |  |  | 15
16 |  |  |  |  | 16
17 |  |  |  |  | 17
18 |  |  |  |  | 18
 |  |  |  |  |  | [NAME] won't pull the text from each row associated with the number in column I!! But will pull the correct number  in colum I!!