tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 225255d1364932998-3-dependent-drop-down-problem-region-country-city-help-dynamic_validation
Sheet: Countries

Region | Region | Country | Angola | Benin | Botswana | BurkinaFaso | Burundi | Bangladesh | Bhutan | Brunei | Cambodia | China
Africa | Africa | Angola | city 1 | city 1 | city 1 | city 1 | city 1 | city 1 | city 1 | city 1 | city 1 | Town 1
Asia | Africa | Benin | city 2 | city 2 | city 2 | city 2 | city 2 | city 2 | city 2 | city 2 | Town 2 | city 2
 | Africa | Botswana | city 3 | city 3 | city 3 | city 3 | city 3 | city 3 | city 3 | Town 3 | city 3 | city 3
 | Africa | [NAME] | add another | add another | add another | add another | add another | add another | City 4 | add another | add another | add another
 | Africa | Burundi | add another | add another | add another | add another | add another | City 5 | add another | add another | add another | add another
 | Asia | Bangladesh | add another | add another | add another | add another | City 6 | add another | add another | add another | add another | add another
 | Asia | Bhutan | add another | add another | add another | City 7 | add another | add another | add another | add another | add another | add another
 | Asia | Brunei | add another | add another | City 8 | add another | add another | add another | add another | add another | add another | add another
 | Asia | Cambodia | add another | City 9 | add another | add another | add another | add another | add another | add another | add another | add another
 | Asia | China | City 10 | add another | add another | add another | add another | add another | add another | add another | add another | add another
 |  |  | ^     the above city list has to be dynamic  so u can add more cities and they display on the drop down starting from the first city (row 2)  ^
Spreadsheet: 151259d1334843983-shared-worksheet-report
Sheet: Data

Box  No | Binders  name | Operator  Name | NO OF  PGS | Start Time  (24 hr Format) | Finish Time  (24 hr Format) | Total  Time | Time in  Minutes | Average | QC'ER | NO OF  PGS2 | COMMENTS | A4  Colour | A3  B&W | A3  Colour | A2  B&W | A2  Colour | A1  B&W | A1  Colour | A0  B&W | A0  Colour | Rebind | OCR | OCR QC | DATE EXPORTED
1 | Binder 1 | [NAME] | 50 | 11:00:00 | 12:00:00 | 01:00:00 | 60.00000000000003
1 | [NAME] | [NAME] | 30 | 12:30:00 | 13:00:00 | 00:30:00 | 29.99999999999989
1 | Binder 3 | [NAME] | 20 | 12:00:00 | 12:45:00 | 00:45:00 | 45
1 | [NAME] | [NAME] | 85 | 11:00:00 | 12:20:00 | 01:20:00 | 80.00000000000011
1 | Binder 5 | [NAME] | 80 | 10:00:00 | 13:00:00 | 03:00:00 | 179.9999999999999
1 | Binder 6 | [NAME] | 20 | 13:20:00 | 14:00:00 | 00:40:00 | 40.00000000000001
2 | Binder 7 | Mo | 80 | 12:00:00 | 13:00:00 | 01:00:00 | 59.99999999999994
 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
Spreadsheet: 554963d1515341119-stats-points-tracking-for-a-disc-golf-league-golf-disc-tournament-2018
Sheet: Tournament 1 (2)

 |  |  | Tournament Name | Discuss 1
 |  |  | Tournament # | 1
 |  |  | Date Played | 2018-01-16 00:00:00
 |  |  | # of Players
 |  |  | Location | [NAME]
 | Player | 1st Round | 2nd Round | 3rd Round
 | [NAME] | 38 | 38
 | Ima Dunce | 0 | 33
 | Anne Other | 32 | 33
 | [NAME] | 37 | 40
 | Ima Belle | 34 | 37
 | [NAME] | 39 | 28
 | [NAME] | 33 | 40
 | [NAME] | 41 | 38
 | [NAME] | 31 | 31
 | [NAME] | 29 | 28
 | [NAME] | 37 | 35
 | [NAME] | 36 | 32
 | P, [NAME] | 40 | 37
 | [NAME] | 0 | 38
 | [NAME] | 40 | 41
 | [NAME] | 35 | 37
