tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 04cf7da7-f86f-46f3-824a-a5747bdb8444
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
HYOX | Test | HYOX | Hyperoxaluria Panel, [NAME] | Hyperoxaluria Panel, U | Gas Chromatography-Mass Spectrometry (GC-MS) | [NAME]: Urine |  |  | 10 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 10 mL Collection Instructions:  1. Fasting-overnight (12-14 hours). 2. Have patient void the first-morning specimen, then collect specimen within 2 hours of first-morning void while patient continues to fast. Fluids are allowed. 3. No preservative. 4. Immediately freeze specimen. Forms: 1. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 2. If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 1.1 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | GLYCOLATE 0-31 days: 0-57 mg/g creatinine 1-5 months: 0-54 mg/g creatinine 6-12 months: 0-60 mg/g creatinine 1-5 years: 0-89 mg/g creatinine  > or =6 years: 0-78 mg/g creatinine  GLYCERATE 0-31 days: 0-38 mg/g creatinine 1-5 months: 0-71 mg/g creatinine  6-12 months: 0-56 mg/g creatinine 1-5 years: 0-17 mg/g creatinine  > or =6 years: 0-8 mg/g creatinine  OXALATE 0-31 days: 0-301 mg/g creatinine 1-5 months: 0-398 mg/g creatinine 6-12 months: 0-280 mg/g creatinine  1-5 years: 0-128 mg/g creatinine 6-10 years: 0-72 mg/g creatinine  > or =11 years: 0-56 mg/g creatinine  GLYOXYLATE 0-31 days: 0.0-7.9 mg/g creatinine 1-5 months: 0.0-11.4 mg/g creatinine 6-12 months: 0.0-5.5 mg/g creatinine 1-5 years: 0.0-3.9 mg/g creatinine > or =6 years: 0.0-2.9 mg/g creatinine | Varies; Batched 1 time per month; 8 a.m. | 14 days |  | 1 | 82544 |  |  |  |  | Rochester
HYOX | [NAME] | URINE | [NAME] |  |  |  | Frozen | 406 days
HYOX | Result | 50592 | Glycolate | Glycolate | Numeric |  |  |  |  | mg/g Cr |  |  |  |  |  |  |  |  |  | 13751-3 | Glycolate/Creatinine:MRto:Pt:[NAME]:Qn:
HYOX | Result | 50593 | Glycerate | Glycerate | Numeric |  |  |  |  | mg/g Cr |  |  |  |  |  |  |  |  |  | 13749-7 | Glycerate/Creatinine:MRto:Pt:[NAME]:Qn:
HYOX | Result | 50594 | Oxalate | Oxalate | Numeric |  |  |  |  | mg/g Cr |  |  |  |  |  |  |  |  |  | 13483-3 | Oxalate/Creatinine:MRto:Pt:[NAME]:Qn:
HYOX | Result | 50595 | Glyoxylate | Glyoxylate | Numeric |  |  |  |  | mg/g Cr |  |  |  |  |  |  |  |  |  | 13752-1 | Glyoxylate/Creatinine:MRto:Pt:[NAME]:Qn:
HYOX | Result | 29982 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2
HYOX | Result | 29984 | Reviewed By | Reviewed By | Numeric
Spreadsheet: phillip_m_love__30153__9904_OA
Sheet: EAST-EGM-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  NORTHEAST
 |  |  | Total |  | Reclasses |  |  |  |  |  | June |  |  |  |  |  | September |  |  |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  |  |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 85717 | 162690.87
14 |  | Cash Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -14468 | -28936
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -71249 | -135230
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance |  |  |  |  |  |  |  | 0
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-East
 |  | Current Month MTM |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 724025d1615991655-last-10-results-last-10
