tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 159737d1338830776-excel-contact-list-help-master-contact-list-sample-dlwany-oeldere-
Sheet: Sheet1

Master Contact List
Contact Name | Contact Name (formula) | Contact Title | First Name | Last Name | Address1 | Address2 | City | State or Province | Postal Code | Country | Phone Number #1 | Phone Number #2 | E-Mail Address | Notes | Notes | Notes
[NAME] | [NAME] |  | [NAME] | Nickerson | 125 Clyde Avenue |  | Toronto | ON | L6R 2J7 | Canada | [PHONE] |  | [EMAIL] | Event 1 | Event 2 | Event 3
[NAME] | [NAME] |  | [NAME] | Campbell | 345 Wellington Street |  | Brampton | ON | M2R 3V6 | Canada | [PHONE] | [PHONE] | [EMAIL] | Event 2 | Event 1
[NAME] | [NAME] |  | [NAME] | [NAME] | 98 Prince Street | Unit 2 | Scarborough | ON | L0P 1E5 | Canada | [PHONE] |  | [EMAIL] | Event 3 | Event 2 | Event 1
 | Waarden
Rijlabels | Aantal van Notes | Aantal van Notes2 | Aantal van Notes3
[NAME] | 1 | 1 | 1
[NAME] | 1 | 1
[NAME] | 1 | 1 | 1
Eindtotaal | 3 | 3 | 2
Spreadsheet: 579048d1529659310-populate-list-from-the-master-list-no-vlookup-where-you-already-provide-the-1st-column-_generate-a-list-from-master-list_v1
Sheet: Region

 |  | Region
 |  | East | << example: If we select "West" then all the cells from D9:F9 onwards should auto-populate based
 | S.No. | Product | Region | Sales |  | Cross-Check 1: |  | Cross-Check 2:
 | 1 |  |  |  |  |  |  | Row Labels | Count of Product
 | 2 |  |  |  |  |  |  | East | 8
 | 3 |  |  |  |  |  |  | North | 9
 | 4 |  |  |  |  |  |  | South | 7
 | 5 |  |  |  |  |  |  | West | 11
 | 6 |  |  |  |  |  |  | Grand Total | 35
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
Spreadsheet: 298308d1392755557-find-a-value-in-a-table-with-multiple-values-test-excel-data-search-sheet
Sheet: ON-3

Date | PO # | Buyer | Division Line | Model | Trailer Description | Serial # | Build Location | Line # | Est. Delivery Date | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 2014-01-01 00:00:00
Spreadsheet: 776254d1649645784-big-cleaning-data-excelforum_merge_subst
Sheet: Formulas

Wrong Addresses: | Formula 1/5 | Formula 2/5 | [NAME] 3/5 | [NAME] 4/5 | Formula 5/5
Str. Exampl~e Park-Avenue Nr.[A3-5]/C
Ṧtr. Exămple Park-Avenue Nr.A3-5/C
Str. Example 	Park-Avenue Nr.A3-5/	C
Str. Example Park-Avenue №A3-5/C
Str. example PARK-AveNue nr.A3-5/c
Str. Example Park-Avenue numa3-5/C
Ṧțr. ExâMple *?	^PaRK-ave>nue nra3-5/c
//Str/.Example///Park-Avenue/Nr.A3-5/C
-Str .  -  -  -/-    -..--Example Park- [NAME] -5/C
Str.Example.Park-Avenue.Nr.A3-5/C
Str. Example Park-Avenue Nr.A3-5/C, Bloc C, Aprt. 6
Str. Example Park-Avenue Nr.A 3 -5/ C, Bl. C,      Ap. 6 .
Str; Example Park-Avenue, Nr.A 3 -5/ C, Bl.C, Ap.6
...Str...Example    Park---Avenue;;; Nr.A3----5/// C,,, [NAME].C, Ap.6,,,,
///Str/ .  -  -  -.-    -..--Example;Park- -Avenue Nr…A3-5/C--- Bloc C   Ap. 6///
Example Park-Avenue Nr.A3-5/C
Ps. Example Park-Avenue Nr.A3-5/C
Str. Aleea Example Park-Avenue Nr.A3-5/C
Strada B-dul. Example Park-Avenue Nr.A3-5/C
Str. Example Park-Avenue, army-cap. Nr.A3-5/C
Str. Example Park-Avenue- Nr.A3-5/C
Str. Example Park-Avenue TR Nr.A3-5/C
Str. Example Park-Avenue Junior Nr.A3-5/C
gnr-maj. Example Park-Avenue TR Senior, doc. . Nr.A3-5/C
Str. Example pizdet Park-Avenue Nr.A3-5/C
Str. Example pizda matii Park-Avenue Nr.A3-5/C
Wrong | Step 1 | Step 2 | Step 3 | Step 4 | Step 5
Spreadsheet: 869361d1715933053-conditional-formatting-with-text-and-2-criterias-book-1
Sheet: Sheet5

