tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: cd0586ec-2522-429b-a0f5-d5d0a1a95654
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25
 | Player and Team Totals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Game 1 | Game 2 | Game 3 | Game 4 | Game 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Polson |  |  |  |  | 25 | 25 | 28
Date: | 2011-10-06 00:00:00 |  |  |  |  |  |  | mailto:[EMAIL] |  |  |  |  |  |  |  | @ [NAME] |  |  |  |  | 21 | 20 | 26
 |  | Gm | Serving |  |  |  |  | Attacking |  |  |  |  | Set |  | Blocks |  |  |  |  | Receptions
# | Player Name | P | Att. | Aces | [NAME]. | % | Ace/G | TA | Kills | [NAME]. | % | Kill/G | Asst. | Ast/G | Solo | Asst. | Blk/G | [NAME] | Dig/G | total attmps | on target | off target | play     able | errors | ratio
 | [NAME]
1L/3 | MacKenzie Banner | 3 |  |  |  |  | 0 | 1 | 1 |  | 1 | 0.3333333333333333 |  | 0 |  |  | 0 | 14 | 4.666666666666667 | 0
2 | [NAME] | 3 | 13 | 3 |  | 1 | 1 | 24 | 12 | 1 | 0.4583333333333333 | 4 |  | 0 |  |  | 0 | 7 | 2.333333333333333 | 0
3/1L | Macall  Banner | 3 | 7 | 2 |  | 1 | 0.6666666666666666 |  |  |  |  | 0 |  | 0 |  |  | 0 | 9 | 3 | 0
4 | Kenzie Clay | 3 | 11 | 3 | 1 | 0.9090909090909091 | 1 | 17 | 4 | 2 | 0.1176470588235294 | 1.333333333333333 |  | 0 | 1 |  | 0.3333333333333333 | 4 | 1.333333333333333 | 0
5 | [NAME] | 1 | 3 | 1 |  | 1 | 1 |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 | 0
6 | [NAME] | 1 |  |  |  |  | 0 | 4 | 2 | 1 | 0.25 | 2 |  | 0 | 1 |  | 1 |  | 0 | 0
7 | Jaiden Toth |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
8 | Chelsea Chowning | 3 | 3 | 0 | 2 | 0.3333333333333333 | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 | 0
9 | [NAME] | 3 | 14 | 1 | 1 | 0.9285714285714286 | 0.3333333333333333 | 7 | 2 | 1 | 0.1428571428571428 | 0.6666666666666666 | 36 | 12 |  |  | 0 | 14 | 4.666666666666667 | 0
10 | [NAME] | 3 | 16 | 3 | 1 | 0.9375 | 1 | 22 | 8 | 4 | 0.1818181818181818 | 2.666666666666667 |  | 0 | 2 |  | 0.6666666666666666 |  | 0 | 0
11 | [NAME] | 3 |  |  |  |  | 0 | 14 | 8 | 1 | 0.5 | 2.666666666666667 |  | 0 | 3 |  | 1 | 9 | 3 | 0
12 | [NAME] | 3 | 2 | 0 | 1 | 0.5 | 0 | 14 | 5 | 2 | 0.2142857142857143 | 1.666666666666667 | 2 | 0.6666666666666666 | 1 |  | 0.3333333333333333 | 11 | 3.666666666666667 | 0
14 | [NAME] | 1 | 1 |  |  | 1 | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 |  | 0 | 0
13 | Courtney Mccreary |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Team Totals | 3 | 70 | 13 | 6 | 0.9142857142857143 | 4.333333333333333 | 103 | 42 | 12 | 0.2912621359223301 | 14 | 38 | 12.66666666666667 | 8 | 0 | 2.666666666666667 | 68 | 22.66666666666667 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 165547d1341261297-excel-2007-return-a-value-based-on-a-list-book1
Sheet: Sheet1

