tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: lynn_blair__24358__2001MYPRC Overview
Sheet: Gas Logistics-Level

Comm Support |  | 1 | 2+ | 2 | 2- | 3
 | Level 18
 | [NAME] |  |  | 1
 | [NAME] | 1
 | [NAME] |  |  | 1
 | Level 17
 | [NAME] | 1
 | [NAME] |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | Ramona Betancourt |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  | 1
 | [NAME] |  |  | 1
 | [NAME] | 1
 | [NAME] |  |  | 1
 | Level 16
 | [NAME] |  |  |  | 1
 | [NAME] |  |  |  | 1
 | [NAME] |  | 1
 | [NAME] |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  |  | 1
 | [NAME] |  |  | 1
 | Tangie Dykes |  |  | 1
 | [NAME] |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  |  | 1
 | [NAME] |  |  | 1
Level 16 to 17 | [NAME] | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | Level 14
Level 14 to 16 | [NAME] | 1
 | [NAME] |  |  | 1
 | [NAME] |  | 1
 | [NAME] |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  |  | 1
 | [NAME] | 1
 | [NAME] |  |  |  | 1
 | [NAME] |  |  |  |  | 1
 | [NAME] |  |  | 1
Level 14 to 16 | [NAME] | 1
 | [NAME] |  |  |  | 1
 | [NAME] |  |  |  |  | 1
 | [NAME] |  |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  |  | 1
 | [NAME] |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  | 1
 | [NAME] | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  |  | 1
 | [NAME] |  |  |  | 1
 | [NAME] |  |  | 1
Level 14 to 16 | [NAME] | 1
 | [NAME] |  | 1
 | [NAME] |  |  |  | 1
 | [NAME] |  |  | 1
Potential | [NAME] |  |  | 1
 | Level 12
Associate Program | [NAME]
Associate Program | [NAME]
 | [NAME] |  |  | 1
Employee Total
ETS Target
Gas Conrol
 | Level 18
 | Dannis Bellard | 1
 | [NAME] | 1
 | Darrell Schoolcraft |  |  | 1
 | Level 17
 | [NAME] |  | 1
 | Engineer Vac FGT
 | Level 15
Level 15 to 17 | [NAME] | 1
 | Level 14
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] | 1
 | Helen Cummings |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] | 1
 | [NAME] | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | Level 13
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | Crandal Hardy |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | Jodi [NAME] |  |  | 1
new employee | [NAME]* |  |  | 1
 | EOTT
 | [NAME] | 1
 | [NAME] |  |  | 1
Level 13 to 14 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
Level 13 to 14 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  |  |  | 1
 | [NAME] |  |  | 1
Total Gas Control
Total Employees
ETS Target
 | Level 10-Non-exempt
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | Josue Vasquez |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
 | [NAME] |  |  | 1
Spreadsheet: c149a662-0ccf-4ab5-9e72-2c5084ee063e
Sheet: San Mateo County

Site ID | Priority Ranking | Readiness | Street Name | Side of Street | Nearest Cross-street | Closest Property | Station Length | Sidewalk | Parking Lane | Private Property | Historical Site | Environmental Issues | Construction Needed | Comments (If applicable, explain construction/ environmental issues)
SM001 | 1 | 2 | [NAME] | S | County Center | SMC Museum | 6 docks | Y | N | N | N | N | N | Shared lot with History Museum
SM002 | 1 | 2 | Middlefield | S | [NAME] | Fair Oaks Library | 9 docks | Y | N | N | N | N | N | Placed over existing parking
SM003 | 1 | 2 | Industrial Way | N | Circle Star Way | Circle Star | 9 docks | Y | N | N | N | N | N | Placed over existing parking
Spreadsheet: 76364d1276869867-rearrange-pivot-table-columns-pt-group
Sheet: Sheet1

Date | Product | Units
2009-10-01 00:00:00 | Apples | 10 |  |  | Month | Years | Date
2009-10-15 00:00:00 | Peaches | 20 |  |  |  | 2009 |  |  | 2010 | Grand Total
2009-11-01 00:00:00 | Apples | 30 |  |  | Product | Oct | Nov | Dec | Jan
2009-11-15 00:00:00 | Peaches | 40 |  |  | Apples | 10 | 30 |  |  | 40
2009-12-01 00:00:00 | Lemons | 50 |  |  | Lemons |  |  | 50 |  | 50
2010-01-01 00:00:00 | Strawberries | 60 |  |  | Peaches | 20 | 40 |  |  | 60
2010-01-15 00:00:00 | Watermelons | 70 |  |  | Strawberries |  |  |  | 60 | 60
 |  |  |  |  | Watermelons |  |  |  | 70 | 70
 |  |  |  |  | Grand Total | 30 | 70 | 50 | 130 | 280