ALL |  |  |  | 4a
Species | Grade | Boxes |  | Species | Boxes |  | Species | Grade | Boxes |  | Species | Grade | Boxes
 | COD | 1 |  |  |  |  | COD | COD | 1 |  | COD | SPRAGG | 1
COD | SPRAGG | 1 |  | COLEY | 5 |  | COD | LARGE | 1 |  | COD | MEDIUM | 1
COD | LARGE | 1 |  | HADDOCK | 8 |  | COD | SELECTED | 1 |  | COD | SMALL | 1
COD | MEDIUM | 1 |  | HAKE | 6 |  | COD | SMALL | 1 |  | COD | ROE | 1
COD | SELECTED | 1 |  | LEMONS | 4 |  | COLEY | XLARGE | 1 |  | COLEY | LARGE | 1
COD | SMALL | 1 |  | LING | 3 |  | COLEY | MEDIUM | 1 |  | COLEY | SELECTED | 1
COD | ROE | 1 |  | LYTHE | 4 |  | COLEY | SMALL | 1 |  | HADDOCK | JUMBO | 1
COLEY | X LARGE | 1 |  | MEGRIM | 5
COLEY | LARGE | 1 |  | MONKS | 6
COLEY | MEDIUM | 1 |  | OTHERS | 8
COLEY | SELECTED | 1 |  | PLAICE | 4
COLEY | SMALL | 1 |  | SKATE & RAYS | 5
HADDOCK | JUMBO | 1 |  | SQUID | 4
HADDOCK | LARGE | 1 |  | WHITING | 4
HADDOCK | MEDIUM | 1 |  | Total
HADDOCK | SELECTED | 1
HADDOCK | SEED | 1 |  | Vessel + PLN | Boxes
HADDOCK | CHIPPERS | 1
HADDOCK | METRO | 1
HADDOCK | ROUND | 1
HAKE | LARGE | 1
HAKE | MEDIUM | 1
HAKE | SELECTED | 1 |  | Total
HAKE | SMALL | 1
HAKE | PINS | 1
HAKE | BYROS | 1
LEMONS | LARGE | 1
LEMONS | MEDIUM | 1
LEMONS | SELECTED | 1
LEMONS | SMALL | 1
LING | LARGE | 1
LING | MEDIUM | 1
LING | SELECTED | 1
LYTHE | LARGE | 1
LYTHE | MEDIUM | 1
LYTHE | SELECTED | 1
LYTHE | SMALL | 1
MEGRIM | LARGE | 1
MEGRIM | MEDIUM | 1
MEGRIM | SELECTED | 1
MEGRIM | SMALL | 1
MEGRIM | BRUISED | 1
MONKS | X LARGE | 1
MONKS | LARGE | 1
MONKS | MEDIUM | 1
MONKS | SELECTED | 1
MONKS | SMALL | 1
MONKS | FROGS | 1
OTHERS | DOVERSOLE | 1
OTHERS | TURBOT | 1
OTHERS | COD ROE | 1
OTHERS | GURNARD | 1
OTHERS | WITCH | 1
OTHERS | JOHN DORY | 1
OTHERS | BRILL | 1
OTHERS | OTHERS | 1
PLAICE | LARGE | 1
PLAICE | MEDIUM | 1
PLAICE | SELECTED | 1
PLAICE | SMALL | 1
SKATE & RAYS | ROKER | 1
SKATE & RAYS | ROKER | 1
SKATE & RAYS | THORNY | 1
SKATE & RAYS | 0 | 1
SKATE & RAYS | CUCKOO | 1
SQUID | LARGE | 1
SQUID | MEDIUM | 1
SQUID | SELECTED | 1
SQUID | SMALL | 1
WHITING | LARGE | 1
WHITING | MEDIUM | 1
WHITING | SMALL | 1
WHITING | ROUND | 1
Spreadsheet: 052c3ddf-7624-400b-8d94-5066754d3191
Sheet: AWARDS GRAPH

