tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 835540d1688648398-find-multiple-occurrence-of-id-within-ranked-list-return-unique-id-unique-rank-example-v2
Sheet: Sheet1

ID | Rank | Child ID
1001 | 1 | 1002
1001 | 1 | 1005
1001 | 1 | 1007
1002 |  | 1008
1002 | 2 | 1009
1003 |  | 1004
1003 | 3 | 1006
1003 | 3 | 1007
1004 |  | 1009
1004 | 4 | 1010
1005 |  | 1009
1005 | 5 | 1010
1006 |  | 1007
1006 | 6 | 1008
1007 |  | 1008
1007 | 7 | 1009
1007 | 7 | 1010
1008 | 8 | 1009
1008 | 8 | 1009
1009 | 9 | 1010
1010 | 10 | 1020
1010 | 10 | 1030
Spreadsheet: 96611712-2f73-4447-aabf-aa1b6197dfde
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (16 Entries):
 | 15 Information gathering and services 15.1 Information 15.1.6 Associations
No. | Company | Country | City | [NAME] | Hall/Booth
1 | AEIS - Association of Electronic Industries in Singapore | Singapore | Singapore | 139658 | A1.166/4
2 | AMA Fachverband für [NAME] | Germany | Berlin | 14059 | A2.229
3 | CEPEX - Centre de Promotion des Exportation | Tunisia | Tunis |  | A6.A03
4 | Consorzio Elettrimpex-Assodel | Italy | Milano (MI) | 20134 | A5.160
5 | Deutscher Christlicher Techniker-Bund e.V. | Germany | Korntal-Münchingen | 70825 | A1.142
6 | DKE Deutsche Kommission Elektrotechnik Elektronik Informationstechnik im DIN und VDE | Germany | Frankfurt | 60596 | B3.119
7 | ELCINA Electronic Industries Association of India | India | New Delhi | 110020 | B5.261
8 | Electronics Representatives Association International | USA | Chicago | IL 60606 | A6.452
9 | Fraunhofer-Gesellschaft | Germany | München | 80686 | A5.221
10 | Fraunhofer-Gesellschaft | Germany | München | 80686 | B2.518
11 | Hong Kong Electronic Industries Association | Hong Kong | [NAME], Kowloon |  | B2.460/1
12 | Hong Kong Trade Development Council | Germany | Frankfurt | 60439 | B2.460/4
13 | Industrie- und [NAME] Potsdam | Germany | Potsdam | 14467 | A1.461
14 | The Institution of Engineering and Technology (IET) | United Kingdom | Stevenage, [NAME] | SG1 2AY | A1.156
15 | TAITRA Taiwan External Trade Development Council | Taiwan | Taipei 11012 |  | A3.445/3
16 | ZVEI-Fachverband Electronic Components and Systems | Germany | Frankfurt | 60528 | B1.Atrium
Spreadsheet: 802719d1666986105-can-some-one-help-with-a-multi-criteria-index-match-excel-simple-array-logic-please
Sheet: (10 Dock)

 |  | 10 Dock Portfolio Board Milestones
 |  | Revision History | RevA | 2022-08-01 00:00:00
 |  |  | Rev B
 |  |  | Rev C
Ref | Project | Contract Milestones |  | Baseline | [NAME] | Latest Forecast |  | Activity ID
1 | 10 Dock | Buildings Scheme Design Report Approved |  | 2022-09-02 00:00:00 | 2022-09-14 00:00:00 | 2022-10-12 00:00:00 |  | RFP020
2 | 10 Dock | N125 Building Demolition complete |  | 2022-11-08 00:00:00 | 2022-11-23 00:00:00 | 2022-10-28 00:00:00 |  | ENP30230
3 | 10 Dock | WRB Scheme Design Report Approved |  | 2022-07-11 00:00:00 | 2022-07-15 00:00:00 | 2022-11-16 00:00:00 |  | RFP980
4 | 10 Dock | NSRP Management Scheme Design Report Drafted |  | 2023-02-10 00:00:00 | 2023-04-14 00:00:00 | 2023-02-10 00:00:00 |  | RFP400
5 | 10 Dock | Building Substructure Commencement |  | 2023-03-06 00:00:00 | 2023-06-29 00:00:00 | 2023-03-24 00:00:00 |  | AEW-NDBS2870
6 | 10 Dock | Gas Trench Installation Complete |  | 2023-04-06 00:00:00 | 2023-09-07 00:00:00 | 2023-05-02 00:00:00 |  | A44590
7 | 10 Dock | Buildings Detailed Design Reported Authorised |  | 2023-08-25 00:00:00 | 2023-11-07 00:00:00 | 2023-09-08 00:00:00 |  | RFP20082
8 | 10 Dock | WRB Detailed Design Report Authorised |  | 2023-12-01 00:00:00 | 2024-02-26 00:00:00 | 2023-12-01 00:00:00 |  | RFP050
9 | 10 Dock | PCSR issued to ONR |  | 2024-01-31 00:00:00 | 2025-05-06 00:00:00 | 2024-03-25 00:00:00 |  | RFP060
 |  | Other Milestones