Spreadsheet: david_delainey__8183__2001PROFORMA
Sheet: Summary

 |  |  | 2001 Pro Forma
 |  |  |  |  |  | 2001 Plan
 |  |  |  |  | Gross Margin | Direct Expenses | Net
 |  |  | East Power
 |  |  | West Power
 |  |  | Natural Gas
 |  |  | Canada
 |  |  | Mexico
 |  |  | Generation Investments
 |  |  | Principal Investing
 |  |  | Energy Capital
 |  |  | Corporate Development
 |  |  | Restructuring
 |  |  | Office of Chairman
 |  |  | Total Commercial Income
 |  |  | Net Drift/Pre-Pay Expenses
 |  |  | ENA Group Expenses
 |  |  | BA&R
 |  |  | Transaction Support
 |  |  | Energy Ops/EOL Trading
 |  |  | Human Resources
 |  |  | Legal
 |  |  | Public Relations
 |  |  | Tax
 |  |  | Research
 |  |  | e-Source & CABC
 |  |  | Technical Services
 |  |  | Treasury
 |  |  | Sub Total
 |  |  | IT Expenses
 |  |  | Application Development
 |  |  | EOL
 |  |  | Infrastructure
 |  |  | Depreciation et al
 |  |  | Total
 |  |  | Corporate Service Billings
 |  |  | * Insurance
 |  |  | * SAP
 |  |  | * Audit Fee
 |  |  | * Clickathome
 |  |  | * Misc
 |  |  | * Legal
 |  |  | * Tax
 |  |  | * Human Resources
 |  |  | * Public Relations
 |  |  | Total Corp Service Billings
 |  |  | Regulatory Affairs
 |  |  | ECM
 |  |  | RAC
 |  |  | Other
 |  |  | Sub Total
 |  |  | Group Compensation
 |  |  | Bonus
 |  |  | AESOP
 |  |  | Stock Options
 |  |  | Phantom Stock
 |  |  | [NAME]
 |  |  | Sub Total
 |  |  | Legacy Costs
 |  |  | Mexico City |  |  |  | 955000
 |  |  | Coyote |  |  |  | 11318000
 |  |  | CES |  |  |  | 1080000
 |  |  | Citrus |  |  |  | 341000
 |  |  | Sub Total
 |  |  | Capital Charge
 |  |  | Plus : Capital Charge
 |  |  | Less: Facility Fees
 |  |  | Net
 |  |  | EBIT
Spreadsheet: richard_ring__31531__SCSR List_E and G
Sheet: Sheet1

ESCO/Marketer | Assigned Representative | Phone | E-mail
1st Rochdale Cooperative | [NAME] | [PHONE] | [EMAIL]
ACN Energy | [NAME] | [PHONE] | [EMAIL]
AES New Energy | [NAME] | [PHONE] | [EMAIL]
All Energy Marketing Co. | [NAME] | [PHONE] | [EMAIL]
[NAME] | [NAME] | [PHONE] | [EMAIL]
Castle Power | [NAME] | [PHONE] | [EMAIL]
Central Hudson Enterprises | [NAME] | [PHONE] | [EMAIL]
Colonial Energy | [NAME] | [PHONE] | [EMAIL]
Columbia Energy | [NAME] | [PHONE] | [EMAIL]
Con Edison Solutions | [NAME] | [PHONE] | [EMAIL]
ECONnergy | [NAME] | [PHONE] | [EMAIL]
Energy Network Solutions | [NAME] | [PHONE] | [EMAIL]
Enron | [NAME] | [PHONE] | [EMAIL]
Enron Energy Services | [NAME] | [PHONE] | [EMAIL]
Federal Eletric and Gas | [NAME] | [PHONE] | [EMAIL]
FFC Energy LLC | [NAME] | [PHONE] | [EMAIL]
Great Eastern | [NAME] | [PHONE] | [EMAIL]
Interstate Energy Resources | [NAME] | [PHONE] | [EMAIL]
Keyspan Energy Services | [NAME] | [PHONE] | [EMAIL]
Metro Energy Group | [NAME] | [PHONE] | [EMAIL]
Metromedia Energy | [NAME] | [PHONE] | [EMAIL]
Mitchell Supreme | [NAME] | [PHONE] | [EMAIL]
Morgan Stanley | Nat Washington | [PHONE] | [EMAIL]
North American Energy | [NAME] | [PHONE] | [EMAIL]
Olympic Power | [NAME] | [PHONE] | [EMAIL]
Orion Energy Services | [NAME] | [PHONE] | [EMAIL]
PSEG Energy Technologies | [NAME] | [PHONE] | [EMAIL]
Robison Energy | [NAME] | [PHONE] | [EMAIL]
Select Energy | [NAME] | [PHONE] | [EMAIL]
Select Energy of New York | [NAME] | [PHONE] | [EMAIL]
SmartEnergy | [NAME] | [PHONE] | [EMAIL]
Sprague Energy | [NAME] | [PHONE] | [EMAIL]
Strategic Energy | Nat Washington | [PHONE] | [EMAIL]
Stuyvesant Energy | [NAME] | [PHONE] | [EMAIL]
Tiger Natural Gas | [NAME] | [PHONE] | [EMAIL]
Total Gas & Electric | [NAME] | [PHONE] | [EMAIL]
Westchester Energy Supply | [NAME] | [PHONE] | [EMAIL]
Spreadsheet: 215002d1361221331-sumproduct-statement-atlanta-rsa-survey-trends-130218
Sheet: Jackson, MS

 | 2012 Q1 | 2012 Q2 | 2012 Q3 | 2012 Q4 | 2013 Q1 | 2013 Q2 | 2013 Q3 | 2013 Q4 | Q1-Q2 Variance | Q2-Q3 Variance | Q3-Q4 Variance | Q4-Q1 Variance | Q1-Q2 Variance | Q2-Q3 Variance | Q3-Q4 Variance