BACK TO TABLE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column Labels
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Values | AA & AS | Grand Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY 07-08 | 912 | 912
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY 08-09 | 988 | 988
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY 09-10 | 1017 | 1017
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY 10-11 | 1096 | 1096
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY 11-12 | 1086 | 1086
Spreadsheet: ed084561-dd79-4583-bf63-8479d87a3933
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Grundarstræti 3, 420 Súðavík
Sími 450-5900 / Fax 456-4946
Tónlistardeild Súðavíkurskóla                      Umsókn um skólavist
Upplýsingar um umsækjanda
[NAME] skólaársins:                      Ár: |  |  |  | Ár.
Nafn umsækjanda: |  |  |  | Kennitala:
Forráðamaður |  |  |  | Kennitala:
Sími forráðamanns: |  |  | Sími nemanda:
Netfang nemanda: |  |  | Netfang forráðamanns:
Lögheimili: |  |  |  | Bekkur:
Sótt er um sem:
Aðalfag: |  |  | [NAME]:
Námshlutfall: |  |  | [NAME] leigja hljóðf.:
Nemandi má sækja tónlistartíma á skólatíma skv. [NAME]? |  |  |  | Já/ nei
Athugasemdir (s.s. [NAME]):
ATH: Umsókn uum skólavist ekki fullgild nema greiðslusamningur hafi verið fylltur út og skilað til skólans.  [NAME] um greiðslu skólagjalda er á sérstöku eyðublaði
Fyrir nýja nemendur: |  |  | Fyrra tónlistarnám? |  | Já/ Nei
Ef já: | Hvenær? |  |  | Hvar?
Hver var kennari?
Hvaða námsgrein? |  |  |  | Stig?
Fylgigögn
Umsókn skal fylgja: 1. Greiðslusamningur fyrir skólaárið.
Annað sem umsækjandi vill koma á [NAME]
Undirskrift forráðamanns, [NAME]. ef eldri en 18 ára) |  |  |  |  | Dags, umsóknar
Spreadsheet: 749404d1632773993-return-highest-value-for-repeating-lookup-values-sample-2-etaf
Sheet: Sample Data

Part | Last used date |  |  |  |  | Part | Last used
1001 | 2020-01-01 00:00:00 |  |  |  |  | 1004
1002 | 2020-05-02 00:00:00 |  |  |  |  | 1002
1003 | 2020-06-03 00:00:00 |  |  |  |  | 1003
1004 | 2020-01-06 00:00:00 |  |  |  |  | 1001
1001 | 2020-02-04 00:00:00
1002 | 2020-03-08 00:00:00
1003 | 2020-02-06 00:00:00
1004 | 2020-05-06 00:00:00
1001 | 2021-01-06 00:00:00
1002 | 2021-08-08 00:00:00
1003 | 2021-04-05 00:00:00
1004 | 2021-07-09 00:00:00
Spreadsheet: 69853d1270541088-pulling-info-out-of-an-old-layout-oct-08
Sheet: 10-29-08 2nd

Daily Problem Report |  |  |  |  |  | 2nd shift |  | Date |  | 2008-10-29 00:00:00
 |  | Daily cases |  | Daily hours |  | Daily Avg Per Month |  | Note