10 | 10 Dock | 6 Wharf Accommodation - for first phase occupation |  | 2022-12-08 00:00:00 | 2023-06-14 00:00:00 | 2022-12-12 00:00:00 |  | ENP10100
11 | 10 Dock | C2 Demolition Complete |  | 2022-11-23 00:00:00 | 2023-01-03 00:00:00 | 2022-12-19 00:00:00 |  | ENP30260
12 | 10 Dock | [NAME] from Atkins |  | 2022-11-07 00:00:00 | 2023-06-07 00:00:00 | 2022-12-12 00:00:00 |  | TBC
13 | 10 Dock | PCSR1 received from Atkins |  | 2022-12-09 00:00:00 | 2023-01-04 00:00:00 | 2022-12-14 00:00:00 |  | TBC
14 | 10 Dock | C10 Construction commencement |  | 2023-05-02 00:00:00 | 2023-11-30 00:00:00 | 2023-08-21 00:00:00 |  | AEW-NC1030
15 | 10 Dock | Construction Phase Contract Executed |  |  |  | 2023-04-03 00:00:00 |  | Not yet in scope
16 | 10 Dock | Start Dock Wall & Buttresses |  | 2023-08-08 00:00:00 | 2024-09-10 00:00:00 | 2023-08-14 00:00:00 |  | CW-DW9050
Spreadsheet: 78398d1278727955-lookup-a-different-part-against-required-one-pkg
Sheet: Sheet1

 | 11100KTC921 | CRANK CASE COMP.RIGHT
 | 11200KTC901 | CRANK CASE COMP.LEFT
 | 11330KTC901 | COVER COMP.R CRANK CASE
 | 11341KTC900 | [NAME] CRANK CASE
 | 17500KST920ZD | SET FUEL TANK(BSM)
 | 17500KST920ZE | SET FUEL TANK(EBM)
 | 28200KTC900 | KICK STARTER ASSY.
 | 28211GF6000 | PINION KICK STARTER
 | 51606198900ZU | [NAME]. [NAME] (AMZ BLUE ME)
 | 51606198D10ZA | COVER COMP. [NAME]. FORK UP. ( C.R.RED )
 | 11100KTCA20 | CRANK CASE COMP,RIGHT | 11100KTC921
 | 11200KTCA20 | CRANK CASE COMP,[NAME] | 11200KTC901
 | 11330KTCA20 | COVER COMP,R CRANK CASE | 11330KTC901
 | 11341KTCA20 | COVER,LEFT CRANK CASE | 11341KTC900
Spreadsheet: 144604d1331055212-multiple-bills-of-materials-test-book-01
Sheet: Sheet2