Total Surveys Completed | 1 | 2 | 1 | 0 | 1
Overall Pharmacy Average | 4.611111111111111 | 4.184210526315789 | 4.235294117647059 | 0 | 4.166666666666667
Ease of ordering (e.g. fax, phone) process | 4 | 3.5 | 4 | 0 | 4
Medication accuracy (i.e. Right Drug/Right Patient) | 4 | 4.5 | 4 | 0 | 4
Spreadsheet: 830080d1684682257-need-help-with-index-match-indexmatch-v2
Sheet: 11May2023

Item Number | Item Description | QTY To Order | Last PO Vendor | Vendor Part #
1XHE4 | 1/2 in Wide, Turn-Key Worm Gear Hose Clamp | 50 PK/10 | Grainger | 1XHE4
00652-52 | 1/2 in Wide, Turn-Key Worm Gear Hose Clamp | 50 PK/10 | Grainger | 1XHE5
0100-2441 | Neutral Capillary | 4 EA | AB Sciex LLC | 477441
01018-22707 | Filter, 1000mL Bottletop | 8 CS/12 | VWR Scientific | 73521-002
01-361-10D | Tips, 250ul Low Retention Sterile (960/10 refills) 10/pk | 50 EA | Mettler-Toledo Rainin, LLC | 30389301
I028 | Sample Diluent Buffer 1000mL | 4 EA | Cygnus Technologies | I028
LC5925 | SeeBlue Plus2 Prestained STD, 500ul | 5 EA | Life Technologies Corporation | LC5925
[NAME] | Ready-To-Fill 2mL Sterile Vial Kit | 3 EA | Afton Scientific
SC00B02RE | Filter, [NAME], Stericup Receiver Flask 12/pk | 3 CS/12 | Fisher Scientific | SC00B02RE
W6-4 | Water, Optima LC/MS 4L ea or 4/cs | 3 CS/12 | Fisher Scientific | W6-4
00652-50 | Standard, Conductivity, 1413 uS | 3 CS/12 | Cole Parmer Instrument Co
Spreadsheet: 126148d1319548835-formula-to-ignore-data-entered-after-the-current-projected-qualifying-date-mdbaker85-workbook
Sheet: BLOGGS

EXAMPLE 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start Date | 2011-10-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Qual Date | 2011-12-27 00:00:00 | 84
BLOGGS
 | 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 |  |  | MY FORMULA
OCT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Absent days | Qual date
NOV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 2011-12-27 00:00:00
DEC
JAN
FEB
EXAMPLE 2
PERRY
 | 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 |  |  | MY FORMULA
OCT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Absent days | Qual date
NOV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 2012-01-01 00:00:00
DEC
JAN |  | h | h | h | h | h
FEB
Spreadsheet: 1ce347e8-c34f-4ae4-bc2d-a48e7f0a196a
Sheet: Sheet1

Table Games Table Inventory Slip Worksheet | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
XXXXX Casino |  |  |  |  |  |  | Use the items below to copy into appropiate cells
 | Table |  |  | Denom. & | Signatures of: |  | Yes þ  No r