ER |  | 9 |  | 5 |  | 3.7
PR |  | 4 |  |  |  | 2.5
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
ER |  | 2-1 | 53725/6-0C010-T1 |  | Problem: SCRAP BUILD UP |  |  | Station:PROG |  | Ran:362 OF 450 | 0.25
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause: | COULDN’T TELL |  |  | 7:55-8:00
 |  |  |  |  | Explain: | EXIT CENTER CHUTE BACKED UP. REMOVED SCRAP AND INSPECTED. OK TO RUN. |  |  |  |  | T.A.
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
ER |  | 5-1 | 67185/6-08010/20-00 |  | Problem:  RIPPED PART |  |  | Station:1/5 |  | Ran:551 OF 1200 | 0.25
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause: | POSSIBLY SCRAP UNDER DRAW. |  |  | 9:25-9:35
 |  |  |  |  | Explain: | PART SMASHED IN 1/5 LEAVING SCRAP. REMOVED SCRAP OK. RUN FINISHED OK. WE NEED TO |  |  |  |  | T.A.
 |  |  |  |  | INSPECT. TAGGED FOR REPAIRS
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
PR |  | 4-1 | 53216-08021-T1 |  | Problem: SCRAP BUILD UP |  |  | Station:3/6 |  | Ran:350 OF 700 | 0
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause: | STAMPING LEFT THE DEFLECTOR FOR CLAMP LINE OFF. |  |  | 1:15-1:20
 |  |  |  |  | Explain: | SCRAP CAUGHT  ON HYDRAULIC CLAMP LINE AND BUILT UP, CAUSING THE UPPER AND LOWER
 |  |  |  |  | SCRAP CUTTERS  TO CRACK. PULLING.
Stamping T/L: SHANE ROBY
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
Misc.Notes:
Spreadsheet: 168213d1342303183-excel-2007-make-multiple-rows-into-one-row-of-data-test-file-after
Sheet: Sheet1

I need this…
Pt-Acct# | Last Name, First | Birth | Guarantor | Insurance Co. | Acct Type | Balance
 | Address | S.S. # | Doctor | [NAME] | Policy
 | [NAME] | Phone | Referring Doctor | PH Employer | Group # | [NAME]
Pt-Acct# | Last Name, First | Birth | Guarantor | Insurance Co. | Acct Type | Balance
 | Address | S.S. # | Doctor | [NAME] | Policy
 | [NAME] | Phone | Referring Doctor | PH Employer | Group # | [NAME]
Pt-Acct# | Last Name, First | Birth | Guarantor | Insurance Co. | Acct Type | Balance
 | Address | S.S. # | Doctor | [NAME] | Policy
 | [NAME] | Phone | Referring Doctor | PH Employer | Group # | [NAME]
To end up like this…
Pt-Acct# | Last Name, First | Birth | Guarantor | Insurance Co. | Acct Type | Balance | Address | S.S. # | Doctor | [NAME] | Policy | [NAME] | Phone | Referring Doctor | PH Employer | Group # | [NAME]
Pt-Acct# | Last Name, First | Birth | Guarantor | Insurance Co. | Acct Type | Balance | Address | S.S. # | Doctor | [NAME] | Policy | [NAME] | Phone | Referring Doctor | PH Employer | Group # | [NAME]
Pt-Acct# | Last Name, First | Birth | Guarantor | Insurance Co. | Acct Type | Balance | Address | S.S. # | Doctor | [NAME] | Policy | [NAME] | Phone | Referring Doctor | PH Employer | Group # | [NAME]
When I run the code, I get this.
Pt-Acct# | Last Name, First | Birth | Guarantor | Insurance Co. | Acct Type | Balance
Pt-Acct# | Last Name, First | Birth | Guarantor | Insurance Co. | Acct Type | Balance
Pt-Acct# | Last Name, First | Birth | Guarantor | Insurance Co. | Acct Type | Balance
Spreadsheet: 38215d1236326099-hide-value-in-a-cell-and-a-few-other-things-book1
Sheet: Sheet2

 | comm | loss
 |  | 0
 |  |  | 0
 |  |  | BAC | 5.52 | 1000 | 5520 |  | 4.18 | -1340 | -1.34 | 2009-02-01 00:00:00 | 2009-02-05 00:00:00 | 4 | 1000 | -0.2427536231884058
 |  |  | BAC | 6.06 | 700 | 4242 |  | 4.18 | -1316 | -1.88 | 2009-02-01 00:00:00 | 2009-02-05 00:00:00 | 4 | 700 | -0.3102310231023102
 |  |  | BAC | 4.07 | 1000 | 4070 |  |  | -4070 | -4.07 | 2009-02-26 00:00:00 |  | -39870 | 1000 | -1
 |  |  | BAC | 4.09 | 1000 | 4090 |  |  | -4090 | -4.09 | 2009-02-26 00:00:00 |  | -39870 | 1000 | -1
 |  |  | BAC | 3.99 | 1000 | 3990 |  |  | -3990 | -3.99 | 2009-02-26 00:00:00 |  | -39870 | 1000 | -1