ITEM | PART_NUM | DRWGNUM | [NAME] | QTY | Count
1 | AA01 | DWG01 | DESC01 | 2 | 20
2 | AA02 | DWG02 | [NAME] | 1 | 19
3 | AA03 | DWG03 | DESC03 | 1 | 18
4 | [NAME] | DWG04 | DESC04 | 1 | 17
5 | AA05 | DWG05 | DESC05 | 2 | 16
6 | AA06 | DWG06 | DESC06 | 1 | 15
7 | AA07 | DWG07 | DESC07 | 1 | 14
8 | AA08 | DWG08 | [NAME] | 1 | 13
9 | AA09 | DWG09 | DESC09 | 1 | 12
10 | AA10 | DWG10 | [NAME] | 2 | 11
11 | AA11 | DWG21 | DESC21 | 1 | 5
12 | BB01 | DWG11 | DESC11 | 1 | 10
13 | BB02 | [NAME] | DESC12 | 1 | 9
14 | BB03 | DWG13 | DESC13 | 1 | 8
15 | BB04 | DWG14 | DESC14 | 1 | 7
16 | BB05 | DWG15 | DESC15 | 2 | 6
17 | BB06 | DWG16 | DESC16 | 1 | 5
18 | BB07 | DWG17 | DESC17 | 1 | 4
19 | BB08 | DWG18 | DESC18 | 1 | 3
20 | BB09 | DWG19 | DESC19 | 1 | 2
21 | BB10 | DWG20 | DESC20 | 2 | 1
Spreadsheet: 366e58ac-eac6-46a1-94e0-84e8d7690335
Sheet: Sheet1

Table 4 -- U.S. monthly average farm prices and marketings by class | 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
 |  |  | Long-grain |  |  |  |  |  |  |  |  | Medium/Short Grain
 |  | 2012/13 |  |  |  | 2011/12 |  |  |  | 2012/13 |  |  |  | 2011/12
Month | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt
August | 14 |  | 8176 |  | 12.4 |  | 9343 |  | 16.6 |  | 2680 |  | 18.9 |  | 2091
September | 13.8 |  | 9172 |  | 13.7 |  | 10310 |  | 17.8 |  | 1458 |  | 17.6 |  | 2394
October | 13.9 |  | 11849 |  | 14.1 |  | 8703 |  | 15.7 |  | 2698 |  | 17 |  | 3367
November | 14 |  | 12784 |  | 13.9 |  | 7205 |  | 16 |  | 2988 |  | 17.7 |  | 4199
December | 14.1 |  | 11332 |  | 13.8 |  | 9947 |  | 16.1 |  | 3831 |  | 17.5 |  | 4677
January | 14.4 |  | 13973 |  | 13.6 |  | 9455 |  | 15 |  | 4720 |  | 17.8 |  | 5598
February | 14.6 |  | 11895 |  | 13.3 |  | 9926 |  | 15.8 |  | 2134 |  | 16.5 |  | 3629
March | 14.7 | 1/ |  |  | 13 |  | 10050 |  | 16.8 | 1/ |  |  | 16.5 |  | 4632
April |  |  |  |  | 13.3 |  | 9432 |  |  |  |  |  | 17.2 |  | 3879
May |  |  |  |  | 13.3 |  | 9698 |  |  |  |  |  | 16.5 |  | 3429
June |  |  |  |  | 13.5 |  | 7129 |  |  |  |  |  | 15.8 |  | 3381
July |  |  |  |  | 13.5 |  | 8037 |  |  |  |  |  | 16.6 |  | 3343
Average to date 2/ | 14.1875 |  |  |  |  |  |  |  | 16.225
Season-average farm price | 14.5 | 3/ |  |  | 13.4 |  |  |  | 15.9 | 3/ 4/ |  |  | 17.1
Average marketings |  |  | 11311.57142857143 |  |  |  | 9102.916666666666 |  |  |  | 2929.857142857143 |  |  |  | 3718.25
Total volume marketed |  |  | 79181 |  |  |  | 109235 |  |  |  | 20509 |  |  |  | 44619
N/A = Not available.  1/  Mid-month only.  2/ Simple average. 3/ Forecast.
4/ The medium/short-grain season-average- farm price ([NAME]) largely reflects rice that is marketed through
price pools in California. The pool price is not final until all the rice in the pool is marketed for the crop year.
Therefore, [NAME] forecasts based on the average of NASS monthly prices and the final price may differ.
Source: Monthly cash price and marketings, Agricultural Prices, National Agricultural Statistics Service, USDA.
Last updated April 10, 2013.
Spreadsheet: 96432d1295837101-lookup-function-help-weeklysalestotals
Sheet: Worksheet 1