Spreadsheet: chris_germany__2336__2001tran04
Sheet: CNG Parking

 |  | 643788 |  |  |  |  |  | 643789
 | Date | Park | Takout | Balance | Rate | Amount |  | Borrow | Payback | Balance | Rate | Amount
 | 2001-03-01 00:00:00
 |  | 7489 |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  | 2670 |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  | 2670 |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  | 2670 |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
 |  |  |  |  | 0.0724 |  |  |  |  |  | 0.0724
Spreadsheet: diana_scholtes__8547__Letter Log 01-07
Sheet: Termination

 | Events of Default/Termination
 | As of January 7, 2002
Term | Counterparty | Attorney Assigned | Enron Entity | Amount (if applicable) | Early Termination Date | Nature of Default (if any) | Contract Type(s) | Comments | Margin: (Posted by Enron)/Posted to Enron
 | Dominion Transmission, Inc. |  | EES |  | 2001-12-31 00:00:00 | 30 days notice | [NAME]. E00205, MCS081, T0009, [NAME], 8G310S, 8T310S | either party may elect to terminate on 30 days notice
Y | Dynegy Power Marketing, Inc. |  | EPMI |  | 2001-12-20 00:00:00 |  |  | Dynegy terminated [NAME], per [NAME], this agreement terminated
 | EPCOR Merchant and Capital L.P. (f/k/a Encore Energy Solutions, L.P.) |  | ECC |  | 2002-01-04 00:00:00 | bankruptcy | ISDA (06/04/2001) | EPCOR will calculate amount due
Y | Green Mountain Power Corporation |  | EPMI |  | 2001-12-02 00:00:00 | bankruptcy | Sales Enabling Agreement | Per [NAME], agreement terminates automatically on bankruptcy filing
Research | Groupo Industrial Saltillo, S.A. de C.V. |  | ENA | $2,515,500 due for past due amounts | 01/07/2002 for ISDA; 12/02/2001 for deal no. QR4615.1 | bankruptcy | ISDA (02/12/2001) | [NAME] will calculate its loss (in addition to past due amounts specified)
 | INTERCOR |  | ENA |  | 2001-11-29 00:00:00 | bankruptcy | Charter Party (07/24/2001)
 | ITOCHU Corporation |  | ENA |  |  |  | newsprint confirm (10/10/2001) | received Agreement of Termination that counterparty is asking ENA to execute
Y | LG&E Energy Marketing |  | EPMI |  | 2001-12-02 00:00:00 | bankruptcy |  | Per [NAME], agreement terminates automatically on bankruptcy filing
Y | Northern Illinois Gas Company d/b/a Nicor Gas Company |  | ENA |  | 2002-01-04 00:00:00 | failure to pay or deliver | ISDA (08/01/2001)
 | Seaport Hotel LP |  | EES | 146357.37 | ? | insolvency, inability to pay debts, bankruptcy | Electric Energy Sales & Services Agreement Commonwealth of Massachusetts (06/09/2000) | should be 12/03 ltr establishing ET Date
 | Spires Association, The |  | EES |  | ? | failure to make required payment | Electric Sales and Services Agreement (06/01/2001) | terminating "agency letter" delivered in connection with the agreement
Y | [NAME] |  | ENA |  | 2002-01-01 00:00:00 | non payment | Gas Purchase Agreement, meter no. 602556
Spreadsheet: 178944d1346962514-countif-function-with-a-lookup-book64
Sheet: Sheet1

 |  | Col 1 | Col 2 |  |  | Count If "A"
 |  | A | Chicago |  | Chicago | 2
 |  |  | New York |  | Dallas | 2
 |  | A | Dallas |  | Boston | 0
 |  |  | Boston |  | New York | 1
 |  |  | New York
 |  | A | Chicago
 |  |  | Dallas
 |  |  | New York
 |  |  | Dallas
 |  |  | Boston
 |  | A | New York
 |  |  | Chicago
 |  | A | Dallas