Spreadsheet: eric_saibi__9780__013102R
Sheet: Greene County 01

Owner Name |  | Alabama Power Co.
Station Name |  | Greene County Power Station
Unit Name |  | Greene County 01
NERC Region |  | SERC
State |  | AL
Fuel Type |  | Coal
Capacity |  | 299 MW
Start Date |  | 2002-01-04 00:00:00
End Date |  | 2002-02-07 00:00:00
Prv. Start Date |  | 2002-01-04 00:00:00
Prv. End Date |  | 2002-01-31 00:00:00
Comments |  | Condenser replacement
SIC |  | 4911
Plant ID |  | 1006899
Unit ID |  | 1006843
Outage ID |  | 17643
Spreadsheet: 839054d1691610252-returning-a-list-based-on-row-and-column-value-and-concat-with-dates-availablity-list
Sheet: Availability Monitoring

PLAYER DETAILS |  |  |  | Week 1 |  |  |  |  |  | WEEK 2 |  |  |  |  |  | WEEK 3 |  |  |  |  |  | WEEK 4 |  |  |  |  |  | YEAR % AVAILIBILITY
 | POS NO | Name | Position | 2023-08-09 00:00:00
DEFENSE | 1 | Player 1 | CB | FP | FP | FP | FP | FP
 | 2 | Player 2 | CB | FP | FP | FP | FP | FP
 | 3 | Player 3 | CB | R | R | R | R | R
 | 4 | Player 4 | CB | FP | FP | FP | FP | FP
 | 5 | Player 5 | CB | MP | MP | MP | FP | FP
 | 6 | Player 6 | CB | FP | FP | FP | FP | FP
 | 7 | Player 7 | CB | FP | FP | FP | FP | FP
 | 8 | Player 8 | CB | FP | FP | FP | FP | FP
 | 9 | Player 9 | CB | FP | FP | FP | FP | FP
 | 10 | Player 10 | CB | FP | FP | FP | FP | FP
 | 11 | Player 11 | CB | FP | FP | FP | FP | FP
 | 12 | Player 12 | CB | FP | FP | FP | FP | FP
 | 13 | Player 13 | CB | FP | FP | FP | FP | FP
 | 14 | Player 14 | CB | FP | FP | FP | FP | FP
 | 15 | Player 15 | CB | FP | FP | FP | FP | FP
 | 16 | Player 16 | S | FP | FP | FP | FP | FP
 | 17 | Player 17 | S | FP | FP | FP | FP | FP
 | 18 | Player 18 | S | FP | FP | FP | FP | FP
 | 19 | Player 19 | S | MP | MP | MP | MP | MP
 | 20 | Player 20 | S | FP | FP | FP | FP | FP
 | 21 | Player 21 | S | R | R | R | R | R
 | 22 | Player 22 | S | FP | FP | FP | FP | FP
 | 23 | Player 23 | S | MP | MP | MP | MP | MP
 | 24 | Player 24 | LB | FP | FP | FP | FP | FP
 | 25 | Player 25 | LB | FP | FP | FP | FP | FP
 | 26 | Player 26 | LB | R | R | R | R | R
 | 27 | Player 27 | LB | FP | FP | FP | FP | FP
 | 28 | Player 28 | LB | FP | FP | FP | FP | FP
 | 29 | Player 29 | LB | FP | FP | FP | FP | FP
 | 30 | Player 30 | LB | MA | MA | FP | FP | FP
 | 31 | Player 31 | LB | FP | FP | FP | FP | FP
 | 32 | Player 32 | LB | FP | FP | FP | FP | FP
 | 33 | Player 33 | LB | FP | FP | FP | FP | FP
 | 34 | Player 34 | LB | FP | FP | FP | FP | FP
 |  | Full Practice
 |  | Modified Practice
 |  | Medically Unavailable
 |  | Rehab
 |  | TOTAL