Date | Product | Sold
2011-01-01 00:00:00 | widgets | 1
2011-01-02 00:00:00 | wadets | 2 |  |  |  | week ending date | 2011-01-17 00:00:00
2011-01-03 00:00:00 | oopums | 3
2011-01-04 00:00:00 | thingamabobs | 4
2011-01-05 00:00:00 | widgets | 5 |  |  |  | widgets
2011-01-06 00:00:00 | wadets | 6 |  |  |  | wadets
2011-01-07 00:00:00 | oopums | 7 |  |  |  | oopums
2011-01-08 00:00:00 | thingamabobs | 8 |  |  |  | thingamabobs
2011-01-09 00:00:00 | widgets | 9
2011-01-10 00:00:00 | wadets | 10
2011-01-11 00:00:00 | oopums | 11 |  |  |  | The cells on this worksheet need to get the data entered on Worksheet 2. Only data for the current week displays on this worksheet.
2011-01-12 00:00:00 | thingamabobs | 12
2011-01-13 00:00:00 | widgets | 13
2011-01-14 00:00:00 | wadets | 14
2011-01-15 00:00:00 | oopums | 15 |  | <<This is called a Table of Data
2011-01-16 00:00:00 | thingamabobs | 16 |  | It is in Rows and Columns with no blank rows or columns
2011-01-17 00:00:00 | widgets | 17 |  | Excel likes this structure - it is called a TABLE
2011-01-18 00:00:00 | wadets | 18 |  | Look at Sheet 2 for one of the many ways to display this data
2011-01-19 00:00:00 | oopums | 19
2011-01-20 00:00:00 | thingamabobs | 20
2011-01-01 00:00:00 | thingamabobs | 1
2011-01-02 00:00:00 | widgets | 2
2011-01-03 00:00:00 | oopums | 3
2011-01-04 00:00:00 | wadets | 4
2011-01-05 00:00:00 | thingamabobs | 5
2011-01-06 00:00:00 | widgets | 6
2011-01-07 00:00:00 | oopums | 7
2011-01-08 00:00:00 | wadets | 8
2011-01-09 00:00:00 | thingamabobs | 9
2011-01-10 00:00:00 | widgets | 10
2011-01-11 00:00:00 | oopums | 11
2011-01-12 00:00:00 | wadets | 12
2011-01-13 00:00:00 | thingamabobs | 13
2011-01-14 00:00:00 | widgets | 14
2011-01-15 00:00:00 | oopums | 15
2011-01-16 00:00:00 | wadets | 16
2011-01-17 00:00:00 | thingamabobs | 17
2011-01-18 00:00:00 | widgets | 18
2011-01-19 00:00:00 | oopums | 19
2011-01-20 00:00:00 | wadets | 20
Spreadsheet: 751556d1634171053-index-match-with-dates-less-than-or-equal-to-sample
Sheet: Sheet1

 | 2021-08-01 00:00:00 | 2021-06-01 00:00:00 | 2021-05-01 00:00:00 | 2021-01-01 00:00:00 | 2020-09-01 00:00:00 | 2020-08-01 00:00:00
Location | 297 | 297 | 297 | 297 | 297 | 297
Ahousat, BC | 3 | 3 | 3 | 3 | 3 | 3
Aklavik, NT | 4 | 4 | 4 | 4 | 4 | 4
Alert, NU | 5 | 5 | 5 | 5 | 5 | 5
[NAME], BC | 2 | 2 | 2 | 2 | 2 | 2
[NAME], BC (incl. [NAME] no 799) | 2 | 2 | 2 | 2 | 2 | 2
Arctic Bay/Ikpiarjuk, NU | 5 | 5 | 5 | 5 | 5 | 5
Arviat, NU | 4 | 4 | 4 | 4 | 4 | 4
Assumption, AB (see Hay Lake Reserve)
Atikameg, AB
[NAME], BC | 2 | 2 | 2 | 2 | 2 | 2
Attawapiskat, ON | 3 | 3 | 3 | 3 | 3 | 3
Baie Verte, NL | 2 | 2 | 2 | 2 | 2 | 2
[NAME], NU | 4 | 4 | 4 | 4 | 4 | 4
[NAME]'s Harbour, NL | 3 | 3 | 3 | 3 | 3 | 3
Spreadsheet: 166984d1341858285-vlookup-from-set-ranges-one-below-the-other-book1
Sheet: sheet1