Spreadsheet: 748887d1632402958-filter-an-array-apply-a-line-by-line-formula-and-sum-total-revenue_calc
Sheet: Feuil1

 |  |  |  |  | 2021-01-01 00:00:00
 |  |  |  |  | 2021-06-30 00:00:00
Country | First day of service | Last day of service | Amount |  | USA
USA | 2021-01-05 00:00:00 | 2022-04-30 00:00:00 | 10000
France | 2019-12-01 00:00:00 | 2022-11-30 00:00:00 | 11000
USA | 2022-12-01 00:00:00 | 2023-11-30 00:00:00 | 13000
France | 2020-10-01 00:00:00 | 2022-09-30 00:00:00 | 7000
France | 2022-12-01 00:00:00 | 2023-11-30 00:00:00 | 13000
USA | 2020-10-01 00:00:00 | 2022-09-30 00:00:00 | 7000
 |  |  |  |  |  | How to calculate 5 415 € in a single formula?
Spreadsheet: 793607d1661571676-how-to-identify-column-with-duplicate-data-with-unique-values-in-another-book2
Sheet: Sheet1

Date | Amount | Comment | Desired Output
2022-01-04 00:00:00 | 213 | Not Verified | No verification
2022-01-06 00:00:00 | 213 | Not Verified | No verification
2022-03-04 00:00:00 | 213 | Not Verified | No verification
2022-03-04 00:00:00 | 31568 | Not Verified | Verification
2022-03-07 00:00:00 | 31568 | Verified | Verification
2022-04-01 00:00:00 | 31568 | Verified | No verification
2022-01-06 00:00:00 | 51321 | Verified | No verification
2022-03-04 00:00:00 | 51321 | Verified | No verification
2022-03-05 00:00:00 | 51321 | Verified | No verification
2022-01-06 00:00:00 | 65465 | Verified | Verification
2022-01-07 00:00:00 | 65465 | Not Verified | Verification
2022-02-01 00:00:00 | 65465 | Verified | Verification
2022-02-03 00:00:00 | 65465 | Not Verified | Verification
2022-02-09 00:00:00 | 65465 | Verified | Verification
2022-02-10 00:00:00 | 65465 | Not Verified | Verification
2022-03-30 00:00:00 | 65465 | Not Verified | Verification
2022-04-01 00:00:00 | 65465 | Verified | Verification
2022-05-04 00:00:00 | 65465 | Not Verified | Verification
2022-05-02 00:00:00 | 65465 | Verified | Verification
2022-05-02 00:00:00 | 65465 | Not Verified | No verification
Spreadsheet: 795683d1662851410-multi-level-parent-summation-bom-type-book1-lucyl-
Sheet: Sheet1

