tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 865536d1712608906-how-to-find-closes-date-to-actual-date-and-pull-out-whole-line-club_date
Sheet: Harmonogram

Date | Time | Place | Dinner | Name | Discussion
2024-01-03 00:00:00 | 17:45:00 | Trolen 2 | [NAME] | [NAME] | [NAME]
 | 17:45:00 | Kotllen 33 | [NAME] | [NAME] | Kaler
 | 17:45:00 | Pater 223 | [NAME] | Kaler | Pater
 | 17:45:00 | Kasel 3 | Kaler | Pater | [NAME]
 | 17:45:00 | Trolen 2 | Pater | [NAME] | [NAME]
 | 17:45:00 | Kotllen 33 | [NAME] | [NAME] | [NAME]
 | 17:45:00 | Pater 223 | [NAME] | [NAME] | [NAME]
 | 17:45:00 | Kasel 3 | [NAME] | [NAME] | Kaler
 | 17:45:00 | Trolen 2 | Kaler | Kaler | Pater
 | 17:45:00 | Kotllen 33 | Pater | Pater | [NAME]
 | 17:45:00 | Pater 223 | [NAME] | [NAME] | [NAME]
 | 17:45:00 | Kasel 3 | [NAME] | [NAME] | [NAME]
 | 17:45:00 | Trolen 2 | [NAME] | [NAME] | [NAME]
 | 17:45:00 | Kotllen 33 | Kaler | [NAME] | Kaler
 | 17:45:00 | Pater 223 | Pater | Kaler | Pater
 | 17:45:00 | Kasel 3 | [NAME] | Pater | [NAME]
 | 17:45:00 | Trolen 2 | [NAME] | [NAME] | [NAME]
 | 17:45:00 | Kotllen 33 | [NAME] | [NAME] | Pater
 | 17:45:00 | Pater 223 | Kaler | Pater | [NAME]
 | 17:45:00 | Kasel 3 | Pater | [NAME] | [NAME]
 | 17:45:00 | Kasel 3 | Pater | [NAME] | [NAME]
Spreadsheet: 81603d1281714748-matching-rows-in-excel-and-finding-out-duplicate-rows-my_contacts
Sheet: Sheet1

Company Name | First Name | Last Name | Job Title | Address 1 | Phone | Website
Big Design | [NAME] | Love | Sales Manager | 11 NY, USA | 123-456-567 | www.bigdesign.com
Big Design | Stephen | Gills | Director | 12 NY, USA | 123-456-568 | www.bigdesign.com
Big Design | [NAME] | McKay | CEO | 13 NY, USA | 432-455-354 | www.bigdesign.com
ABC LLC | [NAME] | Soll | President | Garden Town, LA, USA | 542-123-123 | www.abc.com
ABC LLC | [NAME] | Fard | Technician | 415 M Town, UK | 453-989-876 | www.abc.com
ABC LLC | [NAME] | Higg | Director | 818 Melbourne, Australia | 453-989-877 | www.abc.com |  | As there is possibility of duplicate rows
Future Ltd | [NAME] | Tilds | Assistant | 12, NY, USA | 233-111-111 | www.futureltd.com |  | Now I want unique rows in sheet 2
Future Ltd | Beny | Hard | Vice Executive | 33, UK | 101-000-000 | www.futureltd.com |  | and want to see duplicate rows in sheet 3 that were removed in sheet2
Future Ltd | [NAME] | Farris | CFO | 34, New Zeland | 103-340-009 | www.futureltd.com
Digital Torch | Jet | [NAME] | Technician | 12, Australia | 124-009-007 | www.digital.com
Digital Torch | Johny | Mac | Designer | 12, Australia | 124-009-008 | www.digital.com
Digital Torch | [NAME] | Rid | [NAME] | 12, Australia | 124-009-009 | www.digital.com
Big Design | [NAME] | Love | Sales Manager | 11 NY, USA | 123-000-000
Green llc | Stephen | Gills | Director | 123, Texas, USA | 543-333-233 | www.bigdesign.com
Green llc | [NAME] | McKay | CEO | 34B, London, UK | 432-455-354 | www.bigdesign.com
Angry [NAME] | [NAME] | Tilds | Technician | 333, NYC , USA | 111-111-111 | www.angryfox.com
TP21 Company | [NAME] | Mott |  |  | 101-101-909
 | [NAME] | Mobile |  | 33, NY