Software Name | Version | Count
.NET Framework Enterprise Code Access Security Policy | 1.0.2411.0 | 13 |  |  | .Net
.NET Framework Machine Code Access Security Policy | 1.0.2411.0 | 1 |  |  | prompt Professional
@promt Professional 7 ESSE | 7.0.00015 | 1 |  |  | 1-Wire
@promt Professional ESSE Try-Buy | 6.5.00003 | 1
010 Editor 3.0.5 | Unknown | 1
1&1 EasyLogin | Unknown | 2
1 | Unknown | 1
123 Free Solitaire | 123 Free Solitaire 2004 | 1
123Scan | 1.00.0000 | 3
123Scan | 1.03.00 | 1
123SCAN v 1.0.2.0 | 1.00.0000 | 1
123Scan v2.1 | 2.1.0.1 | 1
1300 | 43.0.217.000 | 1
1300_Help | 43.0.217.000 | 1
1300Tour | 43.0.217.000 | 1
1300Trb | 43.0.217.000 | 1
1310 SimPoser B Version 1.1.0 | Unknown | 2
1400 | 47.0.1.000 | 4
1400 | 50.0.206.000 | 2
1400_Help | 47.1.14.000 | 5
1400_Help | 50.0.206.000 | 2
1400Trb | 47.1.14.000 | 5
1400Trb | 50.0.206.000 | 2
1500 | 47.0.1.000 | 1
1500 | 50.0.206.000 | 1
1500_Help | 50.0.206.000 | 1
1500_Help | 47.1.14.000 | 1
1500Trb | 50.0.206.000 | 1
1500Trb | 47.0.1.000 | 1
1600 | 47.0.1.000 | 5
1600_Help | 47.0.1.000 | 2
1600_Help | 47.1.14.000 | 3
1600Trb | 47.1.14.000 | 3
1600Trb | 47.0.1.000 | 2
16AMP - S-Line Solid End Cap Sanitary | 1.0.0 | 1
1SYNC-SLT v7.5 | 7.5 | 1
1-Wire Drivers | 4.0.0 | 138
1-Wire drivers for Windows XP and Vista | 4.01.3 | 1
Spreadsheet: 770889d1646322429-multiple-lookup-results-multiple-outputs-index-match
Sheet: Sheet1

ID_PERIOD | DIR | QUANTITY | PRICE | MINQUANTITY | half hour |  |  |  | [NAME] |  | item2
 |  |  |  |  |  |  |  | period | quantity | price | quantity | price
2022-03-02 00:00:00 | Up | 125 | 295.45 | 0 | 1 |  |  | 1 | 49 |  | 125
2022-03-02 00:00:00 | Up | 125 | 245.85 | 0 | 1 |  |  | 2 | 49 |  | 125
2022-03-02 00:00:00 | Up | 125 | 275.45 | 0 | 1 |  |  | 3 | 49 |  | 125
2022-03-02 00:00:00 | Up | 288.4 | 4200 | 0 | 1
2022-03-02 00:00:00 | Up | 49 | 299.82 | 0 | 1
2022-03-02 00:00:00 | Up | 49 |  | 0 | 1
2022-03-02 00:00:00 | Up | 49 |  | 0 | 1
2022-03-02 00:00:00 | Up | 49 |  | 0 | 1
2022-03-02 00:00:00 | Up | 49 | 1200 | 0 | 1
2022-03-02 00:00:00 | Up | 125 | 295.45 | 0 | 2
2022-03-02 00:00:00 | Up | 125 | 245.85 | 0 | 2
2022-03-02 00:00:00 | Up | 125 | 275.45 | 0 | 2
2022-03-02 00:00:00 | Up | 288.4 | 4200 | 0 | 2
2022-03-02 00:00:00 | Up | 49 | 299.82 | 0 | 2
2022-03-02 00:00:00 | Up | 49 | 289.82 | 0 | 2
2022-03-02 00:00:00 | Up | 49 | 279.82 | 0 | 2
2022-03-02 00:00:00 | Up | 49 | 269.82 | 0 | 2
2022-03-02 00:00:00 | Up | 49 | 1200 | 0 | 2
2022-03-02 00:00:00 | Up | 125 | 295.45 | 0 | 3
2022-03-02 00:00:00 | Up | 125 | 245.85 | 0 | 3
2022-03-02 00:00:00 | Up | 125 | 275.45 | 0 | 3
2022-03-02 00:00:00 | Up | 288.4 | 4200 | 0 | 3
2022-03-02 00:00:00 | Up | 49 | 299.82 | 0 | 3
2022-03-02 00:00:00 | Up | 49 | 289.82 | 0 | 3
2022-03-02 00:00:00 | Up | 49 | 279.82 | 0 | 3
2022-03-02 00:00:00 | Up | 49 | 269.82 | 0 | 3
2022-03-02 00:00:00 | Up | 49 | 1200 | 0 | 3
Spreadsheet: 841102d1693349275-need-to-populate-a-cell-based-on-the-contents-of-a-dropdown-cell-excel-question-sample
Sheet: DAR