Date | Inv. Slip # | Shift | Table # | Total | Pit Supervisor | Dealer/ Other Supervisor | Yes r  No þ
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
 |  | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r | Yes r  No r
Spreadsheet: 145466d1331598518-nested-sumif-range-problem-sample1
Sheet: Sales

 |  |  | Job no |  |  |  |  |  |  |  |  |  |  |  | Total Direct costs
 |  |  | 134
 |  |  | 135 |  |  |  |  |  |  |  |  |  |  |  | 93.17
 |  |  | 136
 |  |  | 137 |  |  |  |  |  |  |  |  |  |  |  | 112.29
 |  |  | 138
 |  |  | 139
 |  |  | 140 |  |  |  |  |  |  |  |  |  |  |  | 119.58
 |  |  | 141 |  |  |  |  |  |  |  |  |  |  |  | 34.28
 |  |  | 142
 |  |  | 143
 |  |  | 144 |  |  |  |  |  |  |  |  |  |  |  | 16.19
 |  |  | 145
 |  |  | 146
 |  |  | 147
 |  |  | 148 |  |  |  |  |  |  |  |  |  |  |  | 40.81
 |  |  | 149 |  |  |  |  |  |  |  |  |  |  |  | 41.72
 |  |  | 150 |  |  |  |  |  |  |  |  |  |  |  | 37.68
 |  |  | 151 |  |  |  |  |  |  |  |  |  |  |  | 255.34
 |  |  | 152 |  |  |  |  |  |  |  |  |  |  |  | 14.64
 |  |  | 153 |  |  |  |  |  |  |  |  |  |  |  | 506.7599999999999
 |  |  | 154 |  |  |  |  |  |  |  |  |  |  |  | 31.69
 |  |  | 155 |  |  |  |  |  |  |  |  |  |  |  | 152.74
 |  |  | 156 |  |  |  |  |  |  |  |  |  |  |  | 155.42
 |  |  | 157 |  |  |  |  |  |  |  |  |  |  |  | 9.05
 |  |  | 158
 |  |  | 159 |  |  |  |  |  |  |  |  |  |  |  | 29.48
 |  |  | 160
Spreadsheet: 22baac46-1d83-4941-ad5c-6f7862d1c0e6
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
11/18/2007 | Wrestling | vs. [NAME] (Vestal, N.Y.) | W, 37-3
11/18/2007 | Wrestling | vs. Iowa State (Vestal, N.Y.) | L, 9-24
12/01/2007 | Wrestling | at Cliff Keen Invitational (Las Vegas, Nev.) | 12th Place
01/02/2008 | Wrestling | at Cal State Fullerton (Fullerton, Calif.) | W, 27-12
01/03/2008 | Wrestling | at Cal Poly (San Luis Obispo, Calif.) | W, 24-12
01/12/2008 | Wrestling | vs. Minnesota ([NAME], Iowa) | L, 9-32
01/12/2008 | Wrestling | vs. Ohio State ([NAME], Iowa) | L, 9-29
01/24/2008 | Wrestling | CLARION | W, 35-3
01/25/2008 | Wrestling | BLOOMSBURG | W, 21-12
02/03/2008 | Wrestling | LOCK HAVEN | W, 30-6
02/08/2008 | Wrestling | PITT | L, 17-18
02/15/2008 | Wrestling | at Ohio | W, 28-13
02/22/2008 | Wrestling | at Edinboro | L, 16-21
02/24/2008 | Wrestling | at Cleveland State | W, 32-2
03/08/2008 | Wrestling | at EWL Championships (Pittsburgh, Pa.) | 3rd Place
03/21/2008 | Wrestling | at NCAA Championships (St. Louis, Mo.) | 31st Place
Spreadsheet: 0c5b7724-53d6-4d3d-a66b-d06c07391f6a
Sheet: June 2013