ABC LLC | [NAME] | Soll | President | Garden Town, LA, USA | 542-123-123 | www.abc.com
 | Ramon | Hobbs | Secretary | 123, AB, USA | 123-101-100
ABC LLC | [NAME] | Fard | Technician | Town, UK | 453-989-876 | www.abc.com
ABC LLC | [NAME] | Higg | Director | 818 Melbourne, Australia | 456-678-876 | www.abc.com
 | [NAME] | Folder | Sales
Future Ltd | [NAME] | Tilds | Assistant | 12, NY, USA | 233-111-111 | www.futureltd.com
 | [NAME] | [NAME] | Production |  | 345-345-444
 | [NAME] | Bond |  | VP | 165-827-272
Future Ltd | Beny | Hard | Vice Executive | 33, UK | 101-000-000
Future Ltd | [NAME] | Farris |  | 34, New Zeland | 103-340-009 | www.futureltd.com
 | [NAME] |  |  |  | 102-090-292
Spreadsheet: 849800d1700188353-checkbox-in-cells-f1ash-tracker
Sheet: Sheet1

Candidate | Task 1 | Task 2 | Task 3 | Task 4 | Task 5 | %
Candidate 1 | True | True | True | False | False
Candidate 2 | False | True | True | False | False
Candidate 3 | False | False | True | False | False
Candidate 4 | False | False | False | True | True
Candidate 5 | False | False | False | False | False
Candidate 6 | False | False | False | False | False
Candidate 7 | False | False | False | False | False
Candidate 8 | False | False | False | False | False
Candidate 9 | False | False | False | False | False
Candidate 10 | False | False | False | False | False
Candidate 11 | False | False | False | False | False
Candidate 12 | False | False | False | False | False
Candidate 13
Spreadsheet: sally_beck__35194__EGM_MgmtSum-Q4-1019
Sheet: CapChrg-AllocExp

PLAN2000
CAP_CHRG | ENRON GLOBAL MARKETS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
TOT_ALLOCATION | 4TH QUARTER 2000 CAPITAL CHARGE & ALLOCATED EXPENSES
2000-12-01 00:00:00
M.QTD
ENA
 |  |  | Capital Charge |  |  |  |  |  |  | Allocated Expenses
 | Business Team |  | Forecast | Plan | [NAME] | Explanation |  |  |  | Forecast | Plan | [NAME] | Explanation
 | Liquids |  | 0 | 0 |  |  |  |  |  |  | 7846 |  | Unplanned Legal & IT Expenses
COAL | Coal |  | 658
SO2 | Emissions
WEATHER | Weather
INSURANCE | Global Risk Markets |  | 0
ECT_INV_IRFX | Financial Trading
 | Transportation |  | 0 | 0 |  |  |  |  |  | 0 | 0
 | Subtotal
 | LNG |  | -188 |  |  |  |  |  |  | 0 | 0
 | Middle East |  | 652 | 652 |  |  |  |  |  | 0 | 0
 | Puerto Rico |  | 0 | 0 |  |  |  |  |  | 0 | 0
 | Subtotal Commercial
 | Office of the Chairman |  | 0 | 0 |  |  |  |  |  |  | 0
 | Total
 | [NAME] |  |  |  |  |  |  |  |  | 0 | 0
 | Group Allocated to Teams |  | 0 | 0
 | Total
Spreadsheet: 679078d1590171803-how-do-i-use-a-row-number-in-a-formula-use-row-number-in-formula
Sheet: Sheet1

Month | Cheeses eaten
January | 6
February | 5
March | 3
April | 17
May | 41
June | 2
July | 11
August | 9
September | 473
October | 8
November | 8
December | 14.6
Row number
January
February
March
April | etc
May
June
July
August
September
October
November
December
Results
Until April
(for example)
Spreadsheet: larry_campbell__21016__Topock Pigging Program
Sheet: Page 5 