Spreadsheet: 98142d1297180037-help-making-new-user-setup-form-example
Sheet: Example BE

Type | New Users - Tasks | Drafting | Estimating | PMs | PM Asst
Software | Adobe Reader | x | x | x | x
Software | [NAME] | o | o | o | o
Software | MS Office Basic | x | x | x | x
Software | MS SQL Server Client | x | o | o | o
Spreadsheet: 67196d1267788207-vlookup-dates-vlookup-dates-v2
Sheet: Database

[NAME] | Half or Full | Index Date | Result
0.540209 | 0.5 | 2010-01-31 00:00:00 | 2010-01-15 00:00:00
0.540237 | 0.5 | 2010-02-28 00:00:00 | 2010-02-15 00:00:00
0.540268 | 0.5 | 2010-03-31 00:00:00 | 2010-03-15 00:00:00
0.540298 | 0.5 | 2010-04-30 00:00:00 | 2010-04-15 00:00:00
0.540329 | 0.5 | 2010-05-31 00:00:00 | 2010-05-15 00:00:00
0.540359 | 0.5 | 2010-06-30 00:00:00 | 2010-06-15 00:00:00
0.540390 | 0.5 | 2010-07-31 00:00:00 | 2010-07-15 00:00:00
0.540421 | 0.5 | 2010-08-31 00:00:00 | 2010-08-15 00:00:00
0.540451 | 0.5 | 2010-09-30 00:00:00 | 2010-09-15 00:00:00
0.540482 | 0.5 | 2010-10-31 00:00:00 | 2010-10-15 00:00:00
0.540512 | 0.5 | 2010-11-30 00:00:00 | 2010-11-15 00:00:00
0.540543 | 0.5 | 2010-12-31 00:00:00 | 2010-12-15 00:00:00
0.540574 | 0.5 | 2011-01-31 00:00:00 | 2011-01-15 00:00:00
0.540602 | 0.5 | 2011-02-28 00:00:00 | 2011-02-15 00:00:00
0.540633 | 0.5 | 2011-03-31 00:00:00 | 2011-03-15 00:00:00
0.540663 | 0.5 | 2011-04-30 00:00:00 | 2011-04-15 00:00:00
0.540694 | 0.5 | 2011-05-31 00:00:00 | 2011-05-15 00:00:00
0.540724 | 0.5 | 2011-06-30 00:00:00 | 2011-06-15 00:00:00
0.540755 | 0.5 | 2011-07-31 00:00:00 | 2011-07-15 00:00:00
0.540786 | 0.5 | 2011-08-31 00:00:00 | 2011-08-15 00:00:00
0.540816 | 0.5 | 2011-09-30 00:00:00 | 2011-09-15 00:00:00
0.540847 | 0.5 | 2011-10-31 00:00:00 | 2011-10-15 00:00:00
0.540877 | 0.5 | 2011-11-30 00:00:00 | 2011-11-15 00:00:00
0.540908 | 0.5 | 2011-12-31 00:00:00 | 2011-12-15 00:00:00
140209 | 1 | 2010-01-31 00:00:00 | 2010-01-01 00:00:00
140237 | 1 | 2010-02-28 00:00:00 | 2010-02-01 00:00:00
140268 | 1 | 2010-03-31 00:00:00 | 2010-03-01 00:00:00
140298 | 1 | 2010-04-30 00:00:00 | 2010-04-01 00:00:00
140329 | 1 | 2010-05-31 00:00:00 | 2010-05-01 00:00:00
140359 | 1 | 2010-06-30 00:00:00 | 2010-06-01 00:00:00
140390 | 1 | 2010-07-31 00:00:00 | 2010-07-01 00:00:00
140421 | 1 | 2010-08-31 00:00:00 | 2010-08-01 00:00:00
140451 | 1 | 2010-09-30 00:00:00 | 2010-09-01 00:00:00
140482 | 1 | 2010-10-31 00:00:00 | 2010-10-01 00:00:00
140512 | 1 | 2010-11-30 00:00:00 | 2010-11-01 00:00:00
140543 | 1 | 2010-12-31 00:00:00 | 2010-12-01 00:00:00
140574 | 1 | 2011-01-31 00:00:00 | 2011-01-01 00:00:00
140602 | 1 | 2011-02-28 00:00:00 | 2011-02-01 00:00:00
140633 | 1 | 2011-03-31 00:00:00 | 2011-03-01 00:00:00
140663 | 1 | 2011-04-30 00:00:00 | 2011-04-01 00:00:00
140694 | 1 | 2011-05-31 00:00:00 | 2011-05-01 00:00:00
140724 | 1 | 2011-06-30 00:00:00 | 2011-06-01 00:00:00
140755 | 1 | 2011-07-31 00:00:00 | 2011-07-01 00:00:00
140786 | 1 | 2011-08-31 00:00:00 | 2011-08-01 00:00:00
140816 | 1 | 2011-09-30 00:00:00 | 2011-09-01 00:00:00
140847 | 1 | 2011-10-31 00:00:00 | 2011-10-01 00:00:00
140877 | 1 | 2011-11-30 00:00:00 | 2011-11-01 00:00:00
140908 | 1 | 2011-12-31 00:00:00 | 2011-12-01 00:00:00
Spreadsheet: 873786d1720355504-cant-make-the-formula-system-suitability-and-area-ration-calculation-sheet-for-fudrocortisone-acetate-usp-excel-for
Sheet: Sheet1