Status | DAR Number | Submitter | Date | USER 1 | USER 2 | Department | Fund | Source Code | Function | Purpose | Project | Activity | Vendor | Amount | Form Type | PS ID | Description | Supporting Docs | Supporting Docs2 | Reconciliation Comments
 |  |  |  |  | ADOSP
 |  |  |  |  | DSPRO |  |  |  |  | 20009
 |  |  |  |  | AGSPE |  |  |  |  | 20026
 |  |  |  |  | PRS&S |  |  |  |  | 20022
Spreadsheet: 727087d1617710932-data-bar-in-table-for-text-or-alternative-suggestion-eh_account-plan-tracker_ray
Sheet: Sheet1

 | Account plan exists? | To do Account Plan | Status | Occurrence of meetings | Main point of contact | Time spent
Account 1 | Yes | Yes |  |  |  | 1 | In progress
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1
 |  |  |  |  |  | 2
 |  |  |  |  |  | 2
 |  |  |  |  |  | 2
 |  |  |  |  |  | 2
 |  |  |  |  |  | 2
 |  |  |  |  |  | 2
 |  |  |  |  |  | 2
 |  |  |  |  |  | 2
 |  |  |  |  |  | 2
 |  |  |  |  |  | 3
 |  |  |  |  |  | 3
 |  |  |  |  |  | 3
 |  |  |  |  |  | 3
 |  |  |  |  |  | 3
 |  |  |  |  |  | 3
 |  |  |  |  |  | 3
 | .
Spreadsheet: 5b54d4d0-2061-49be-9a13-d6f202cb85f1
Sheet: Sheet1