Revised |  | 2001-08-27 00:00:00 |  |  |  |  |  | Liquid
Date |  | Location | Type of Pig | Solvent | Solvent | Lateral | Sample I.D. | Volume | Analytical | Units | Comments
 |  | of Sample |  | Injected | Volume | Volume |  | Collected | Result
2000-10-30 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 295 mmcf |  | 0 |  |  | No liquid received with pig 97
2000-11-14 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 217 mmcf |  | 0 |  |  | No liquid received with pig 98
2000-11-27 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 261 mmcf |  | 0 |  |  | No liquid received with pig 99
2000-12-11 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 278 mmcf |  | 0 |  |  | No liquid received with pig 100
2001-01-02 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 292 mmcf |  | 0 |  |  | No liquid received with pig 101
2001-01-18 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 278 mmcf |  | 0 |  |  | No liquid received with pig 102
2001-01-29 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 312 mmcf |  | 0 |  |  | No liquid received with pig 103
2001-02-12 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 290 mmcf |  | 0 |  |  | No liquid received with pig 104
2001-02-26 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 253 mmcf |  | 0 |  |  | No liquid received with pig 105
2001-03-12 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 300 mmcf |  | 0 |  |  | No liquid received with pig 106
2001-03-26 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 303 mmcf |  | 0 |  |  | No liquid received with pig 107
2001-04-09 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 72 mmcf |  | 0 |  |  | No liquid received with pig 108
2001-04-23 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 70 mmcf |  | 0 |  |  | No liquid received with pig 109
2001-05-07 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 161 mmcf |  | 0 |  |  | No liquid received with pig 110
2001-05-25 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 220 mmcf |  | 0 |  |  | No liquid received with pig 111
2001-06-04 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 190 mmcf |  | 0 |  |  | No liquid received with pig 112
2001-06-18 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 140 mmcf |  | 0 |  |  | No liquid received with pig 113
2001-07-13 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 172 mmcf |  | 0 |  |  | No liquid received with pig 114
2001-07-23 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 160 mmcf |  | 0 |  |  | No liquid received with pig 115
2001-08-06 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 200 mmcf |  | 0 |  |  | No liquid received with pig 116
2001-08-20 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 230 mmcf |  | 0 |  |  | No liquid received with pig 117
2001-09-06 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 190 mmcf |  | 0 |  |  | No liquid received with pig 118
Spreadsheet: eab740f5-d0ab-407e-a7ed-be06b6a96edb
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Oppføringer fra [NAME]
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
NILSEN WIRELESS CONSULTING | [NAME] | 1177 | Oslo
ASGAUT ENG SOFTWARE | Fugleliveien 23J | 0667 | Oslo | 22 19 93 86
NOMEDIA Lars Olav Mørch | [NAME] | 0271 | Oslo | 23 08 30 26 | 23 08 30 26
VIRK PROGRESSIVE IMPORT | [NAME] vei 21 | 0987 | Oslo
FRODE PETERSEN | Damliveien 4 | 0275 | Oslo | 23 29 45 13 | 22 73 13 32
OVER ALT CHRISTIAN LEXOW ANDERSSON | Olaf Bulls vei 12 | 0765 | Oslo
BOOMERANG TELECOM [NAME] | Solbergsliveien 116 A | 0683 | Oslo | 22 75 59 31
ERGO TELECOM [NAME] | Darres gate 14 | 0175 | Oslo | 22 37 26 02 | 22 37 26 03
TELLEVERKET ARONSEN | [NAME] | 0681 | Oslo | 22 26 77 77 | 22 26 43 60
[NAME] | Herslebs gate 34B | 0578 | Oslo | 22 68 76 21
TELECOMKONSULENT STIG MARTINSEN | Etterstadsletta 96 | 0659 | Oslo | 924 02 232
OSLO TELECOM MIRZA | Enebakkveien 77 | 0196 | Oslo
DAR ENTERPRISES [NAME] | Tøyengata 15 | 0190 | Oslo | 22 57 20 28 | 22 19 42 57
NESS DATA Christian Ness | Balders gate 7C | 0263 | Oslo
SATCOM CONSULTING Jens Christian Riis |  | 0683 | Oslo
ER LA TELE AB | c/o Ontel AS Rønningveien 6 | 0494 | Oslo
PENTA CONSULTING LIMITED BRANCH OFFICE NORWAY | c/o Hurd Utvikling AS Klingenberggata 7 A | 0161 | Oslo
FREDSKOV CONSULTING |  | 0585 | Oslo
IP MEDIA SYSTEMS - GREGER | [NAME] 33 | 0484 | Oslo
TARAN WORLD WIDE MONEY TRANSFER DEK ABDI DOFIL | Åkebergveien 36A | 0650 | Oslo
TOP DIENSLEITUNGS- UND SERVICE GMBH |  | 0273 | Oslo
KRISTIN O LØKKEN CONSULTING | [NAME] gate 54A | 0267 | Oslo
DATA POINT HASSONA |  | 0185 | Oslo
GETRONICS GLOBAL SERVICES BV | Dronning Eufemias gate 8 | 0191 | Oslo | 02316 | 22 05 10 10
BABS PAYLINK AS |  | 0666 | Oslo
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 172459d1344225324-extracting-required-values-from-one-filename-into-separate-columns-extracting-values-from-filesname
Sheet: Sheet1

 |  |  |  |  |  | HOW I WANT THEM TO BE EXTRACTED