Sheet: DATI

 |  |  |  |  |  |  |  |  | TOT | ID
 |  |  |  |  |  |  |  |  | 1-1 | 330
 |  |  |  |  |  |  |  |  | 2-0 | 330
 |  |  |  |  |  |  |  |  | 1-0 | 320
 |  |  |  |  |  |  |  |  | 0-0 | 320
 |  |  |  |  |  |  |  |  | 2-0 | 330
 |  |  |  |  |  |  |  |  | 2-1 | 330
 |  |  |  |  |  |  |  |  | 3-2 | 330
 |  |  |  |  |  |  |  |  | 1-1 | 320
 |  |  |  |  |  |  |  |  | 2-1 | 320
 |  |  |  |  |  |  |  |  | 2-0 | 320
 |  |  |  |  |  |  |  |  | 0-0 | 350
 |  |  |  |  |  |  |  |  | 2-2 | 350
 |  |  |  |  |  |  |  |  | 6-2 | 350
 |  |  |  |  |  |  |  |  | 2-0 | 330
 |  |  |  |  |  |  |  |  | 3-0 | 330
 |  |  |  |  |  |  |  |  | 3-1 | 320
 |  |  |  |  |  |  |  |  | 2-0 | 320
 |  |  |  |  |  |  |  |  | 2-1 | 320
 |  |  |  |  |  |  |  |  | 2- | 320
 |  |  |  |  |  |  |  |  | 1-1 | 320
 |  |  |  |  |  |  |  |  | 2-0 | 320
 |  |  |  |  |  |  |  |  | 1-0 | 340
 |  |  |  |  |  |  |  |  | 1-1 | 340
 |  |  |  |  |  |  |  |  | 2-1 | 340
 |  |  |  |  |  |  |  |  | 0- | 340
 |  |  |  |  |  |  |  |  | 4-2 | 340
 |  |  |  |  |  |  |  |  | - | 340
 |  |  |  |  |  |  |  |  | 1-0 | 340
 |  |  |  |  |  |  |  |  | 0-0 | 320
 |  |  |  |  |  |  |  |  | 2-2 | 330
 |  |  |  |  |  |  |  |  | 3-2 | 330
 |  |  |  |  |  |  |  |  | 0-0 | 330
 |  |  |  |  |  |  |  |  | 1-1 | 350
 |  |  |  |  |  |  |  |  | 7-0 | 350
 |  |  |  |  |  |  |  |  | 1-1 | 350
 |  |  |  |  |  |  |  |  | 5-1 | 350
 |  |  |  |  |  |  |  |  | 0-0 | 350
 |  |  |  |  |  |  |  |  | 0-0 | 350
 |  |  |  |  |  |  |  |  | 0-0 | 350
 |  |  |  |  |  |  |  |  | 1-1 | 350
 |  |  |  |  |  |  |  |  | 0-0 | 350
 |  |  |  |  |  |  |  |  | 2-2 | 350
 |  |  |  |  |  |  |  |  | 1-0 | 350
 |  |  |  |  |  |  |  |  | 5-2 | 350
 |  |  |  |  |  |  |  |  | 2-0 | 350
 |  |  |  |  |  |  |  |  | 3-2 | 350
 |  |  |  |  |  |  |  |  | 1-0 | 350
 |  |  |  |  |  |  |  |  | 1-1 | 350
 |  |  |  |  |  |  |  |  | 2-2 | 350
 |  |  |  |  |  |  |  |  | 0-0 | 350
 |  |  |  |  |  |  |  |  | 0-0 | 350
 |  |  |  |  |  |  |  |  | 2-1 | 350
 |  |  |  |  |  |  |  |  | 3-1 | 320
 |  |  |  |  |  |  |  |  | 2-0 | 320
 |  |  |  |  |  |  |  |  | 1-1 | 320
 |  |  |  |  |  |  |  |  | 3-2 | 320
 |  |  |  |  |  |  |  |  | 15-7 | 320
 |  |  |  |  |  |  |  |  | 2-0 | 320
 |  |  |  |  |  |  |  |  | 1-0 | 320
 |  |  |  |  |  |  |  |  | 3-0 | 320
 |  |  |  |  |  |  |  |  | 4-1 | 320
 |  |  |  |  |  |  |  |  | 1-1 | 340
 |  |  |  |  |  |  |  |  | 3-1 | 340
 |  |  |  |  |  |  |  |  | 2-1 | 340
 |  |  |  |  |  |  |  |  | 2-1 | 340
 |  |  |  |  |  |  |  |  | 0-0 | 340
 |  |  |  |  |  |  |  |  | 1-1 | 340
 |  |  |  |  |  |  |  |  | 1-0 | 340
 |  |  |  |  |  |  |  |  | 0-0 | 340
 |  |  |  |  |  |  |  |  | 0-0 | 340
 |  |  |  |  |  |  |  |  | 5-2 | 330
 |  |  |  |  |  |  |  |  | 1-0 | 330
 |  |  |  |  |  |  |  |  | 2-1 | 330
 |  |  |  |  |  |  |  |  | 3-1 | 330
 |  |  |  |  |  |  |  |  | 0-0 | 330
 |  |  |  |  |  |  |  |  | 1-0 | 330
 |  |  |  |  |  |  |  |  | 2-2 | 330