Spend over £25,000 - Publication template
Department family | Entity | Date | Expense type | Expense area | Supplier | Transaction number | Amount
DCMS | SMG | 2013-06-06 00:00:00 | Maintenance | Science Museum Estates | Fairhurst Ward Abbotts Ltd | 176932 | 27630.02
DCMS | SMG | 2013-06-20 00:00:00 | Maintenance | Science Museum Estates | Cofely Limited | 177163 | 29409.47
DCMS | SMG | 2013-10-16 00:00:00 | Gas | Science Museum Estates | Gazprom Marketing & Trading Limited | 177218 | 25057.22
DCMS | SMG | 2013-06-20 00:00:00 | Security | NMeM Security | [NAME] | 177556 | 36538
DCMS | SMG | 2013-06-20 00:00:00 | Security | NRM Security | [NAME] | 177557 | 38235
DCMS | SMG | 2013-06-04 00:00:00 | Build Construction | NMeM Project | [NAME] (Preston) Limited | 177569 | 90000
DCMS | SMG | 2013-06-20 00:00:00 | Maintenance | Science Museum Estates | Cofely Limited | 177644 | 29409.47
DCMS | SMG | 2013-06-20 00:00:00 | Electricity | Science Museum Estates | Natural History Museum | 177808 | 48379.35
DCMS | SMG | 2013-06-20 00:00:00 | Build Construction | ScM Major projects | Parkeray Ltd | 178015 | 150840.88
DCMS | SCMGE | 2013-06-13 00:00:00 | SCM Retail Stock | Visitor Related | China Industries | 124710 | 28740
DCMS | SCMGE | 2013-06-20 00:00:00 | Contract Cleaning | Visitor Experience | Servest (Sherwood) Ltd | 124753 | 85381.8
DCMS | SCMGE | 2013-06-20 00:00:00 | Contract Cleaning | Visitor Experience | Servest (Sherwood) Ltd | 124754 | 85381.8
DCMS | SCMGE | 2013-06-20 00:00:00 | Contract Cleaning | Visitor Experience | Servest (Sherwood) Ltd | 124755 | 85381.8
Spreadsheet: 724895d1616434048-sumifs-using-months-and-years-from-a-normal-date-book1
Sheet: Sheet2

 | 2019 | 2019 | 2019 | 2020 | 2020 | 2020
 | 1 | 2 | 3 | 1 | 2 | 3
product | added'
12345
12346
Spreadsheet: 5b7752f2-5ed7-4cb2-893d-da9f0d883d96
Sheet: 12d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Cross-Currency Basis | - | 23922 | - | 11955
Cross-Currency Fixed-Fixed | - | 1151 | - | 1092
Cross-Currency Fixed-Float | - | 2770 | - | 1195
TOTAL | - | 27843 | - | 14242
Spreadsheet: 834373d1687773550-generating-a-blank-cell-if-matched-cells-are-empty-cds-import-descartes-worksheet-copy
Sheet: Origins - Pref

COUNTRY | COUNTRY CODE | PREF
AUSTRALIA | AU | 100
AUSTRIA | AT | 300
BELGIUM | BE | 300
BRASIL | BR | 100
BULGARIA | BG | 300
CANADA | CA | 300
CHINA | CN | 100
CROATIA | HR | 300
CYPRUS | CY | 300
CZECH REPUBLIC | CZ | 300
DENMARK | DK | 300
ESTONIA | EE | 300
FINLAND | FI | 300
FRANCE | FR | 300
GERMANY | DE | 300
GREECE | GR | 300
HUNGARY | [NAME] | 300
INDIA | IN | 200
IRELAND | IE | 300
ITALY | IT | 300
JAPAN | JP | 100
LATVIA | LV | 300
LITHUANIA | LT | 300
LUXEMBOURG | LU | 300
MALTA | MT | 300
MEXICO | MX | 100
MOROCCO | MA | 100
NETHERLANDS | NL | 300
NEW ZEALAND | NZ | 100
POLAND | PL | 300
PORTUGAL | PT | 300
ROMANIA | RO | 300
RUSSIA | RU | 100
SLOVAKIA | SK | 300
SLOVENIA | SI | 300
SPAIN | ES | 300
SWEDEN | SE | 300
TAIWAN | TW | 100
THAILAND | TH | 100
UKRAINE | UA | 100
UNITED KINGDOM | GB | 100
USA | US | 100
Spreadsheet: 699050d1602349452-generic-formula-to-sort-multivalues-in-specific-order-split-multiple
Sheet: Sheet1

 | All |  | 4 | 1 | 3 | 2
 | blue§green§red§yellow |  | yellow | blue | red | green
 | yellow |  |  | yellow
 | red§blue§green |  |  | red | green | blue
 | red§yellow |  |  | red |  | yellow
 | green |  |  | green
Spreadsheet: 838449d1691014701-keep-a-group-family-rows-together-when-sorting-group-sort-key
Sheet: Sheet2