Filesname | Date |  |  |  |  | TYPE | PN | SN | OPN | Date
44WDS_SO#_PN#2054085-30-01_SN#112092198.pdf | 2014-06-16 00:00:00 |  |  |  |  | WDS | 2054085-30-01 | 112092198 |  | 2014-06-16 00:00:00
44WDS_SO#_PN#2054085-30-01_SN#112092200.pdf | 2014-06-17 00:00:00 |  |  |  |  | WDS | 2054085-30-01 | 112092200 |  | 2014-06-17 00:00:00
44WDS_SO#_PN#2054085-30-01_SN#112094967.pdf | 2014-06-18 00:00:00 |  |  |  |  | WDS | 2054085-30-01 | 112094967 |  | 2014-06-18 00:00:00
44WDS_SO#_PN#2054085-30-01_SN#112095048.pdf | 2014-06-19 00:00:00 |  |  |  |  | WDS | 2054085-30-01 | 112095048 |  | 2014-06-19 00:00:00
44WDS_SO#_PN#2054085-30-01_SN#112095049.pdf | 2014-06-20 00:00:00 |  |  |  |  | WDS | 2054085-30-01 | 112095049 |  | 2014-06-20 00:00:00
44WDS_SO#_PN#2054085-30-01_SN#112176145.pdf | 2014-06-21 00:00:00 |  |  |  |  | WDS | 2054085-30-01 | 112176145 |  | 2014-06-21 00:00:00
44WDS_SO#_PN#2054085-30-01_SN#112176146.pdf | 2014-06-22 00:00:00 |  |  |  |  | WDS | 2054085-30-01 | 112176146 |  | 2014-06-22 00:00:00
44WDS_SO#_PN#2054085-30-01_SN#112176147.pdf | 2014-06-23 00:00:00 |  |  |  |  | WDS | 2054085-30-01 | 112176147 |  | 2014-06-23 00:00:00
44WDS_SO#_PN#2054085-30-01_SN#112176228.pdf | 2014-06-24 00:00:00 |  |  |  |  | WDS | 2054085-30-01 | 112176228 |  | 2014-06-24 00:00:00
44DIM_SO#_PN#2054085-30-01_SN#112092198_OPN1200/1300/1400/1800pdf | 2014-06-25 00:00:00 |  |  |  |  | DIM | 2054085-30-01 | 112092198 | 1300 | 2014-06-25 00:00:00
44DIM_SO#_PN#2054027-30-01_SN#112092888_OPN200/300/1400pdf | 2014-06-26 00:00:00 |  |  |  |  | DIM | 2054085-30-01 | 112092198 | 1400 | 2014-06-25 00:00:00
 |  |  |  |  |  | DIM | 2054085-30-01 | 112092198 | 1800 | 2014-06-25 00:00:00
 |  |  |  |  |  | DIM | 2054027-30-01 | 112092888 | 300 | 2014-06-26 00:00:00
 |  |  |  |  |  | DIM | 2054027-30-01 | 112092888 | 1400 | 2014-06-26 00:00:00