Level | Child Values | Parent / Total SUMS
0 |  | 130
1 |  | 43
2 | 25 | 25
2 |  | 18
3 |  | 18
4 |  | 18
5 | 18
1 |  | 87
2 | 27 | 27
2 |  | 60
3 | 30
3 | 30
0 |  | 115
1 | 26 | 26
1 |  | 89
2 |  | 89
End
Spreadsheet: 009329d4-83e3-4979-9b10-5a20c68764ca
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
 | 6202.0 Labour Force, Australia
 | Table 21. Quarter measure of aggregate monthly hours worked by Industry Sector - Seasonally adjusted
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Aggregate Monthly Hours Worked ;  Agriculture ; |  |  | Seasonally Adjusted | A3539308V | 1984-12-01 00:00:00 | 2013-06-01 00:00:00 | 115 | 000 Hours | FLOW | Quarter | 3
Aggregate Monthly Hours Worked ;  Market excluding Agriculture (Rest of Market) ; |  |  | Seasonally Adjusted | A3539305L | 1984-12-01 00:00:00 | 2013-06-01 00:00:00 | 115 | 000 Hours | FLOW | Quarter | 3
Aggregate Monthly Hours Worked ;  Market ; |  |  | Seasonally Adjusted | A3539309W | 1984-12-01 00:00:00 | 2013-06-01 00:00:00 | 115 | 000 Hours | FLOW | Quarter | 3
Aggregate Monthly Hours Worked ;  Education ; |  |  | Seasonally Adjusted | A3539306R | 1984-12-01 00:00:00 | 2013-06-01 00:00:00 | 115 | 000 Hours | FLOW | Quarter | 3
Aggregate Monthly Hours Worked ;  Non Market excluding Education (Rest of Non Market) ; |  |  | Seasonally Adjusted | A3539307T | 1984-12-01 00:00:00 | 2013-06-01 00:00:00 | 115 | 000 Hours | FLOW | Quarter | 3
Aggregate Monthly Hours Worked ;  Non Market ; |  |  | Seasonally Adjusted | A3539310F | 1984-12-01 00:00:00 | 2013-06-01 00:00:00 | 115 | 000 Hours | FLOW | Quarter | 3
Aggregate Monthly Hours Worked ;  Total (Industry ANZSIC06) ; |  |  | Seasonally Adjusted | A3539311J | 1984-12-01 00:00:00 | 2013-06-01 00:00:00 | 115 | 000 Hours | FLOW | Quarter | 3
© Commonwealth of Australia  2013
Spreadsheet: john_griffith__16141__1_24_02GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HU G2 | 57 | 200 | 280 | 42 | 58.8 | 1.81 | 2002-01-24 14:08:00
 | [NAME] | 58 | 600 | 700 | 43.9 | 51.3 | 1.74 | 2002-01-24 14:08:00
 | [NAME] | 65 | 910 | 1010 | 43.6 | 48.4 | 1.88 | 2002-01-24 14:08:00
 | [NAME] | 65 | 1150 | 1250 | 44.9 | 48.9 | 1.92 | 2002-01-24 14:08:00
 | [NAME] | 65 | 1300 | 1400 | 43.7 | 47.1 | 1.86 | 2002-01-24 14:08:00
 | HU N2 | 65 | 1350 | 1450 | 41.1 | 44.2 | 1.74 | 2002-01-24 14:08:00
 | [NAME] | 65 | 1375 | 1500 | 38.4 | 41.9 | 1.64 | 2002-01-24 14:08:00
 | HU U2 | 63 | 1400 | 1525 | 37.3 | 40.7 | 1.54 | 2002-01-24 14:08:00
 | [NAME] | 59 | 1375 | 1550 | 36.9 | 41.6 | 1.46 | 2002-01-24 14:08:00
 | [NAME] |  |  |  | 35.9 | 39.8 | 1.36 | 2002-01-22 15:03:00
 | [NAME] |  |  |  | 35.4 | 40.3 | 1.4 | 2001-11-29 15:00:00
 | HU F3 |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | HU H3
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]
Spreadsheet: 43430d1242099214-formula-to-copy-cell-data-from-another-worksheet-for-a-particular-condition-sample-data
Sheet: Sale Data