Judgeship Number 5 - NON (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 5/21/2013 2:30:01 PM
Precincts Reporting: 663/663 - Total Ballots Cast: 128519
2002 Primary Election - OFFICIAL RESULTS
Precinct | [NAME] | [NAME] | TOTALS
Combined Precinct | 1940 | 513 | 2453
TOTAL | 1940 | 513 | 2453
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 703376d1604959049-copy-and-paste-a-sum-formula-but-change-column-reference-to-a-specific-column-example-summary
Sheet: Detailed Info

Activity | Total Price | Net Margin % | Net Margin £ | Other Fees | Gross Margin % | Gross Margin £ | Total Cost | Labour | Materials
Work Package 1
WP1.1 |  |  |  | 20 | 0.25 |  |  | 100 | 100
WP1.2 |  |  |  | 20 | 0.25 |  |  | 100 | 100
WP1.3 |  |  |  | 20 | 0.25 |  |  | 100 | 100
WP1.4 |  |  |  | 20 | 0.25 |  |  | 100 | 100
WP1.5 |  |  |  | 20 | 0.25 |  |  | 100 | 100
Work Package 2
WP2.1 |  |  |  | 20 | 0.25 |  |  | 100 | 200
WP2.2 |  |  |  | 20 | 0.25 |  |  | 100 | 200
WP2.3 |  |  |  | 20 | 0.25 |  |  | 100 | 200
WP2.4 |  |  |  | 20 | 0.25 |  |  | 100 | 200
WP2.5 |  |  |  | 20 | 0.25 |  |  | 100 | 200
Spreadsheet: 266733d1379705825-30-files-received-type-data-all-different-but-needs-to-be-counted-as-the-same-in-1-sheet-30-files-received-type-classifacation-all-different
Sheet: Raw Data Received Type

Center | Received Type Labels
Costa Rica File | Received Fruit | Received Meat | Received Dairy | Received Drinks
Mexico File | Received Pepsi | Received Coca Cola | Received Turkey | Received Apples | Received Drinks | Received Coca Cola
Switzerland File | Fruit | Meat | Dairy | Drinks
Information of Importance |  |  |  |  |  | Unique Received Type | Received Standardized
1. Each center has an individual excel file that consists of the data type as found in Raw Data. |  |  |  |  |  | Received Fruit | Received Fruit
2. Each center then has a pivot table with [NAME]( Received) |  |  |  |  |  | Received Meat | Received Meat
3.Their are 30+ files with multiple years of data in each sheet. |  |  |  |  |  | Received Dairy | Received Dairy
4. The Received Type is not the same format from one file to the next. |  |  |  |  |  | Received Drinks | Received Drinks
Center #1= Costa Rica |  |  |  |  |  | Received Pepsi | Received Drinks
 |  |  |  |  |  | Received Coca Cola | Received Drinks
The ideal format I want is as follows |  |  |  |  |  | Received Turkey | Received Meat
 |  |  |  |  |  | Received Apples | Received Fruit
Center # | Date | Received Fruit | Received Meat | Received Dairy | Received Drinks | Received Drinks | Received Drinks
1 | 2013-09-05 00:00:00 | 3 | 0 | 0 | 0 | Received Coca Cola | Received Drinks
1 | 2013-09-06 00:00:00 | 0 | 2 | 3 | 0 | Fruit | Received Fruit
 |  |  |  |  |  | Meat | Received Meat
So I need to find the best way to have all unique Received Standardized counted by day for each center.  Knowing there are 30+ files where the received type are different.  So fruit would = received fruit. Dairy should be counted as received dairy. etc |  |  |  |  |  | Dairy | Received Dairy
 |  |  |  |  |  | Drinks | Received Drinks
 |  |  |  |  |  | Unique Received Standardized
 |  |  |  |  |  | Received Fruit
 |  |  |  |  |  | Received Meat
 |  |  |  |  |  | Received Dairy
 |  |  |  |  |  | Received Drinks
Spreadsheet: 58637d1258899620-sumif-two-columns-meet-criteria-testsmith
Sheet: Sheet1

Client | Event Type | Amount |  |  | Client | Event Type | Amount
Smith | Golf European | 2000 |  |  | Smith | Golf European | 15000
Jones | Football Domestic | 1000
Smith | Football Domestic | -3000
Jones | Cricket Domestic | -4000
Jones | Football Domestic | -1000
Smith | Golf European | -3000 |  |  |  | Input what is needed …
[NAME] | Cricket Domestic | 1000
[NAME] | Football Domestic | 4000
[NAME] | Football Domestic | -3000
Smith | Golf European | 2000
Smith | Football Domestic | -2000
Smith | Golf European | 4000
Jones | Cricket Domestic | 3000
Smith | Football Domestic | 2000
Jones | Cricket Domestic | 2000
Smith | Golf European | 10000
Spreadsheet: 389247-skipping-a-blank-field-sample
Sheet: Volunteers - As I need

Name | Last Initial | Service Prior | Service At
Spreadsheet: 887722d1738054684-merging-data-from-multiple-workbooks-sorting-alphabetically-creating-new-workbooks-workbook-example-2-to-merge
Sheet: P2 Blending

Rm | Surname | First Name | Oral Blending
 |  |  | m-a-n | c-u-p | p-e-g | h-u-g | f-i-b | s-o-ck
2 | Circle | [NAME] | 1 | 1 | 1 | 1 | 1 | 1
2 | Square | Immy | 1 | 1 | 1 | 1 | 1 | 1
2 | Hexagon | [NAME] | 1 | 1 | 1 | 1 | 1 | 1
2 | Rectangle | [NAME] | 1 | 1 | 1 | 1 | 1 | 1
2 | Triangle | [NAME] | 1 | 1 | 1 | 1 | 1 | 1
2 | Rhombus | [NAME] | 1 | 1 | 1 | 1 | 1 | 1
2 | Star | April | 1 | 1 | 1 | 1 | 1 | 1
2 | Octagon | [NAME] | 1 | 1 | 1 | 1 | 1 | 1
2 | Decagon | Sonya | 1 | 1 | 1 | 1 | 1 | 1
2 | Cube | Michelle | 1 | 1 | 1 | 1 | 1 | 1
2 | Cylinder | [NAME] | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 28189d1222182613-gathering-and-listing-data-from-another-sheet-copy-of-master-file-1-
Sheet: Loadout

MPLO  number |  |  | 558 |  |  |  |  |  |  |  | ED Numbers
Container  Number |  |  | MSKU 3402539 |  |  |  |  |  |  |  | PH206 / 416
 |  |  |  |  |  |  |  |  |  |  | ME69 / 239929
Contract Number |  |  | SM 1091 |  |  |  |  |  |  |  | PF161 / 380
[NAME] Weight |  |  | 20221
Packaging Weight
Croft's Weight
[NAME]    From |  |  | 236-5 |  | To |  | 237-2
Production Start  Date |  |  | 2008-06-30 00:00:00 |  | Finish Date |  | 2008-08-06 00:00:00
[NAME]
Comments
Spreadsheet: d3f17b3c-d66e-469c-b1e9-5533e9ae1fea
Sheet: Sheet1

WeGreen Nachhaltigkeits-Ranking: Bekannteste Unternehmen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Branche Arzneimittel
[NAME] am 24.05.2013
Rang | Unternehmen | Farbe | Note | Bewertung
1 | Baxter | grün | 2.1 | gut
2 | [NAME] | grün | 2.1 | gut
3 | Abbott Laboratories | grün | 2.2 | gut
4 | Eli Lilly | grün | 2.2 | gut
5 | Johnson & Johnson | grün | 2.4 | [NAME]
6 | Amgen | grün | 2.5 | [NAME]
7 | AstraZeneca | gelb | 2.7 | mittelmäßig
8 | Roche | gelb | 2.9 | mittelmäßig
9 | Sanofi-Aventis | gelb | 2.9 | mittelmäßig
10 | Bristol-Myers Squibb | gelb | 3 | mittelmäßig
11 | Lanxess | gelb | 3.4 | mittelmäßig
12 | Procter & Gamble | gelb | 3.5 | mittelmäßig
13 | Bayer | gelb | 3.6 | schwach
14 | [NAME] | gelb | 3.6 | schwach
15 | Boehringer Ingelheim | gelb | 4 | schwach
16 | Fresenius Medical Care | gelb | 4.1 | schwach
17 | Novartis | gelb | 4.1 | schwach
18 | [NAME] | gelb | 4.1 | schwach
19 | Pfizer | gelb | 4.1 | schwach
 |  |  | 3.131578947368421
Das Ranking aller Unternehmen finden Sie im zweiten und dritten Tabellenblatt. [NAME] ausschließlich unter [NAME] der [NAME].
Spreadsheet: 736018d1623321207-formula-if-for-empty-value-if
Sheet: Sheet1

 | It should be on this column the formula with the examples:
1 | 5
1 | 5
1 | 5
1 | 5
1 | 5
 | -10
1 | 5
1 | 5
 | -10
1 | 5
 | -10
 | -10
 | -10
1 | 5
1 | 5
1 | 5
1 | 5
1 | 5
Spreadsheet: 108522d1305578968-excel-2007-dynamic-column-and-array-book10
Sheet: Sheet1

 | MONTH | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | [NAME] | [NAME] | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0
 | dju | dju | dju | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0
 | djy | djy | djy | djy | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0
 | dsp | dsp | dsp | dsp | dsp | dsp | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0
 | doc | doc | doc | doc | doc | doc | doc | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0
 | dnv | dnv | dnv | dnv | dnv | dnv | dnv | dnv | PLAN0 | PLAN0 | PLAN0 | PLAN0
 | ddc | ddc | ddc | ddc | ddc | ddc | ddc | ddc | ddc | PLAN0 | PLAN0 | PLAN0
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | PLAN0 | PLAN0
 | dfb | dfb | dfb | dfb | dfb | dfb | dfb | dfb | dfb | dfb | dfb | PLAN0
 | MONTH NAME
 | may |  | [NAME] | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0 | PLAN0
 | jan |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | PLAN0 | PLAN0
 | feb |  | dfb | dfb | dfb | dfb | dfb | dfb | dfb | dfb | dfb | dfb | PLAN0
 | [NAME]
 | apr
 | may
 | april
 | jul |  | how to achive this that is highlighted in yellow where
 | feb
 | oct
 | oct
 | nov
 | jan
 | jan
 | feb
 | [NAME]
 | apr
 | may
 | may
 | nov
 | aug
 | sep
 | may
 | nov
 | dec
 | april
 | feb
 | [NAME]
 | apr
 | may
 | jun
 | jul
 | aug
 | sep
 | oct
 | nov
 | dec
 | jan
 | feb
 | [NAME]
 | apr
 | may
 | jun
 | jul
 | aug
 | sep
 | oct
 | nov
 | dec
 | jan
 | feb
 | [NAME]
 | apr
Spreadsheet: 871621d1718046827-large-data-base-final-type-in-same-row
Sheet: Sheet1

Call # | Report # | Call Date | Time | Initial Call Type | Final Call Type | Location | Founded | Cleared By
HS 2020- | 2020-485410 | Jul-27-2020 | 22:51:58 | 303 (THEFT - | 303 (THEFT - | 13721 [NAME], | Yes | NO FURTHER
485410 |  |  |  | EMPLOYEE) | EMPLOYEE) | HILLSBOROUGH COUNTY |  | ACTION REQ'D
HS 2020- | 2020-485395 | Jul-27-2020 | 22:46:33 | 181J (COMMUNITY | 181J (COMMUNITY | 11911 CEDARFIELD DR, HILLSBOROUGH | Yes | NO FURTHER
485395 |  |  |  | CONTROL CHECK | CONTROL CHECK | COUNTY |  | ACTION REQ'D
 |  |  |  | JUVENILE) | JUVENILE)
HS 2020- | 2020-485246 | Jul-27-2020 | 20:40:01 | 13P (SUSPICIOUS | 13P (SUSPICIOUS | 11442 FLORA SPRINGS DR, | Yes | NO FURTHER
 |  |  |  |  | PERSON
CORRECTED
Call # | Report # | Call Date | Time | Initial Call Type | Final Call Type | Location | Founded | Cleared By
HS 2020- | 2020-485410 | Jul-27-2020 | 22:51:58 | 303 (THEFT - | 303 (THEFT -EMPLOYEE | 13721 [NAME], | Yes | NO FURTHER
485410 |  |  |  | EMPLOYEE) |  |  |  | ACTION REQ'D
HS 2020- | 2020-485395 | Jul-27-2020 | 22:46:33 | 181J (COMMUNITY | 181J (COMMUNITY CONTROL CHECK | 11911 CEDARFIELD DR, HILLSBOROUGH | Yes | NO FURTHER
485395 |  |  |  | CONTROL CHECK |  |  |  | ACTION REQ'D
 |  |  |  | JUVENILE)
HS 2020- | 2020-485246 | Jul-27-2020 | 20:40:01 | 13P (SUSPICIOUS | 13P (SUSPICIOUS PERSON | 11442 FLORA SPRINGS DR, | Yes | NO FURTHER
485246 |  |  |  | PERSON) |  |  |  | ACTION REQ'D
Spreadsheet: 46777d1245716798-moving-column-data-to-row-sample1
Sheet: Sheet2

Range("B1") = "Name"
Range("C1") = "Address"
Range("D1") = "City"
Range("E1") = "State"
Range("F1") = "Zip"
Range("G1") = "Telephone"
Range("H1") = "Web"
Range("I1") = "Episode"
NR = 2
Range("A1").Insert (xlShiftDown)    'Just in case
For i = 2 To LR
If Not IsEmpty(Cells(i, "A")) And IsEmpty(Cells(i - 1, "A")) Then
'Name
Cells(NR, "B") = Cells(i, "A")
'Address
If Left(Cells(i + 1, "A"), 4) = "Note" Then i = i + 1
Cells(NR, "C") = Cells(i + 1, "A")
'City
If Left(Cells(i + 2, "A"), 4) = "note" Then i = i + 1
If InStr(Cells(i + 2, "A"), ",") = 0 Then
Cells(NR, "C") = Cells(NR, "C") & ", " & Cells(i + 2, "A")
i = i + 1
End If
Cells(NR, "D") = Left(Cells(i + 2, "A"), InStr(Cells(i + 2, "A"), ",") - 1)
'State
If Left(Cells(i + 2, "A"), 4) = "note" Then i = i + 1
Cells(NR, "E") = Mid(Cells(i + 2, "A"), InStr(Cells(i + 2, "A"), ",") + 2, 2)
'Zip
If IsNumeric(Right(Cells(i + 2, "A"), 2)) Then
If InStr(Cells(i + 2, "A"), "-") > 0 Then
Cells(NR, "F") = Format(Right(Trim(Cells(i + 2, "A")), 10), "####-#####")
Else
Cells(NR, "F") = Format(Right(Trim(Cells(i + 2, "A")), 5), "#####")
End If
End If
'Tel / Web / Episode
For j = i + 3 To i + 5
Select Case Left(Cells(j, "A"), 3)
Case "Tel"
Cells(NR, "G") = Right(Cells(j, "A"), Len(Cells(j, "A")) - 5)
Case "Web"
Cells(NR, "H") = Right(Cells(j, "A"), Len(Cells(j, "A")) - 9)
Case ""
Exit For
Case Else
Cells(NR, "I") = Cells(j, "A")
End Select
Next j
NR = NR + 1
End If
Next i
Range("B1", Range("B1").SpecialCells(xlCellTypeLastCell)).Cut
Worksheets.Add(After:=Worksheets(Worksheets.Count)).Name = "AddressList"
ActiveSheet.Paste
Columns("A:I").AutoFit
Columns("E:E").NumberFormat = "00000"
Range("A1").Select
End Sub
Spreadsheet: jeffrey_a_shankman__13834__Global_Prod 1-26-01 EM
Sheet: Not Available on 1-26-01

Global Products that were not made available on
but were available on
Global Product Short Desc.
AUS Wth CDD Swap HNG KNG 50/5K           Aug01           USD/CDD
AUS Wth CDD Swap HNG KNG 50/5K           Jul01           USD/CDD
AUS Wth CDD Swap HNG KNG 50/5K           Jun01           USD/CDD
AUS Wth CDD Swap HNG KNG 50/5K           Oct01           USD/CDD
AUS Wth CDD Swap HNG KNG 50/5K           Sep01           USD/CDD
For Curr Exch    Forward                 29Jan01         JPY/USDm
For Curr Exch    Forward                 29Jan01         USD/EURm
For Curr Exch    Forward                 29Jan01         USD/GBPm
For Curr Par Fwd Reuters BOFC            25Jan01         CAD/USDm
JPN Wth HDD Swap Osaka 10K/1M            Feb01           JPY/HDD
JPN Wth HDD Swap Osaka 10K/1M            Mar01           JPY/HDD
JPN Wth HDD Swap Tokyo 10K/1M            Feb01           JPY/HDD
JPN Wth HDD Swap Tokyo 10K/1M            Mar01           JPY/HDD
NOR Bkrptcy Swap Norsk Hydro             25Mar01-25Mar06 USD/bpa
Propane CFR Swap Argus FE (CFR)          Feb01           USD/mt
SWE Bkrptcy Swap Birka                   25Mar01-25Mar06 USD/bpa
SWE Bkrptcy Swap Sydkraft                25Mar01-25Mar06 USD/bpa
UK Bkrptcy Swap  Centrica                25Mar01-25Mar06 USD/bpa
UK Bkrptcy Swap  NGC                     25Mar01-25Mar06 USD/bpa
UK Bkrptcy Swap  Norweb                  25Mar01-25Mar06 USD/bpa
UK Bkrptcy Swap  Powergen                25Mar01-25Mar06 USD/bpa
UK Bkrptcy Swap  S & S Engy              25Mar01-25Mar06 USD/bpa
UK Bkrptcy Swap  Scottish Pwr            25Mar01-25Mar06 USD/bpa
UK Bkrptcy Swap  Seeboard                25Mar01-25Mar06 USD/bpa
UK Bkrptcy Swap  Vodafone                25Mar01-25Mar06 USD/bpa
US Benz FOB Phy  Hou/TX Cty              Feb01           USD/Gl-b
US Benzene Swap  CMAI Spot               Apr-Jun01       USD/Gl-b
US Bkrptcy Swap  Lockheed Martin         25Mar01-25Mar06 USD/bpa
US Bkrptcy Swap  MCI WorldCom            25Mar01-25Mar06 USD/bpa
US Bkrptcy Swap  Raytheon                25Mar01-25Mar06 USD/bpa
US Bkrptcy Swap  Solectron               25Mar01-25Mar06 USD/bpa
US Jet Kero Swap GC vs NYMEX HO          Jan-Dec02       c/Gl-b
US Prop FOB Phy  MB Dia                  Jan01           c/Gl-b
US PuEthane Swap OPIS MB PurEth          Apr-Jun01       c/Gl-b
Spreadsheet: 684585d1593448782-lookup-text-value-for-with-multiple-results-from-another-tab-time-totals-summary
Sheet: Day 2

Name | Start Time | End Time | Total Time
Captain America | 08:30:00 | 12:00:00
Iron Man | 09:00:00 | 13:00:00
[NAME] | 06:00:00 | 14:00:00
Black Widow | 06:30:00 | 16:00:00
[NAME] | 08:00:00 | 14:30:00
[NAME] | 09:30:00 | 15:30:00
[NAME] | 10:00:00 | 15:45:00
[NAME] | 09:30:00 | 18:00:00
Loki | 08:15:00 | 19:00:00
Hulk | 07:45:00 | 23:00:00
[NAME] | 08:00:00 | 12:30:00
[NAME] | 10:30:00 | 17:00:00
Thor | 10:00:00 | 17:30:00
Wasp | 09:30:00 | 17:15:00
Black Panther | 09:15:00 | 14:30:00
[NAME] | 08:45:00 | 15:00:00
[NAME] | 08:45:00 | 15:30:00
[NAME] | 09:00:00 | 16:15:00
[NAME] | 09:15:00 | 16:30:00
[NAME] | 09:00:00 | 15:45:00
[NAME] | 08:45:00 | 18:00:00
[NAME] | 08:30:00 | 19:00:00
Captain Marvel | 08:15:00 | 23:00:00
[NAME] | 08:30:00 | 12:30:00
Wolverine | 10:00:00 | 14:00:00
[NAME] | 13:00:00 | 16:00:00
Dr. Strange | 13:15:00 | 14:30:00
[NAME] | 14:15:00 | 15:30:00
Captain America | 10:00:00 | 15:45:00
Iron Man | 09:30:00 | 15:45:00
[NAME] | 08:15:00 | 18:00:00
Black Widow | 07:45:00 | 19:00:00
[NAME] | 08:00:00 | 23:00:00
[NAME] | 10:30:00 | 12:30:00
[NAME] | 10:00:00 | 18:00:00
[NAME] | 09:30:00 | 19:00:00
Loki | 09:15:00 | 23:00:00
Hulk | 08:15:00 | 12:30:00
[NAME] | 08:30:00 | 14:00:00
[NAME] | 10:00:00 | 16:00:00
Thor | 13:00:00 | 14:30:00
[NAME] | 13:15:00 | 19:00:00
Spreadsheet: 600613d1543869280-returning-a-value-through-multiple-vlookup-values-sample
Sheet: Sheet1

Master PO | Vendor | [NAME] | Their # | Our # | Description | Date | Store | Store Name | [NAME] (QUANTITY SHIPPED) |  | Customer P/O | Item | Store | Qty
DN6V6VS | 1161 | ABC COMPANY INC | 11177077 | 31190 | ITEM 1 | 2018-11-05 00:00:00 | 808 | [NAME] |  |  | DN6V6VS | 41021 | 808 | 32
DN6V6VS | 1161 | ABC COMPANY INC | 11449425 | 50115 | ITEM 2 | 2018-11-05 00:00:00 | 808 | [NAME] |  |  | DN6V6VS | 31114 | 808 | 30
DN6V6VS | 1161 | ABC COMPANY INC | 13048320 | 31079 | ITEM 3 | 2018-11-05 00:00:00 | 808 | [NAME] |  |  | DN6V6VS | 31190 | 808 | 0
DN6V6VS | 1161 | ABC COMPANY INC | 14111581 | 31171 | ITEM 4 | 2018-11-05 00:00:00 | 808 | [NAME] |  |  | DN6V6VS | 50115 | 808 | 16
DN6V6VS | 1161 | ABC COMPANY INC | 18594625 | 30440 | ITEM 5 | 2018-11-05 00:00:00 | 808 | [NAME] |  |  | DN6V6VS | 31171 | 808 | 0
 |  |  |  |  |  |  |  |  |  |  | DN6V6VS | 30440 | 808 | 0