Spreadsheet: 176344d1345820683-ranking-compiled-data-from-different-worksheets-compilation-of-keywords
Sheet: Restaurants - PHRASE

Keyword | Competition | Global Monthly Searches | Local Monthly Searches (Canada)
"west island restaurants" | 0.14 | 1000 | 1000
"resto montreal" | 0.03 | 18100 | 18100
"montreal restaurants" | 0.05 | 14800 | 12100
"restaurants in montreal" | 0.11 | 9900 | 6600
"portovino restaurant" | 0.05 | 720 | 480
"indian restaurant west island" | 0.2 | 73 | 73
"italian restaurants west island" | 0.09 | 73 | 58
"la perle west island" | 0.02 | 28 | 28
"best west island restaurants" | 0.08 | 22 | 22
"best restaurants in west island" | 0.11 | 22 | 22
"greek restaurant west island" | 0.02 | 16 | 16
"karma restaurant west island" | 0.02 | 16 | 12
"restaurants in west island montreal" | Low | 58 | 58
"west island listings" | Low | 46 | 46
Spreadsheet: 792724d1661102687-splitting-numbers-from-texts-split-numbers-from-texts
Sheet: Sheet1

 | Desired Result
Copied Data | + | - | HansDouwe |  | [NAME] |  | Bo_Ry
MBB CT-16 - 18 food
01/07 CHEQUE PROCESSING FEE .50- 289,723.85 |  | 0.5
01/07 INTER-BANK PAYMENT INTO A/C 906.30- 290,630.15 | 906.3
01/07 INTER-BANK PAYMENT INTO A/C 115.76- 290,745.91 | 115.76
02/07 CMS - CR PYMT MARS 838.44+ 291,584.35 | 838.44
02/07 TRANSFER TO A/C 166.10+ 291,750.45 | 166.1
02/07 TRANSFER TO A/C 237.05+ 292,384.45 | 237.05
02/07 TRANSFER FR A/C 300.00- 292,084.45 |  | 300
Spreadsheet: a66602d1-5f4a-4e1e-bbc2-7b88eabc8bb1
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
9172 | Test | 9172 | Bone Marrow Biopsy | Bone [NAME] | Includes tissue processing, hematoxylin-and-eosin stain, iron stain, and additional stains if necessary for interpretation. A pathology consultation is also included and is charged separately. | [NAME], leak proof vial: ScwLkPf |  |  |  | Varies | [NAME] marrow, fixed marrow core  Container/Tube: Bone marrow container with saline Specimen Volume: Entire specimen Collection Instructions: Fix specimen in formalin for 1 to 2 hours. Additional Information: 1. A pathology/diagnostic report and a brief history are required. 2. When ordering this test, 5434 Hematopathology Consultation must be ordered on the same order. 3. See Laboratory Screening Tests for Suspected Multiple Myeloma in Special Instructions. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	Bone marrow core | An interpretive report will be provided. | Monday through Friday; Varies | 3 days | 7 days |  | Profile |  |  |  |  | Rochester
9172 | [NAME] | BNMARW | Bone Marrow |  |  |  | Ambient
9172 | Result | 9172 | Bone Marrow fix sect | Bone Marrow fix sect |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
9172 | Billing Component | 9172 |  | Surgical path, goss and microscopic |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 88305
9172 | Billing Component | 9172 |  | Decalcification |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 88311
Spreadsheet: 81e2cb13-5e6a-4987-8a2e-da37891521d1
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
MNU | Test | MNU | Manganese, 24 Hour, [NAME] | Manganese, 24 Hr, U | Dynamic Reaction Cell-Inductively Coupled Plasma-Mass Spectrometry (DRC-ICP-MS) | [NAME], 24-hour graduated: 24Urine |  |  | 10 | mL | Collection Container/Tube: Clean, plastic urine container with no metal cap or glued insert Submission Container/Tube: Plastic, 10-mL urine tube (Supply T068) or clean, plastic aliquot container with no metal cap or glued insert  [NAME]: 10 mL Collection Instructions: 1. Collect urine for 24 hours. 2. No preservative. 3. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. 4. Refrigerate specimen within 4 hours of completion of 24-hour collection. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections. 3. High concentrations of gadolinium and iodine are known to interfere with most metals tests. If gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours.   Urine Preservative Collection Options Ambient	Yes Refrigerated	Preferred Frozen	Yes 6N HCl	No 50% Acetic Acid	No Na2CO3	No Toluene	No 6N HNO3	No Boric Acid	No Thymol	No | 0.4 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0-15 years: not established > or =16 years: 0.1-1.2 mcg/specimen | Tuesday, Thursday; 3 p.m. | 1 day | 5 days | 1 | 83785 |  |  |  |  | Rochester
MNU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
MNU | Order Question | TM26 | Collection Duration |  | Plain Text
MNU | Order Question | VL24 | [NAME] |  | Plain Text
MNU | Result | 8080 | Manganese, 24 Hr, U | Manganese, 24 Hr, U | Numeric |  |  |  |  | mcg/spec |  |  |  |  |  |  |  |  |  | 8203-2 | Manganese:MRat:24H:[NAME]:Qn:
MNU | Result | TM26 | Collection Duration | Collection Duration | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13362-9 | Collection duration:Time:*:Urine:Qn:
MNU | Result | VL24 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3167-4 | [NAME] volume:Vol:24H:[NAME]:Qn:
MNU | Result | 867 | Mn Concentration | Mn Concentration | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 21382-7 | Manganese:MCnc:24H:[NAME]:Qn:
Spreadsheet: 42588d1241118455-sumifs-hlookup-test-1
Sheet: Schedule