[NAME] | Account Number | Account Type | Fee Structure | HELPER_1 | Helper_2 |  | Select the data in columns E and F, then click on Copy | Paste Special | Values | OK | Esc
[NAME] | KramerGroup | 15000000 | Standard Fee | 1 | [NAME] |  | to convert the formulae to values
[NAME] | 6579 | IHIRA |  | 1.1 | [NAME]
[NAME] | 9194 | RH |  | 1.2 | [NAME]
Mark | 7368 | SEP |  | 1.3 | [NAME]
[NAME] | 1609 | CO |  | 1.4 | [NAME]
Jake | 2159 | IHIRA |  | 1.5 | [NAME]
[NAME] | 4187 | LT |  | 1.600000000000001 | [NAME]
Nick | 1817 | LT |  | 1.700000000000001 | [NAME]
[NAME] | DossGroup | 10000000 | 0.01 | 2 | [NAME]
[NAME] | 2786 | JT |  | 2.1 | [NAME]
Scott | 6214 | RH |  | 2.2 | [NAME]
[NAME] | 2009 | RO |  | 2.3 | [NAME]
[NAME] | 9230 | RH |  | 2.4 | [NAME]
Sara | 5866 | CO |  | 2.5 | [NAME]
[NAME] | CorthGroup | 12000000 | Standard Fee | 3 | [NAME]
Kristy | 1259 | IN |  | 3.1 | [NAME]
[NAME] | 1681 | RO |  | 3.2 | [NAME]
[NAME] | StevensGroup | 20000000 | Standard Fee | 4 | [NAME]
[NAME] | 8921 | LT |  | 4.1 | [NAME]
[NAME] | 1984 | RO |  | 4.199999999999999 | [NAME]
[NAME] | MartinGroup | 5000000 | Standard Fee | 5 | Martin
[NAME] | 4449 | IN |  | 5.1 | Martin
Mark | 3834 | RH |  | 5.199999999999999 | Martin
[NAME] | 3767 | SEP |  | 5.299999999999999 | Martin
Cox Family | CoxGroup | 18000000 | GrandFathered | 6 | Cox
[NAME] | 3785 | IN |  | 6.1 | Cox
[NAME] | 8426 | CO |  | 6.199999999999999 | Cox
Mixon Family | MixonGroup | 7000000 | Standard Fee | 7 | Mixon
[NAME] | 4516 | RO |  | 7.1 | Mixon
[NAME] | 5400 | SEP |  | 7.199999999999999 | Mixon
Samantha | 9247 | JT |  | 7.299999999999999 | Mixon
Julie | 6012 | RO |  | 7.399999999999999 | Mixon
Spreadsheet: 761172d1640701043-if-error-with-additional-column-not-working-test
Sheet: Time Card Adjustment

Last Name | First Name | Reason | Hours | Approved Hours | Amount | Approved Amount | From Pay Period | Pay Period | Notes
Spreadsheet: 97783d1296859085-sumif-help-with-multiple-tabs-payroll-cards-formula-test
Sheet: Totals

 |  |  | Hourly | Therapy
 | Hrly Rate | Hrs | Wages | Wages | Salary | OnCall | Total |  |  |  |  | BSS-CSP
 |  |  |  |  |  |  |  |  |  |  |  | YRP
Noni |  |  |  |  |  |  |  |  |  |  |  | PSYCH
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Michelle
Bettina
[NAME]
Jessica
[NAME]
[NAME]
Spreadsheet: 105782d1303069033-sorting-columns-from-many-tables-within-one-worksheet-randoms-sort-updated
Sheet: Sheet1

 | Jockeys |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] In Order | Y MINUS D