Spreadsheet: 849041d1699609670-unique-count-function-test2
Sheet: Sheet1

 | Fund 1 | Fund 2 |  |  |  |  | Product Name | Name | Sector | weight
No. of Holdings |  | 3 |  |  |  |  | Fund 1 | Apple | A | 0.098
 |  |  |  |  |  |  | Fund 1 | Apple | A | 0.062
Concentration of top 3 |  |  |  |  |  |  | Fund 1 | Alphabet | B | 0.081
should be | 0.461 | 0.203 |  |  |  |  | Fund 1 | Alphabet | B | 0.059
 |  |  |  |  |  |  | Fund 1 | Alphabet | B | 0.033
 |  |  |  |  |  |  | Fund 1 | TSMC | A | 0.093
 |  |  |  |  |  |  | Fund 1 | TSMC | A | 0.035
 |  |  |  |  |  |  | Fund 1 | AON | C | 0.045
 |  |  |  |  |  |  | Fund 1 | Tesla | D | 0.071
 |  |  |  |  |  |  | Fund 1 | Bond | Cash | 0.028
 |  |  |  |  |  |  | Fund 2 | Meta | B | 0.041
 |  |  |  |  |  |  | Fund 2 | Meta | B | 0.025
 |  |  |  |  |  |  | Fund 2 | Microsoft | A | 0.035
 |  |  |  |  |  |  | Fund 2 | Bond | Cash | 0.079
 |  |  |  |  |  |  | Fund 2 | Bond | Cash | 0.042
 |  |  |  |  |  |  | Fund 2 | Mastercard | C | 0.05
 |  |  |  |  |  |  | Fund 2 | Mastercard | C | 0.052
Spreadsheet: 1f566ddf-27d1-4ebe-9550-62502bdad480
Sheet: Sheet1

Five A. fumigatus loci exibiting trans-species polymorphism | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  | % identity to orthologous genes in target genomes
Af293 gene | Protein name | A1163 | N.fischeri | A.clavatus | A.terreus | A.oryzae | A.nidulans
AFUA_2G17420 | Pfs and STAND domain protein | 0.45 | 0.86 | 0.44
AFUA_6G07000 | hypothetical protein | 0.37 | 0.41 | 0.67 |  | 0.4 | 0.42
AFUA_6G07010 | transcription factor RosA | 0.45 | 0.56 | 0.76 | 0.46 | 0.45 | 0.46
AFUA_6G07020 | morphogenesis protein (Boi1) | 0.56 | 0.4 | 0.71 | 0.4 | 0.38 | 0.55
AFUA_6G07030 | STAND domain protein | 0.55 |  | 0.81 |  |  | 0.63
Genome average |  | 1 | 0.95 | 0.8 | 0.73 | 0.69 | 0.61
The table shows % identity between Af293 proteins and their orthologs in other aspergilli
Spreadsheet: 755243d1636731630-formula-time-calculation-2-variables-book4
Sheet: TF_Stripped

 | Patient Demographics |  |  | Alerts | ALERT 1 | ALERT 2 |  |  | 95941 | 60
 | MR#  (Must be 9 digits) |  |  | Modality |  |  |  |  | G0453 | 15
 | Patient Insurance | TC AMERIGROUP COMMUNITY CARE |  | Location
 |  | 95941 |  | Cause
 | Case Information |  |  | Resolution by Case End
 | Procedure Date
 | Hospital |  |  | Billing Time (24 hour format)
 | Diagnosis |  |  | Start Time | 12:00:00
 |  |  |  | End Time | 14:00:00
 | Staff on Case |  |  | Total Billing Time
 | Surgical Service
 | Attending Surgeon
 | Reading Neurologist
 | Co Reading Neurologist
 | IOM Workstation
 | Technologist 1 |  |  | This Excel File Name Is:
 | Technologist 2 |  |  | ,  01-00-00
 | False