Total Available Work Hours per Week |  | 40 | 10 | 40 | 40 | 40 | 40 | 40 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50
Name/Week Starting |  | 2009-08-02 00:00:00 | 2009-08-09 00:00:00 | 2009-08-16 00:00:00 | 2009-08-23 00:00:00 | 2009-08-30 00:00:00 | 2009-09-06 00:00:00 | 2009-09-13 00:00:00 | 2009-09-20 00:00:00 | 2009-09-27 00:00:00 | 2009-10-04 00:00:00 | 2009-10-11 00:00:00 | 2009-10-18 00:00:00 | 2009-10-25 00:00:00 | 2009-11-01 00:00:00 | 2009-11-08 00:00:00 | 2009-11-15 00:00:00 | 2009-11-22 00:00:00 | 2009-11-29 00:00:00 | 2009-12-06 00:00:00 | 2009-12-13 00:00:00 | 2009-12-20 00:00:00 |  | Over/Under
Old McDonald | Target
Budget Hours | Budget
Actual Hours Billed | Actual
Workload |  | scratching my butt | scratching my butt | Picking nose | Picking nose | Picking nose | scratching my butt | hicking a loogie | thanking the excel help team | thanking the excel help team | hicking a loogie | Picking nose | thanking the excel help team | going to pee | Picking nose | going to poop | going to poop |  |  |  | going to pee | going to poop
Old McDonald | Target
Budget Hours | Budget
Actual Hours Billed | Actual
Workload |  | scratching my butt | scratching my butt
Old McDonald | Target
Budget Hours | Budget
Actual Hours Billed | Actual
Workload |  | going to pee
 | Target
 | Budget
 | Actual
[NAME] | Target
Budget Hours | Budget
Actual Hours Billed | Actual
Workload
[NAME] | Target
Budget Hours | Budget
Actual Hours Billed | Actual
Workload
[NAME] | Target
Budget Hours | Budget
Actual Hours Billed | Actual
Workload
 | Target
 | Budget
 | Actual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Target %
Spreadsheet: 64687b70-1472-4d93-bbe1-c89b60f1562a
Sheet: So San Francisco