Date range | Class | Item # | Color | Area | Sale Date
1/1-1/20 | A | UPQ456 | Red | East | 2009-01-01 00:00:00
1/1-1/20 | A | UPQ879 | Yellow | Northeast | 2009-01-02 00:00:00
1/1-1/20 | A | UPQ529 | Green | West | 2009-01-03 00:00:00
1/1-1/20 | A | UPQ123 | Blue | West | 2009-01-04 00:00:00
1/1-1/20 | A | UPQ741 | Orange | West | 2009-01-05 00:00:00
1/1-1/20 | A | UPQ475 | Green | Mid West | 2009-01-06 00:00:00
1/1-1/20 | B | MLP789 | Yellow | East Coast | 2009-01-07 00:00:00
1/1-1/20 | B | MLP654 | Orange | East Coast | 2009-01-08 00:00:00
1/1-1/20 | B | MLP754 | Orange | Northeast | 2009-01-09 00:00:00
1/1-1/20 | B | MLP789 | Purple | South | 2009-01-10 00:00:00
1/1-1/20 | B | MLP657 | Light green | Central | 2009-01-11 00:00:00
1/1-1/20 | C | QRP879 | Daylight | Central | 2009-01-12 00:00:00
1/1-1/20 | C | QRP546 | Blue | East | 2009-01-13 00:00:00
1/1-1/20 | C | QRP741 | Silver | Northeast | 2009-01-14 00:00:00
2/1-2/20 | A | UPQ451 | Gold | West | 2009-02-01 00:00:00
2/1-2/20 | A | [NAME] | Green | West | 2009-02-02 00:00:00
2/1-2/20 | A | [NAME] | Blue | West | 2009-02-03 00:00:00
2/1-2/20 | A | UPQ157 | Red | Mid West | 2009-02-04 00:00:00
2/1-2/20 | B | MLP541 | Yellow | East Coast | 2009-02-05 00:00:00
2/1-2/20 | B | MLP547 | Purple | East Coast | 2009-02-06 00:00:00
2/1-2/20 | B | MLP689 | Daylight | Northeast | 2009-02-07 00:00:00
2/1-2/20 | B | MLP742 | Yellow | South | 2009-02-08 00:00:00
2/1-2/20 | C | QRP547 | Classic green | Central | 2009-02-09 00:00:00
2/1-2/20 | C | QRP245 | Red | Central | 2009-02-10 00:00:00
2/1-2/20 | C | QRP963 | Red | East | 2009-02-11 00:00:00
2/1-2/20 | C | QRP471 | Yellow | Northeast | 2009-02-12 00:00:00
2/1-2/20 | C | QRP263 | [NAME] | West | 2009-02-13 00:00:00
3/1-3/20 | A | UPQ744 | Gold | West | 2009-03-01 00:00:00
3/1-3/20 | A | UPQ576 | Silver | West | 2009-03-02 00:00:00
3/1-3/20 | A | UPQ746 | Green | Mid West | 2009-03-03 00:00:00
3/1-3/20 | A | UPQ24 | Blue | East Coast | 2009-03-04 00:00:00
3/1-3/20 | A | UPQ546 | Red | East Coast | 2009-03-05 00:00:00
3/1-3/20 | A | UPQ524 | Yellow | Northeast | 2009-03-06 00:00:00
3/1-3/20 | A | UPQ247 | Purple | South | 2009-03-07 00:00:00
3/1-3/20 | B | MLP741 | Blue | Central | 2009-03-08 00:00:00
3/1-3/20 | B | MLP245 | Orange | Central | 2009-03-09 00:00:00
3/1-3/20 | B | MLP745 | Orange | Central | 2009-03-10 00:00:00
Spreadsheet: 647999d1572828341-column-search-with-various-formats-of-names-office-problem
Sheet: Example Sheet

Target to search ( each of the cell below) - Date format DD/MM/YY | Search against this Coloumn | Record 1D | Date
Tanya, Surname_25/12/18 | Names 1 |  | 2018-12-25 00:00:00
[NAME] | Names 2 Surname |  | 2012-12-11 00:00:00
Surname kenny_10/08/12 | Surname Name 3 |  | 2012-08-10 00:00:00
Surname, Thomas_12/06/19 | Name_Surname4 |  | 2018-04-12 00:00:00
[NAME] ven desol_12/04/18 | Tanya, Surname_25/12/18 |  | 2018-04-12 00:00:00
[NAME] | [NAME] Jones|_10/11/13 | Surname Name 4 |  | 2013-11-10 00:00:00
Vince_Surname | Surname Name 5 |  | 2016-06-15 00:00:00
[NAME] | Surname Name 6 |  | 2018-10-23 00:00:00
[NAME] | Surname Name 6 |  | 2016-10-13 00:00:00
 | [NAME]
 | [NAME] ven desol_12/04/18
 | Surname kenny_10/08/12
 | [NAME]
 | [NAME] ven desol_12/04/18
Expectations 1. First Name and  2. Last name coumn  and get the Record number (Here row number) of the name matching in Columnn B of Example sheet against each name of Column A.. The conditions are cut off date is Feb 01 2011. I need to search only record from that date.   3. There are multiple records with same name in A and B column, I need to match them against the date of record. | [NAME] | [NAME] Jones|_10/11/13
 | Vince_Surname
Spreadsheet: 870642d1717116184-help-with-convert-a-data-list-to-a-form-sampe-form-update-1-
Sheet: Sheet1