bob
 | aaa | 12
 |  |  |  |  |  |  | match |  | aaa | bbb | [NAME]
 | bbb | 13 |  |  |  |  |  | bob
 |  |  |  |  |  |  |  | [NAME]
 | [NAME] | 45 |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Sofi
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
[NAME] |  |  |  |  |  |  |  | xx
 | aaa | 675 |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 | bbb | 65 |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 | [NAME] | 75 |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
[NAME] |  |  |  |  |  |  |  | xx
 | aaa | 23 |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 | bbb | 56 |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 | [NAME] | 89 |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  | xx
Sofi
 | aaa | 65
 | bbb | 65
 | [NAME] | 75
[NAME]
 | aaa | 75
 | bbb | 23
 | [NAME] | 23
Spreadsheet: 821574d1678800716-remove-break-times-from-time-ranges-test10
Sheet: Sheet1

Employee | Start_Time | End_Time | Actual | Required |  |  | Shift | Start | End |  | Shift | Start | End |  | Shift | Start | End
Emp1 | 2022-03-14 08:00:14 | 2022-03-14 12:30:00 |  | 04:14:46 |  |  | Patt1 | 08:00:00 | 10:00:00 |  | Patt1 | 10:15:00 | 12:30:00 |  | Patt1 | 13:00:00 | 16:00:00
Emp2 | 2022-03-14 08:01:00 | 2022-03-14 14:00:00 |  | 05:13:00 |  |  | Patt2 | 08:00:00 | 10:15:00 |  | Patt2 | 10:30:00 | 13:00:00 |  | Patt2 | 13:30:00 | 16:00:00
Emp3 | 2022-03-14 10:45:00 | 2022-03-14 16:00:00 |  | 04:45:00 |  |  | Patt3 | 08:00:00 | 10:30:00 |  | Patt3 | 10:45:00 | 13:30:00 |  | Patt3 | 14:00:00 | 16:00:00
 |  |  |  |  |  |  | Employee List | Shift
 |  |  |  |  |  |  | Emp1 | Patt1
 |  |  |  |  |  |  | Emp2 | Patt2
 |  |  |  |  |  |  | Emp3 | Patt3
Spreadsheet: 865228d1712270248-count-number-of-days-of-the-month-entered-in-a-column-count-days-example-01
Sheet: Sheet1

 | 1900-01-01 00:00:00 | 1900-01-02 00:00:00 | 1900-01-03 00:00:00 | 1900-01-04 00:00:00 | 1900-01-05 00:00:00 | 1900-01-06 00:00:00 | 1900-01-07 00:00:00 | 1900-01-08 00:00:00 | 1900-01-09 00:00:00 | 1900-01-10 00:00:00 | 1900-01-11 00:00:00 | 1900-01-12 00:00:00 | 1900-01-13 00:00:00 | 1900-01-14 00:00:00 | 1900-01-15 00:00:00 | 1900-01-16 00:00:00 | 1900-01-17 00:00:00 | 1900-01-18 00:00:00 | 1900-01-19 00:00:00 | 1900-01-20 00:00:00 | 1900-01-21 00:00:00 | 1900-01-22 00:00:00 | 1900-01-23 00:00:00 | 1900-01-24 00:00:00 | 1900-01-25 00:00:00 | 1900-01-26 00:00:00 | 1900-01-27 00:00:00 | 1900-01-28 00:00:00 | 1900-01-29 00:00:00 | 1900-01-30 00:00:00 | 1900-01-31 00:00:00
 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <EXPECTED RESULTS
DATE
2024-02-01 00:00:00
2024-02-14 00:00:00
2024-03-01 00:00:00
2024-03-10 00:00:00
Spreadsheet: 851723d1701879892-estimate-extended-data-based-on-known-information-worksheet
Sheet: 202311

 | 0.3 | 0.5 | 0.7 | 1 | 2.5 | 5 | 10 | 20 | 50 | 100 | Intercept | Slope