REGIONAL DIRECTORY 2014/2015
SOUTH SAN FRANCISCO UNIFIED SCHOOL DISTRICT
[NAME], Superintendent | [NAME], Director of Business Services | Dr. [NAME], Director of Categorical Programs
398 B Street | 398 B Street | 398 B Street
South San Francisco, CA 94080 | South San Francisco, CA 94080 | South San Francisco, CA 94080
O: [PHONE] | O: [PHONE] | O: [PHONE]
F: [PHONE] | F: [PHONE] | F: [PHONE]
[EMAIL] | [EMAIL] | [EMAIL]
[NAME], [NAME]
398 B Street
South San Francisco, CA 94080
O: [PHONE]
F: [PHONE]
[EMAIL]
Spreadsheet: 105050d1302532054-how-to-add-extra-criteria-to-sumproduct-formula-tstii
Sheet: Yes-No

City | Amount that will drop | Amount that will not drop | Past due percentage | Break down of loans that will not drop | Active ARMS Loans | Matured ARMS Loans | Active Loans | Matured Loans
Brownsville | 9384316.65 | 3491502.3 |  |  |  |  |  |  | 1
[NAME] | 1048107 | 5002241.93 |  |  |  |  |  |  | 0
Corpus Christi | 802871.12 | 769646.7299999999 |  |  |  |  |  |  | 0
East Texas | 2968368.06 | 2430631.88 |  |  |  |  |  |  | 0
Harlingen | 374436.94 | 5541152.010000001 |  |  |  |  |  |  | 0
Houston | 4280775.850000001 | 13247414.04 |  |  |  |  |  |  | 0
International | 2772177.17 | 995194.4299999999 |  |  |  |  |  |  | 0
Laredo | 8085751.859999999 | 9418373.73 |  |  |  |  |  |  | 0
[NAME] | 9323143.879999999 | 6118496.46 |  |  |  |  |  |  | 0
Mission | 11562099.05 | 4658231.51 |  |  |  |  |  |  | 0
Weslaco | 2465118.42 | 526303.86 |  |  |  |  |  |  | 0
Total | 53067166 | 52199188.88
Sum | 105266354.88
Spreadsheet: 858842d1707366258-count-numbers-greater-than-zero-in-both-cells-new-microsoft-excel-worksheet
Sheet: Sheet1

Retailer Name | PCNO 100ML | PCNO 200ML | Manual Result
Dulal Store | 2 | 1 | 1
[NAME] | 3 | 0 | 0
Alaur Store | 12 | 6 | 1
[NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0
Bipul [NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0
Jan store | 0 | 0 | 0
[NAME] | 2 | 12 | 1
Ongon Cosmatic | 0 | 0 | 0
Modina supar store | 1 | 6 | 1
[NAME] | 0 | 3 | 0
Nasim Brathers | 0 | 0 | 0
[NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0
[NAME] | 0 | 0 | 0
Spreadsheet: 879504d1727086645-if-or-xlookup-with-multi-conditions-including-return-highest-value-and-closest-text-match-xlookup-multi-conditions-highest-no-closest-text-match-1-
Sheet: Sheet1

 |  |  |  | Position | Employee ID | PAAF No. | Name | [NAME] |  |  |  |  |  | Emp ID | No | Name | LOC | Position
 |  |  |  | PCM | 50563 |  | C [NAME] | 023-1 |  | 1st formula - As there is an employee ID in column F look that up in colum O & return HIGHEST corresponding no. in column P
 |  |  |  | PCM |  | 048-1 | [NAME] | 048-1 |  | 2nd formula - Lookup name in column H, find closest match in column Q & return highest corresponding no. in column P |  |  |  |  | 048-0 | Kelsall, [NAME] | 1 | PCM
 |  |  |  | ABC |  | 050-1 |  | 050-1 |  | 3rd formula - As no employee ID nor name, lookup position in column E & find match in column S & return highest no. in column P |  |  |  |  | 048-1 | Kelsall, [NAME] | 1 | PCM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50563 | 023-0 | Norris, [NAME] | 2 | PCM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50563 | 023-1 | Norris, [NAME] | 2 | PCM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 050-1 |  |  | ABC
 |  |  |  |  |  |  |  |  |  | Join 1st, 2nd & 3rd formula together, eg IF there's a value in column F then do 1st formula otherwise do either 2nd formula (based on name) or 3rd formula (lookup the position in E to S)