Spreadsheet: 865806d1712786563-help-with-line-graph-example-2-
Sheet: Sheet1

 |  | Department | 2024-01-23 00:00:00 | 2024-02-23 00:00:00 | 2024-03-23 00:00:00 | 2024-04-23 00:00:00 | 2024-05-23 00:00:00 | 2024-06-23 00:00:00 | 2024-07-23 00:00:00 | 2024-08-23 00:00:00 | 2024-09-23 00:00:00 | 2024-10-23 00:00:00
 |  | A-End 1st | 3 | 5 | 5 | 4 | 4 | 6 | 5 | 3 | 5 | 7
 |  | A-End 2nd | 4 | 4 | 5 | 6 | 5 | 5 | 8 | 2 | 5 | 0
 |  | A-End 3rd | 5 | 3 | 5 | 7 | 6 | 3 | 6 | 2 | 6 | 8
 |  | B-End 1st | 6 | 2 | 6 | 8 | 7 | 2 | 8 | 7 | 2 | 7
 |  | B-End 2nd | 7 | 1 | 4 | 9 | 8 | 1 | 7 | 1 | 4 | 9
 |  | B-End 3rd | 8 | 2 | 5 | 0 | 9 | 4 | 4 | 4 | 4 | 4
 |  | Tubing 1st | 9 | 3 | 3 | 1 | 9 | 8 | 2 | 5 | 0 | 4
 |  | Tubing 2nd | 0 | 4 | 4 | 2 | 8 | 4 | 7 | 1 | 4 | 9
 |  | [NAME] | 6 | 7 | 10 | 3 | 7 | 4 | 5 | 3 | 5 | 7
Spreadsheet: 09e62364-95be-4ef6-bfe0-4192d52990a5
Sheet: Civilizations-History

CIVILIZATIONS - HISTORY
Course color corresponds with term of offering. BLUE for Spring semester, PURPLE for J-term, GREEN for both Spring and J-term.
 | AOK Designation | Comment
[NAME]
ARTH 210 | Civilizations-History (as HIST 101) | cross-listed with CLAS 210
 | OR Arts & Literature -Arts
Classical Studies
CLAS 210 | Civilizations-History (as HIST 101) | cross-listed with ARTH 210
 | OR Arts & Literature -Arts
History
HIST 100 | Civilizations-History
HIST 101 | Civilizations-History
HIST 111 | Civilizations-History
HIST 112 | Civilizations-History
HIST 381 |  | Non-western | Spring 2013-(The US and SE Asia)
Honors Program
HONR 123 | Civilizations-History (as HIST 101)
HONR 221 | Civilizations-History (as HIST 100 or 111)
HONR 273 | Civilizations-History (as HIST 100)
HONR 283 | Civilizations-History (as HIST 100)
HONR 294 | Civilizations-History (as HIST 101)
Spreadsheet: 90214d1289964161-date-passed-highlight-date-conditional-formating
Sheet: Sheet1

 |  |  | Threshold: | 12
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
Spreadsheet: 811849d1672834737-help-with-vlookup-formula-look-up-table-vertical-and-horizontal-example-12-
Sheet: Table

 | Level
Group | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
B
A
C
Spreadsheet: 154966d1336633367-vat-returns-uk-vat-return
Sheet: Summary

Period Start: | 2012-06-01 00:00:00 |  |  | Period End: |  | Page 1
[NAME] |  |  |  | VAT Collected
Invoice Date | Supplier | [NAME] |  | Invoice Date | Customer | [NAME]
 | TOTAL |  |  |  | TOTAL
 |  |  |  |  | VAT DUE PAGE 1
Period Start: |  |  |  | Period End: |  | Page 2
[NAME] |  |  |  | VAT Collected
Invoice Date | Supplier | [NAME] |  | Invoice Date | Customer | [NAME]
 | TOTAL |  |  |  | TOTAL
 |  |  |  |  | VAT DUE PAGE 1
 |  |  |  |  | VAT DUE PAGE 2
 |  |  |  |  | VAT DUE PAGE 1 + 2
Spreadsheet: 144983d1331235144-excel-2007-data-sheet-date-auto-population-monthselection
Sheet: Sheet1

February
 |  |  |  |  |  | January | 1
 |  |  |  |  |  | February | 2
 |  |  |  |  |  | March | 3
 |  |  |  |  |  | April | 4
 |  |  |  |  |  | May | 5
 |  |  |  |  |  | June | 6
 |  |  |  |  |  | July | 7
 |  |  |  |  |  | August | 8
 |  |  |  |  |  | September | 9
 |  |  |  |  |  | October | 10
 |  |  |  |  |  | November | 11
 |  |  |  |  |  | December | 12
Spreadsheet: 722064d1615026942-return-another-cell-if-one-cell-equals-another-with-formula-return-another-cell-ans
Sheet: Sheet5