2023-11-27 00:00:00 | 2674690 | 2007590 | 1027630 | 369910 | 14530 | 3070 | 600
2023-11-27 00:00:00 | 2607740 | 1939980 | 976910 | 347100 | 13520 | 3130 | 560
2023-11-27 00:00:00 | 2541237 | 1870653 | 919235 | 318450 | 11835 | 2502 | 334
2023-11-27 00:00:00 | 2527929 | 1859940 | 914320 | 316620 | 11410 | 2240 | 350
2023-11-27 00:00:00 | 2471570 | 1803652 | 871416 | 297139 | 10944 | 2350 | 415
2023-11-27 00:00:00 | 2462610 | 1801130 | 865480 | 290500 | 10080 | 2070 | 309
2023-11-27 00:00:00 | 780834 | 517742 | 208280 | 59432 | 1722 | 304 | 30
2023-11-27 00:00:00 | 738480 | 486640 | 193520 | 55670 | 1540 | 230 | 20
2023-11-27 00:00:00 | 1689165 | 1182489 | 520650 | 160907 | 4823 | 719 | 101
2023-11-27 00:00:00 | 1670080 | 1166380 | 512820 | 158430 | 4959 | 870 | 200
2023-11-27 00:00:00 | 841694 | 561771 | 229884 | 68369 | 2128 | 293 | 20
2023-11-27 00:00:00 | 715220 | 473570 | 193450 | 57790 | 1930 | 360 | 50
2023-11-27 00:00:00 | 15260 | 9342 | 3810 | 1155 | 81 | 20 | 0
2023-11-27 00:00:00 | 12700 | 8189 | 3060 | 950 | 0 | 0 | 0
2023-11-27 00:00:00 | 543116 | 442968 | 298568 | 176624 | 14440 | 1763 | 243
2023-11-27 00:00:00 | 499400 | 441889 | 330940 | 207960 | 16210 | 1920 | 200
2023-11-27 00:00:00 | 712494 | 603764 | 414301 | 230827 | 15240 | 1661 | 324
2023-11-27 00:00:00 | 721230 | 620010 | 430220 | 237990 | 15590 | 1740 | 180
2023-11-27 00:00:00 | 525788 | 410957 | 252988 | 133263 | 8907 | 1053 | 172
2023-11-27 00:00:00 | 459270 | 369390 | 236750 | 127120 | 8480 | 1040 | 270
2023-11-27 00:00:00 | 379057 | 210874 | 75645 | 24988 | 861 | 70 | 10
2023-11-27 00:00:00 | 426450 | 242740 | 90690 | 30020 | 990 | 160 | 10
Spreadsheet: 688190d1595609597-using-index-to-find-matches-across-multiple-worksheets-with-multiple-matches-test1
Sheet: Sheet5

FRUIT | PRICE | QUALITY
APPLE | 10 | 4342
GRAPE | 11 | 5453
ORANGE | 12 | 6453
APPLE | 13 | 3566
PEACH | 14 | 4654
ORANGE | 15 | 7365
APPLE | 16 | 3456
PEACH | 17 | 7534
Spreadsheet: 94257d1294128389-lookup-specific-values-according-to-unique-reference-replace-if-necessary-exportkeyed
Sheet: PDCGrade

Key | PDCGrade | Ingredient | LowerLimit | UpperLimit | LowerSecLimit | UpperSecLimit
 | JU12A | [NAME] | 4.44 | 5.66
 | JU12A | MANGANESE | 3.21 | 4
 | KU32A | MOLYBDENUM | 4.76 | 7
 | KU32A | NICKEL | 6.54 | 9
 | KU32A | PHOSPHORUS | 3.65 | 5 | 7 | 9
 | KU32A | SILICON | 4.55 | 7
 | KU32A | SULPHUR | 7.66 | 9
 | KU32A | TENSILE | 11.65 | 14 | 6.66 | 13.55
 | KU32A | TENSILE | 8.67 | 10
 | KU32A | ALUMINIUM | 4.44 | 6 | 5 | 9
 | KU32A | CARBON | 3.33 | 5
 | KU32A | [NAME] | 6.66 | 8
 | KU32A | COPPER | 7.77 | 10
 | KU32A | HBW | 8.88 | 11
 | KU32A | SILICON | 9.99 | 12