1 | JF
2 | JS
3 | [NAME] |  | Rating | Earnings |  |  |  |  |  |  |  |  |  | Lbs | [NAME] | LBW | Previous Owner | New Owner | Claims
4 | PO |  | 1 | 3 | Sleeping | G2 3F | 103 | 49.76 | 9 | 4 | 1 | 3 | 1 | 2 | 1 | 0 | 1 | 108 | AT | 0 | Shore Stables | 0
5 | HN |  | 2 | 4 | Kev's Lad | G2 3M | 100 | 19.8 | 10 | 4 | 2 | 5 | 4 | 0 | 0 | 0 | 0 | 120 | MC | 0.4 | Batey's | 0
6 | MH |  | 3 | 1 | Black Western | G2 3M | 101 | 50.67 | 17 | 7 | 2 | 1 | 1 | 0 | 1 | 1 | 0 | 120 | LF | 0.85 | Buddha Farms | 0
7 | MC |  | 4 | 2 | Witbier | G2 3M | 101 | 58.78 | 25 | 11 | 2 | 4 | 3 | 1 | 1 | 1 | 0 | 120 | YM | 1.8 | Beer Baron Racing | 0
8 | AT
9 | KA
10 | LW |  | Rating | Earnings |  |  |  |  |  |  |  |  |  | Lbs | [NAME] | LBW | Previous Owner | New Owner | Claims
11 | AM |  | 1 | 8 | Oh So Close | G2 3M | 100 | 34.81 | 4 | 3 | 0 | 9 | 3 | 2 | 0 | 0 | 0 | 120 | JF | 0 | H007 | 0
12 | YC |  | 2 | 5 | Arctic Ace | G2 3F | 100 | 70.07 | 21 | 7 | 3 | 2 | 1 | 1 | 0 | 0 | 0 | 108 | AM | 0.48 | [NAME] | 0
13 | BA |  | 3 | 7 | Red Hollow | G2 3F | 100 | 34.16 | 4 | 1 | 0 | 14 | 5 | 5 | 0 | 0 | 0 | 108 | MH | 0.84 | [NAME] | 0
14 | KB |  | 4 | 3 | Smooth Victory | G2 3M | 100 | 34.7 | 9 | 3 | 0 | 18 | 8 | 3 | 0 | 0 | 0 | 120 | RP | 1.4 | [NAME] | 0
15 | TR |  | 5 | 10 | Itstoofar | G2 3M | 100 | 32.47 | 8 | 1 | 2 | 10 | 4 | 1 | 0 | 0 | 0 | 120 | LW | 1.76 | [NAME] | 0
16 | RP |  | 6 | 9 | Holy Horse | G2 3M | 100 | 31.91 | 9 | 3 | 2 | 11 | 5 | 1 | 0 | 0 | 0 | 120 | JS | 2.28 | Sin City Stables | 0
17 | TK |  | 7 | 6 | Spectacular Blast | G2 3M | 100 | 13.55 | 2 | 0 | 1 | 9 | 2 | 1 | 0 | 0 | 0 | 120 | LF | 2.6 | [NAME]'s Pack | 0
18 | KR |  | 8 | 2 | Apeckalypse Now | G2 3M | 100 | 35.23 | 13 | 8 | 1 | 4 | 3 | 0 | 0 | 0 | 0 | 120 | TK | 3.08 | [NAME]'s Pack | 0
19 | ZH |  | 9 | 4 | [NAME] | G2 3F | 100 | 34.84 | 18 | 12 | 1 | 5 | 2 | 1 | 0 | 0 | 0 | 108 | EM | 3.4 | DOC MDTERPS | 0
20 | LT |  | 10 | 1 | Fore More | G2 3M | 100 | 5.01 | 2 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 120 | JP | 3.92 | Robslobs | 0
21 | GB
22 | ND |  | Rating | Earnings |  |  |  |  |  |  |  |  |  | Lbs | [NAME] | LBW | Previous Owner | New Owner | Claims
23 | ZA |  | 1 | 3 | Sleeping | G2 3F | 103 | 49.76 | 9 | 4 | 1 | 3 | 1 | 2 | 1 | 0 | 1 | 108 | AT | 0 | Shore Stables | 0
24 | JP |  | 2 | 4 | Kev's Lad | G2 3M | 100 | 19.8 | 10 | 4 | 2 | 5 | 4 | 0 | 0 | 0 | 0 | 120 | MC | 0.4 | Batey's | 0
25 | SB |  | 3 | 1 | Black Western | G2 3M | 101 | 50.67 | 17 | 7 | 2 | 1 | 1 | 0 | 1 | 1 | 0 | 120 | LF | 0.85 | Buddha Farms | 0
26 | TL |  | 4 | 2 | Witbier | G2 3M | 101 | 58.78 | 25 | 11 | 2 | 4 | 3 | 1 | 1 | 1 | 0 | 120 | YM | 1.8 | Beer Baron Racing | 0
27 | EM
28 | HB
29 | AL
30 | ML
31 | TJ
32 | CS
33 | YM
34 | LF