10 | 20 | 30 | 40 | 50 | 60
 |  |  |  |  |  |  |  | How can I make I5:N5 equal another value enterd A5:F5 for every row?
1 | 2 | 3 | 4 | 5 | 6
3 | 4 | 1 | 4 | 4 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 40 | 40 | 20
1 | 2 | 6 | 5 | 4 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 | 50 | 40 | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 110 | 60 | 40 | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 160 | 70 | 40 | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 210 | 80 | 40 | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 260 | 90 | 40 | 70
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 310 | 100 | 40 | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 360 | 110 | 40 | 90
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 410 | 120 | 40 | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 460 | 130 | 40 | 110
Spreadsheet: 747140d1631257904-weekend-call-out-duty-list-call-out-list-ans-3
Sheet: Call Out List

2021-01-01 00:00:00
Date | Name | Holiday | Week
 | Bryant |  | 1 |  |  |  | =COUNTIFS(Holidays!$A$8:$A$241,">="&$A3,Holidays!$A$8:$A$241,"<="&$A3+6)
 | Donnell |  | 2 |  |  |  | =IFERROR(TEXT(INDEX(TEXT(Holidays!$A$1:$A$500,"dd-mm-yyyy")&" - "&Holidays!$B$1:$B$500,AGGREGATE(15,6, [NAME]"),"")
 | Hardy |  | 3 | Holiday "M.L.King Jr. Day" comes in the week from 15th Jan 2021 to 21st jan 2021.
 | Lutz |  | 4
 | Martin |  | 5
 | [NAME] |  | 6
 | Molnar |  | 7
 | [NAME] |  | 8
 | Bryant |  | 9
 | Donnell |  | 10
 | Hardy |  | 11
 | Lutz |  | 12
 | Martin |  | 13
 | [NAME] |  | 14
 | Molnar |  | 15
 | [NAME] |  | 16
 | Bryant |  | 17
 | Donnell |  | 18
 | Hardy |  | 19
 | Lutz |  | 20
 | Martin |  | 21
 | Molnar |  | 22
 | [NAME] |  | 23
 | Bryant |  | 24
 | Donnell |  | 25
 | Hardy |  | 26
 | Lutz |  | 27
 | Martin |  | 28
 | Molnar |  | 29
 | [NAME] |  | 30
 | Bryant |  | 31
 | Donnell |  | 32
 | Hardy |  | 33
 | Yaple |  | 34
 | Martin |  | 35
 | Molnar |  | 36
 | Bryant |  | 37
 | [NAME] |  | 38
 | Odutola |  | 39
 | Donnell |  | 40
 | Hardy |  | 41
 | Yaple |  | 42
 | Martin |  | 43
 | Molnar |  | 44
 | Odutola |  | 45
 | [NAME] |  | 46
 | Bryant |  | 47
 | Donnell |  | 48
 | Hardy |  | 49
 | Yaple |  | 50
 | Martin |  | 51
 | Molnar |  | 52
 | Odutola
Spreadsheet: 732932d1621325162-extract-data-with-dependent-dropdown-from-multiple-tables-engine_workbook
Sheet: BOM-Searchbar

BOM-Search
 |  | Select engine type: | Engine_A
 |  | Select specific engine: | A245_Fuel
Engine_A |  |  |  |  | level | type | components | description | quantity
A033_Diesel
A055_Diesel
Engine_B
A122_Gas
A144_Gas
Engine_C
A245_Fuel
A288_Fuel
A290_Fuel
Engine_D
A322_Electric
A366_Electric |  |  |  |  |  | Returned data
Engine_A
Engine_B
Engine_C
Engine_D
Spreadsheet: 809633d1671191270-how-to-prevent-duplicate-outcome-in-excel-formula-excel-forum-help_how-to-prevent-duplicate-outcom-in-formula
Sheet: Sheet1

Channel Partner | Total Stock Days |  | Conclusion
[NAME] (Jodhpur) | 40 |  |  | Here, I want to prevent duplicate outcome.
[NAME] (Osian) | 31
Fair Deal (Jodhpur-3) | 29 |  | Matoshree (Phalodi), [NAME] ([NAME]) (21 Days & 21 Days)
Sohan Communication Private Limited (Jodhpur-4) | 38
Matoshree (Phalodi) | 21
[NAME] (Jaisalmer) | 21
Global System(Pali) | 38
[NAME] ([NAME]) | 36
[NAME] (Balotra) | 27
Adarsh [NAME] (Jalore) | 31
[NAME] (Sanchor) | 28
Gaurav Marketing (Sirohi) | 37
Spreadsheet: 870328d1716878212-conditional-formating-2-consecutive-value-greater-than-x-value-test-conditional-1-1-aligw
Sheet: Sheet1

May.23 |  | June.23 |  | [NAME] |  | Aug.23 |  | Sep.23 |  | Oct.23
Breakdown Times | Breakdown Days | Breakdown Times | Breakdown Days | Breakdown Times | Breakdown Days | Breakdown Times | Breakdown Days | Breakdown Times | Breakdown Days | Breakdown Times | Breakdown Days
2 | 11 | 2 | 21 | 1 | 1 | 1 | 7 | 1 | 26 | 1 | 26
1 | 21 | 2 | 21 | 2 | 6 | 3 | 11 | 2 | 11 | 2 | 13
4 | 11 | 1 | 11 | 2 | 2 | 2 | 3 | 4 | 5 | 5 | 5
5 | 23 | 3 | 23 | 2 | 2 | 3 | 29 | 22 | 29 | 5 | 17
6 | 5 | 4 | 12 | 6 | 21 | 3 | 21 | 2 | 6 | 6 | 6
7 | 6 | 5 | 15 | 7 | 7 | 3 | 22 | 2 | 7 | 7 | 7
1 | 6 | 7 | 13 | 1 | 1 | 3 | 23 | 2 | 1 | 1 | 1
2 | 1 | 1 | 23 | 2 | 12 | 3 | 25 | 6 | 7 | 4 | 3
3 | 2 | 2 | 12 | 3 | 12 | 6 | 26 | 7 | 1 | 3 | 4
4 | 3 | 3 | 12 | 4 | 12 | 7 | 23 | 1 | 3 | 2 | 3
5 | 21 | 1 | 11 | 2 | 3 | 1 | 21 | 1 | 21 | 4 | 21
Spreadsheet: 67646d1268227002-complex-vlookup-forex
Sheet: User Screen

Status | Senior Partner |  |  |  |  |  |  |  |  |  |  | Senior Partner | London UK
 |  |  |  |  |  |  |  |  |  |  |  | Partner | Regions UK
Base | Dubai |  |  |  | Matter Jurisdiction |  | Euro |  |  |  |  | Senior Partner | Dubai
 |  |  |  |  |  |  |  |  |  |  |  | Partner | Asia Pacific
 |  |  |  |  |  |  |  |  |  |  |  | Consultant | Singapore
 |  | 1860 | See "Requirement" sheet to help me out! |  |  |  |  |  |  |  |  | Consultant (non-Lawyer) | America
 |  |  |  |  |  |  |  |  |  |  |  | Legal Director (Senior) | Euro
 |  |  |  |  |  |  |  |  |  |  |  | Legal Director | CNY
 |  |  |  |  |  |  |  |  |  |  |  | Senior Associate
 |  |  |  |  |  |  |  |  |  |  |  | Associate
 |  |  |  |  |  |  |  |  |  |  |  | Senior [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Senior [NAME]
 | Exchange Rate Table @ 1st June 2009 |  |  |  |  |  |  |  |  |  |  | Senior [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Junior Lawyer
 | GBP | EUR | USD | HKD | AED | CNY | SGD |  |  |  |  | Junior Lawyer
GBP |  | 1.15207 | 1.63825 | 12.6986 | 6.01724 | 11.1835 | 2.35657 |  |  |  |  | Trainee
EUR | 0.868 |  | 1.422 | 11.0224 | 5.22296 | 9.7073 | 2.0455 |  |  |  |  | Trainee
USD | 0.610408 | 0.703235 |  | 7.75134 | 3.67297 | 6.82651 | 1.422 |  |  |  |  | Trainee
HKD | 0.0787487 | 0.0907243 | 0.12901 |  | 0.47385 | 0.880688 | 0.12901 |  |  |  |  | Trainee
AED | 0.166189 | 0.191462 | 0.272259 | 2.11037 |  | 1.85858 | 0.272259 |  |  |  |  | Paralegal 1
CNY | 0.0894173 | 0.103015 | 0.146488 | 1.13548 | 0.538045 |  | 0.146488 |  |  |  |  | [NAME]
SGD | 0.424345 | 0.488877 | 0.695183 | 5.3886 | 2.55339 | 4.74567
 | HISTORIC EXCHANGE RATES WEB PAGE |  |  |  |  |  |  |  |  |  |  | Paralegal 3
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] 6
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] 8
 |  |  |  |  |  |  |  |  |  |  |  | Paralegal 9
 |  |  |  |  |  |  |  |  |  |  |  | Legal Executive - Fellow
 |  |  |  |  |  |  |  |  |  |  |  | Legal Executive - Fellow
 |  |  |  |  |  |  |  |  |  |  |  | Legal Executive - Fellow
 |  |  |  |  |  |  |  |  |  |  |  | Legal Executive - Member
 |  |  |  |  |  |  |  |  |  |  |  | Legal Executive - Member
 |  |  |  |  |  |  |  |  |  |  |  | Legal Executive - Member
 |  |  |  |  |  |  |  |  |  |  |  | Legal Executive - Trainee
 |  |  |  |  |  |  |  |  |  |  |  | Barrister
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Accountant
 |  |  |  |  |  |  |  |  |  |  |  | Law Costs Consultant
 |  |  |  |  |  |  |  |  |  |  |  | Costs Draughtsman
 |  |  |  |  |  |  |  |  |  |  |  | Pensions Trustee Manager
 |  |  |  |  |  |  |  |  |  |  |  | Senior Legal Executive Consultant
 |  |  |  |  |  |  |  |  |  |  |  | Licenced Conveyancer
 |  |  |  |  |  |  |  |  |  |  |  | Trade Mark Attorney
 |  |  |  |  |  |  |  |  |  |  |  | Public Sector Pensions Head
 |  |  |  |  |  |  |  |  |  |  |  | Pensions Executive
Spreadsheet: drew_fossum__8940__WLawLX Sep 2000
Sheet: Sheet1

[NAME] | 2000-09-01 00:00:00
Acct# | Name | Sep% | Inc Chg | Excl. Charge | Subtotal: | Tax | You Pay | Actual
195-900-028 | Moran/Fossum | 0.02 |  | 0
686-525-378 | Cheek | 0.45 |  | 0 |  |  |  | 0.5
607-182-046 | [NAME] | 0.2 |  | 167.9 |  |  |  | 0.23
693-249-032 | Sharp | 0.02 |  | 18
686-568-364 | Place | 0.02 |  | 0
917-004-982 | PGE | 0.02 |  | 0
686-534-314 | Rogers | 0.05 |  | 93.23
825-421-246 | EE&CC | 0.02 |  | 0
825-406-232 | Govt-Water | 0.1 |  | 384.04 |  |  |  | 0.12
825-515-246 | EG Fin | 0.02 |  | 0
825-442-296 | APACHI | 0.02 |  | 0
825-414-282 | CALME | 0.02 |  | 0
825-438-200 | ESA | 0.02 |  | 0
825-488-250 | [NAME] | 0.02 |  | 695
 | Total: |  | 14000
 | Total Usage: | 8455.58 |  | under
686-537-382 | Printer | Waived $240.00 |  |  | TAX | 1013.63
[NAME] September, 2000 Usage (Actuals) Report
[NAME] | 2000-09-01 00:00:00 | Legal Groups Account Only
Account# | Name | Usage% | Gross $ | Approx.# [NAME] | Est. Allocation/Bill Rate $40/ Per User ID
100P01 | Moran/Fossum |  | 17948.76 | 15
103F8D | Cheek |  | 1978.32 | 13
103F7T | [NAME] |  | 5630.05 | 75
103F7Z | Hunsaker |  | 84.24 | 3
1003KQ | Place |  | 0 | 5
1057XB | PGE |  | 20708.18 | 16
103F8G | Rogers |  | 4675.5 | 13
 | [NAME] |  | 1643.72 | 1
108CKJ | EE&CC |  | 2720.03 | 4
 | ESA |  | 0 | 2
 | APACHI | 0 | 0 | 2
 | Azurix | 0 | 0 | 3
 | CALME | 0 | 0 | 6
107WXJ | Sharp |  | 0 | 9
100A6Q | Corp-HQ-Cooley |  | 127.17 | 1
 | ENE Global Fin | 0 | 0 | 1
 | Legal Library |  | 81.34 | 1 | 40
Legal Total: |  |  |  | [NAME] is responsible for [NAME] allocations.
Enron Total: | 376034.61 |  |  | Contact her at [PHONE] if you have any Qs.