Spreadsheet: 357059d1415291405-vlookup-to-show-multile-values-in-one-cell-november_dashboard
Sheet: Dashboard 11(10-14)

 | Monday targets |  |  |  |  | Tuesday |  |  |  |  | Wednesday |  |  |  |  | Thursday |  |  |  |  | Friday
 | Bulk |  | Route |  |  | Bulk |  | Route |  |  | Bulk |  | Route |  |  | Bulk |  | Route |  |  | Bulk |  | Route
 | Stacker Actual |  | Stacker Actual |  |  | Stacker Actual |  | Stacker Actual |  |  | Stacker Actual |  | Stacker Actual |  |  | Stacker Actual |  | Stacker Actual |  |  | Stacker Actual |  | Stacker Actual
 | CPH | CASES | CPH | CASES |  | CPH | CASES | CPH | CASES |  | CPH | CASES | CPH | CASES |  | CPH | CASES | CPH | CASES |  | CPH | CASES | CPH | CASES
[NAME] (0360)
[NAME] (0513)
[NAME] (0684)
[NAME] (1618)
[NAME] (2746)
[NAME] (3286)
[NAME] (4518)
[NAME] (5948)
[NAME] (7643)
[NAME] (7661)
[NAME] (7947)
[NAME] (9177)
[NAME] (9223)
Donnie Justice (9330)
[NAME] (9336)
Brent Pickard (9657)
[NAME] (9201)
Spreadsheet: 3a0f910b-b842-483d-bed8-6050b34b6c6c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
2869 | 15817 | Paolo | [NAME] | ITA | 264 | 00:12:52 | 00:00:58 | 00:32:52 | 00:01:45 | 00:25:01 | 1 | 01:13:28
2869 | 15684 | Giovanni | [NAME] | ITA | 266 | 00:18:54 | 00:00:55 | 00:48:50 | 00:03:02 | 00:33:50 | 2 | 01:45:31
2869 | 15754 | Mauro | De Biaggi | ITA | 265 | 00:16:03 | 00:00:47 | 00:47:43 | 00:02:44 | 00:41:54 | 3 | 01:49:11
2869 | 10327 | Eelke | Wijnia | NED | 267 | 00:18:11 | 00:01:55 | 00:48:14 | 00:00:57 | 00:40:15 | 4 | 01:49:32
2869 | 10329 | Curt | Maier | AUT | 268 | [NAME] | 00:01:27 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 0812e157-c927-4072-9e79-994e01b1411f
Sheet: SHATSKY RISE RANGE TABLE

 |  |  |  |  |  |  |  | Abathomphalus intermedius | Abathomphalus mayaroensis | Archaeoglobigerina blowi | Archaeoglobigerina cretacea | Contusotruncana contusa | Contusotruncana fornicata | Contusotruncana patelliformis | Contusotruncana plummerae | Contusotruncana walfischensis | Gansserina gansseri | [NAME] wiedenmayeri | Globigerinelloides multispinus | Globigerinelloides prairiehillensis | Globigerinelloides subcarinatus | Globigerinelloides volutus | [NAME] aegyptiaca | [NAME] arca | [NAME] bulloides | [NAME] falsostuarti | [NAME] hilli | [NAME] linneiana | [NAME] mariei | [NAME] orientalis | [NAME] rosetta | [NAME] ventricosa | Globotruncanella havanensis | Globotruncanella petaloidea | Globotruncanella pschadae | [NAME] insignis | Globotruncanita pettersi | Globotruncanita stuarti | Globotruncanita stuartiformis | Gublerina cuvillieri | Hedbergella holmdelensis | [NAME] monmouthensis | Heterohelix globulosa | Heterohelix planata | Heterohelix punctulata | Kuglerina rotundata | Laeviheterohelix glabrans | Laeviheterohelix dentata | Laeviheterohelix pulchra | Planoglobulina acervulinoides | Planoglobulina carseyae | Planoglobulina multicamerata | Planoglobulina riograndensis | Praegublerina acuta | Pseudoguembelina costulata | Pseudoguembelina excolta | Pseudoguembelina kempensis | Pseudoguembelina palpebra | Pseudotextularia elegans | Pseudotextularia intermedia | Pseduotextularia nuttali | Racemiguembelina fructicosa | Racemioguembelina powelli | Radotruncana calcarata | Radotruncana subspinosa | Rugoglobigerina hexacamerata | Ruogoglobigerina rugosa
Spreadsheet: mark_haedicke__24650__SUMMARY
Sheet: summary