Arrangement ID | Arrangement |  |  |  | Start Date | Day | Shift | Start | Finish |  |  | Name |  |  | Day | Even-ing | Night | Unallocated | Sat | Sun | S/O | PH | P-U,W Total | KMs |  | Day | Even | night | Sat | Sun | s/o rate | PH | KMs
A3116 | GYM street |  |  |  | 2024-09-08 00:00:00 |  |  | 17:00:00 | 10:00:00 |  |  | [NAME] |  |  | 0 | 0 | 4 | 1 | 0 | 5 | 1 | 0 |  | 50 |  | 10 | 15 | 20 | 25 | 30 | 12 |  | 0.2
A3116 | GYM street |  |  |  | 2024-09-09 00:00:00 |  |  | 17:00:00 | 10:00:00 |  |  | [NAME] |  |  | 0 | 0 | 5 | 1 | 0 | 0 | 1 | 0 | 0 | 0 |  | 10 | 15 | 20 | 25 | 30 | 12 |  | 0.2
A3116 | GYM street |  |  |  | 2024-09-10 00:00:00 |  |  | 03:00:00 | 05:00:00 |  |  | [NAME] |  |  | 2 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10 | 15 | 20 | 25 | 30 | 12 |  | 0.2
A1288 | Delm street |  |  |  | 2024-09-02 00:00:00 |  |  | 03:00:00 | 05:00:00 |  |  | [NAME] |  |  | 2 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10 | 15 | 20 | 25 | 30 | 12 |  | 0.2
A1288 | Delm street |  |  |  | 2024-09-03 00:00:00 |  |  | 03:00:00 | 05:00:00 |  |  | [NAME] |  |  | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10 | 15 | 20 | 25 | 30 | 12 |  | 0.2
A1288 | Delm street |  |  |  | 2024-09-04 00:00:00 |  |  | 03:00:00 | 05:00:00 |  |  | [NAME] |  |  | 2 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10 | 15 | 20 | 25 | 30 | 12 |  | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | arrangement dropdown list |  |  | GYM street
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | Description |  |  |  | Unit | Rate | Amount
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-09-08 00:00:00 | Sun 17:00-22:00 -Tom |  |  |  | 5 | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-09-08 00:00:00 | Mon 06:00-10:00 -Tom |  |  |  | 4 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-09-08 00:00:00 | Sleepover |  |  |  | 1 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-09-08 00:00:00 | Mileage |  |  |  | 50 | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-09-09 00:00:00 | Mon 17:00-22:00 -Mary |  |  |  | 5 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-09-09 00:00:00 | Sleepover |  |  |  | 1 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-09-10 00:00:00 | Tue 03:00-05:00 -Sam |  |  |  | 2 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | total
Spreadsheet: 8e3867bd-34a1-4241-b265-d66ce96895b1
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4706 | 7597 | Hilary | Stevenson | GBR | 0 | 00:36:59 | [NAME] | 01:28:38 | 00:02:04 | 01:07:55 | 1 | 03:17:36
Spreadsheet: 166373d1341571189-mind-boggling-high-jump-rankings-highjumpranking
Sheet: Sheet1

 | 1.51 | 1.52 | 1.53 | 1.54 | 1.55 | 1.56 | 1.57 | 1.58 | 1.59 | 1.6 | Best | Tie Breaker | Ranking |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Position | Name | Best
[NAME] | O | O | O | O | O | O | XXO | [NAME] |  |  | 1.57 | 1.569979998 | 2 |  | 7 | O | O | O | O | O | O | XXO |  |  | OOOOOOXXO | 2 |  | 1 | Brooke | 1.57
Brooke | XO | XXO | XO | - | XXO | XXO | XO |  |  |  | 1.57 | 1.569989991 | 1 |  | 7 | XO | XXO | XO | - | XXO | XXO | XO |  |  | XOXXOXO-XXOXXOXO | 9 |  | 2 | [NAME] | 1.57
[NAME] | - | XXO | O | [NAME] | XO | XO | [NAME] |  |  |  | 1.56 | 1.559989995 | 5 |  | 6 | - | XXO | O | [NAME] | XO | XO |  |  |  | -XXOOX-XOXO | 5 |  | 3 | Emily | 1.56
Danielle | - | - | XXO | O | XO | XO | XX- | X |  |  | 1.56 | 1.559989996 | 4 |  | 6 | - | - | XXO | O | XO | XO |  |  |  | [NAME] | 4 |  | 4 | Danielle | 1.56
Emily | [NAME] | O | O | O | XX- | O | XX- | - | - | X | 1.56 | 1.559999997 | 3 |  | 6 | [NAME] | O | O | O | XX- | O |  |  |  | X-OOOXX-O | 3 |  | 5 | [NAME] | 1.56
[NAME] | - | O | O | O | O | XX | - | - | - | X | 1.55 | 1.55 | 6 |  | 5 | - | O | O | O | O |  |  |  |  | -OOOO | 0 |  | 6 | [NAME] | 1.55
Spreadsheet: 117086d1312440606-the-unique-of-beneficiaries-visited-kamalnov-2010-anc
Sheet: Sheet2