Respective Solvent ( |  |  |  |  |  |  |  |  | [NAME] |  |  | )
Average peak area of |  |  |  |  |  |  | in diluent |  |  | = | 10523
 |  |  | Area Ratio of |  |  |  |  |  |  |  | Results
Solution Name |  |  | Calculation |  |  |  |  | Area Ratio |  |  | Solution Name | Average | SD |  | % RSD
[NAME] 01 |  |  | = | 635686 | - |  |  | =
 |  |  |  | 236572 |  |  |  |  |  |  | [NAME]
[NAME] 02 |  |  | = | 639863 | - |  |  | =
 |  |  |  | 241450
[NAME] 03 |  |  | = | 624296 | - |  |  | =
 |  |  |  | 236539 |  |  |  |  |  |  | Bracketing Standard Solution 01
[NAME] 04 |  |  | = | 624296 | - |  |  | =
 |  |  |  | 238607
[NAME] 05 |  |  | = | 630036 | - |  |  | =
 |  |  |  | 238196
Bracketing Standard Solution 01 |  |  | = | 257242 | - |  |  | =
 |  |  |  | 82919
Spreadsheet: 54952d1255002534-various-lookups-and-counts-example
Sheet: Sheet1

Company A | 2009-07-24 00:00:00 | 68
Company B | 2009-09-11 00:00:00 | 3
Company C | 2009-09-11 00:00:00 | 5
Company A | 2009-09-07 00:00:00 | 31
Company B | 2009-09-07 00:00:00 | 31
Company A | 2009-09-07 00:00:00 | 31
Company B | 2009-09-18 00:00:00 | 20
Company A | 2009-09-19 00:00:00 | 3
Company A | 2009-09-22 00:00:00 | 7
Company A | 2009-09-22 00:00:00 | 16
Company B | 2009-08-06 00:00:00 | 56
Company A | 2009-09-16 00:00:00 | 14
Company A | 2009-10-01 00:00:00 | 7
Company B | 2009-09-19 00:00:00 | 19
Company A | 2009-10-05 00:00:00 | 3
Company C | 2009-10-05 00:00:00 | 2
Company C | 2009-09-30 00:00:00 | 7
Company B | 2009-09-30 00:00:00 | 7
Company A | 2009-09-04 00:00:00 | 34
Spreadsheet: 192084d1352303402-is-there-such-a-thing-as-auto-filter-or-a-workaround-that-will-do-the-following-deal-log
Sheet: TEAM4

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | counts:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL FRONT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | total gross
## | SALESMAN | TEAM # | DATE | CUSTOMER | STOCK# | FRONT $$ | RESERVE | WARR | GAP | A/M | TOTAL $ | [N/U] | NEW UNITS | USED UNITS | NEW GROSS | USED GROSS | fe | reserve | WARR | gap | a/m | front | reserve | warr | gap | a/m
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400