MARINER ENERGY, INC.
APPENDIX
WEEKLY DRILLING AND COMPLETION SUMMARY
 |  |  |  |  |  |  |  |  |  |  |  |  | PRESENT |  | PROPOSED
 |  |  | PROSPECT |  | AREA |  | WELL |  | E/D |  | [NAME] |  | DEPTH |  | TD |  | COMMENT
 | I. |  | WELLS CURRENTLY DRILLING
 |  |  | Green Canyon 136 |  | Deepwater |  | OCS-G 4508 #8 |  | D |  | 0.25 |  | 4,913' |  | 7,600' |  | Drilling.
 |  |  | (Shasta)
 |  |  | South Timbalier 316 |  | Deepwater |  | OCS-G #1 |  | E |  | 0.2 |  | 9.750' |  | 13,500' |  | Drilling.
 | II. |  | WELLS REACHING TOTAL DEPTH, TESTING, OR TURNED TO SALES THIS WEEK
 |  |  | Green Cayon 516 |  | Deepwater |  | OCS-G 20074 #1 |  | E |  | 0.5 |  |  |  |  |  | Completed.
 |  |  | (Yosemite)
 | III. |  | WELLS ANTICIPATED TO SPUD WITHIN 90 DAYS
 |  |  | [NAME] 962 |  | Deepwater |  | OCS-G #1 |  | E |  | 0.15 |  |  |  | 4,478' |  | Expected spud date first week November
 |  |  | (Swordfish) |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001
 |  |  | Visoca Knoll 962 |  | Deepwater |  | OCS-G #2 |  | E |  | 0.15 |  |  |  | 3,835' |  | Expected spud date  mid December 2001.
 |  |  | (Swordfish)
 |  |  | Mississippi Canyon 205 |  | Deepwater |  | OCS-G #1 |  | E |  | 0.25 |  |  |  | 3,500' |  | Expected spud date mid December 2001.
 |  |  | (Piston)
 | IV. |  | OTHER
 |  |  | None to report.
Spreadsheet: 296958d1392238993-importing-excel-sheet-fields-into-separate-excel-based-invoice-sample_billing_listing
Sheet: Vecmar Invoice

Order # | [NAME] To: | [NAME] | Address 2 | [NAME] to City | [NAME] to State | [NAME] to Zip | [NAME] to Contact | Last Name | [NAME] to Phone # | [NAME] | Ship To | Ship to Address | Address 2 | Ship to City | Ship to State | Ship to Zip | [NAME] to Contact | Product ID | Serial # | Ship Date
order# | Company | Address |  | City | ST | 0 | Name | Lastname | [PHONE] | [EMAIL] | Company | Address |  | City | ST | 0 | Billing Name | product | serial | 2012-10-01 00:00:00
Spreadsheet: 24153d1214267398-report-a-list-line-by-line-based-on-name-criteria-example-bonus
Sheet: Installer1

 |  |  |  |  |  |  |  |  |  | Bonuses for Jan-00 through Jan-00
 |  |  |  |  |  |  |  | Bonuses and commissions for: |  |  | [NAME]
 |  |  |  |  |  |  |  | Total of commissions and Bonuses:
 | Dealer Name | Dates of Install | Employee | Type | Bonus | Mod. % | Module | Sales | Custom | Pos. Days | Days | Total
#N/A | #N/A
#N/A | #N/A
3 | 0
4 | 0
5 | 0
6 | 0
Spreadsheet: 40075d1238413295-find-and-sort-data-test
Sheet: Sheet1

CN | 100 |  |  |  | CN
DE | 250 |  |  |  | DE
US | 299 |  |  |  | US
CN | 890
CN | 240
DE | 100
US | 955
Spreadsheet: 722086d1615035135-truncating-an-array-in-a-countifs-truncating-an-array-in-a-countifs
Sheet: Sheet1

NUM | ALFA |  | 2 | q |  | [NAME] | 1
1.487 | w |  |  |  |  | [NAME] | w
1.83 | q |  |  |  |  | Count results
2.269 | w
1.715 | q
2.155 | w
2.313 | q
3.586 | w
1.82 | w
3.185 | w
3.849 | q
3.105 | w
3.392 | q
2.251 | w
3.543 | q
2.611 | w
2.493 | q
3.673 | w