Village Name | Total Visits | TMC Visits | Field Visit | Benificiaries
Marriguda
Kundiguda
Totavalasa(Battivalasa)
Dappuguda
Sunkarametta
[NAME]
Chinalabudu
Lotheru
Toradambuvalasa
[NAME]
Nandiguda
[NAME]
Dalapatiguda
Dalapathiguda
[NAME]
Kappalagondi |  |  |  |  | SUM(IF(FREQUENCY(MATCH(Table1!E2:E1228,Table1!E2:E1228,0),MATCH(Table1!E2:E1228,Table1!E2:E1228,0))>0,1))
Chompi
[NAME]
Sarabhaguda |  |  |  |  | COUNTIFS(Table1!$H$2:$H$1228,A2)
Ramakrishnanagar
Boduguda |  |  |  |  | COUNTIFS(Table1!$H$2:$H$1228,A2,Table1!$L$2:$L$1228,Table1!$L$2)
[NAME]
Sirasaguda
Kentubade
Manjuguda
[NAME]
Borrakaluvalasa
Tangulabedda
Battivalasa
Bistunguda
Peda [NAME]
Pakanaguda
Kottavalasa
Ranajilleda
Garudaguda
Gondiguda
Girliguda
[NAME]
[NAME]
Manjaguda
Kothaballuguda
Lamtampadu
[NAME]
Kodipunjuvalasa
[NAME]
Janamguda
[NAME]
Vanthamuru
Sarrubedda
Siragam
Dolliguda
Yandapallivalasa
Bosubeda
[NAME]
Sukuruguda
Spreadsheet: 110076d1306858518-randomly-separate-data-into-quintiles-example
Sheet: Quintiles Price

Quintile 1
A
D
Y
F
G
L
Quintile 2
C
M
Q
V
T
Etc…
Spreadsheet: 142457d1329846023-vlookup-case-sensitive-sample1
Sheet: Sheet1

Number | What I Am Getting |  |  |  | Product | Number
12345b |  |  |  |  | Apple | 12345b
12345B |  |  |  |  | Computer | 12345B
11111a |  |  |  |  | Phone | 11111a
11111A |  |  |  |  | Drink | 11111A
Spreadsheet: 586003d1534153718-trying-to-create-a-simple-price-list-from-a-table-is-driving-me-nuts-help-needed-please-dd-dd-gk1
Sheet: Sheet1

Producer | Product
Cat | Product 1
[NAME] | Product 2
Cat | Product 3
[NAME] | Product 4
Ant products | Product 5
Ant products | Product 6
Cat | Product 7
Dog | Product 8
Cat | Product 9
Dog | Product 10
Fox | Product 11
Dog | Product 12
[NAME] | Product 13
[NAME] | Product 14
[NAME] | Product 15
[NAME] | Product 16
[NAME] | Product 17
Ant products | Product 18
Ant products | Product 19
Ant products | ggg
Ant products | [NAME]
Ant products | ghygh
Gnu | [NAME]
Gnu | ghj
Gnu | fvgfd
Gnu | ewwd
Spreadsheet: louise_kitchen__23878__TRS
Sheet: Motown

Project Motown
Valuation Summary
100% Balance Sheet
12597000 |  | Intitial fair value @ 6/30/00
-3153569.67 |  | 6/30/00 floating payment from WhitePine
873173.05 |  | 6/30/00 fixed payment to KBC
 |  | Balance @ 7/1/00
111400 |  | 9/30 fair value adjustment
-1690059.88 |  | 9/30/00 floating payment from WhitePine
1064002.8 |  | 9/30/00 fixed payment to KBC
 |  | Balance @ 10/1/00
-7600946 |  | 12/31/00 fair value adjustment
-1716648.33 |  | 12/31/00 floating payment from WhitePine
1076135.48 |  | 12/31/00 fixed payment to KBC
 |  | Balance @ 1/1/01