tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 885322d1734812375-trying-to-match-entries-in-two-different-spreadsheets-please-help-match-co-v-tax
Sheet: Merge1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Tax.Column1 | Tax.Column2 | Tax.Column3 | Tax.Column4 | Tax.Column5 | Tax.Column6 | Tax.Column7 | Tax.Column8
 |  |  |  |  |  |  |  | Local | P000593540R | CROWN PAINTS KENYA PLC | 45608 | 0020111770000446339 | ETIMS/TIMS purchases |  | 146597.6
 |  |  |  |  |  |  |  | Local | P000593540R | CROWN PAINTS KENYA PLC | 45608 | 0020111770000446377 | ETIMS/TIMS purchases |  | 159781.2
LOCAL | P051099009C | CLASSIC IRONMONGERS LTD. | 45608 | 0110164200000039625 | GOODS |  | 517457.5 | Local | P051099009C | CLASSIC IRON MONGERS LIMITED | 45608 | 0110164200000039625 | ETIMS/TIMS purchases |  | 517457.5
 |  |  |  |  |  |  |  | Local | P000593540R | CROWN PAINTS KENYA PLC | 45608 | 0020111770000446236 | ETIMS/TIMS purchases |  | 23537.4
LOCAL | P051099009C | CLASSIC IRONMONGERS LTD. | 45608 | 0110164200000039627 | GOODS |  | 517457.5 | Local | P051099009C | CLASSIC IRON MONGERS LIMITED | 45608 | 0110164200000039627 | ETIMS/TIMS purchases |  | 517457.5
 |  |  |  |  |  |  |  | Local | P000596247D | BASCO PRODUCTS (K) LTD | 45608 | 0190432540000062860 | ETIMS/TIMS purchases |  | 35648
 |  |  |  |  |  |  |  | Local | P000597083J | [NAME] | 45608 | 0040074300000027733 | ETIMS/TIMS purchases |  | 26600
 |  |  |  |  |  |  |  | Local | P000613055P | ASSA ABLOY (EAST AFRICA) LIMITED | 45608 | 0040096490000038925 | ETIMS/TIMS purchases |  | 772759.62
 |  |  |  |  |  |  |  | Local | P000618782L | [NAME] | 45608 | 0110609580000012103 | ETIMS/TIMS purchases |  | 146000
 |  |  |  |  |  |  |  | Local | P000613055P | ASSA ABLOY (EAST AFRICA) LIMITED | 45608 | 0040096490000038915 | ETIMS/TIMS purchases |  | 691603.92
 |  |  |  |  |  |  |  | Local | P000605924U | Tononoka [NAME] | 45608 | 0110600340000023189 | ETIMS/TIMS purchases |  | -120858.38
 |  |  |  |  |  |  |  | Local | P000605924U | Tononoka [NAME] | 45608 | 0110600340000023190 | ETIMS/TIMS purchases |  | -80866.36
 |  |  |  |  |  |  |  | Local | P000593540R | CROWN PAINTS KENYA PLC | 45608 | 0020111770000446369 | ETIMS/TIMS purchases |  | 17741.07
 |  |  |  |  |  |  |  | Local | P051394728G | KEEPINGS TRADING LIMITED | 45608 | 0040092980000004823 | ETIMS/TIMS purchases |  | -9375.7
LOCAL | P051099009C | CLASSIC IRONMONGERS LTD. | 45608 | 0110164200000039623 | GOODS |  | 517457.5
LOCAL | P051099009C | CLASSIC IRONMONGERS LTD. | 45608 | 0110164200000039624 | GOODS |  | 517457.5
LOCAL | P051402277B | CLEANEX PRODUCTS AND SERVICES | 45597 | 0040811000000000728 | GOODS |  | 56000
LOCAL | P051402277B | CLEANEX PRODUCTS AND SERVICES | 45597 | 0040811000000000732 | GOODS |  | 25000
LOCAL | P051171485W | CMA CGM KENYA LTD - USD | 45604 | 0040073230000042251 | GOODS |  | 9065
LOCAL | P051171485W | CMA CGM KENYA LTD - USD | 45616 | 0040073230000042776 | GOODS |  | 9100
Spreadsheet: 771761d1646835477-calculate-value-if-certain-conditions-met-stylist-bonuses-2019-working-v2-help-file-2
Sheet: Productive

Data Analysis
Salon Name | Salon No. | [NAME] | Closing | Total | [NAME] | Excess  Non-Floor | Floor | Adjusted Hours | Revenue | Adjusted Productivity | Prod Sales | Salon Prod %
Admin/Closing Hours Budgeted |  | 9.5
Spreadsheet: sally_beck__33698__MgmtSum-Q2-0609
Sheet: Q1 Mgmt Summary

E N R O N   N O R T H   A M E R I C A |  |  |  |  |  |  |  |  |  |  |  |  | 1ST QTR 2000 EARNINGS
 |  |  |  |  |  |  |  |  |  |  |  |  | Results based on Activity through March 31, 2000
 |  | Margin |  |  |  | Expenses |  |  |  |  | EBIT
Business Team |  | Actual | Plan | [NAME] |  | Forecast | Plan* | [NAME] |  |  | Forecast | Plan | [NAME]
 |  |  |  |  |  |  |  | [NAME] | Cash Exp
Gas Trading |  |  | 41592 |  |  |  |  | 0
Texas Desk |  | 17193 | 7436 |  |  | 2875 | 3355 | 0
Power Trading |  |  |  |  |  |  |  | 478
Financial Drift |  | 25965 | 22402 |  |  | 1834 | 1630 | 0
Financial Trading |  | 35765 | 11447 |  |  | 1854 | 2436 | 0
Canada Trading |  |  | 23112 |  |  |  |  | 0
Coal-Trading |  | 3398 | 12747 |  |  | 6393 | 4728 | 0 | -1702
GRM -  Weather |  | 5666 | 3215 |  |  | 2609 | 1722 | 0
Emissions |  | 3674 | 750 |  |  | 266 | 342 | 0
Total Trading & Risk Mgt. |  |  |  |  | 129970
East Midstream |  | 2838 | 14243 |  |  | 4815 | 6563 | 0
West Midstream |  | 8356 | 13235 |  |  | 5047 | 7464 | -604
Industrial Downstream
Generation Investments/IPP |  | 7219
Coal Origination & Finance |  |  | 0 |  |  | 0 | 0 | 37 | 0
Canada Origination & Finance |  | 815 | 0 |  |  |  |  | 183
Gas Assets |  | 23078 | 30320 |  |  | 62429 | 60693 | 2344
GRM - New Products |  | 0 | 7712 |  |  | 1484 | 1217 | 0
Mexico |  | 11 | 4656 |  |  | 2218 | 2456 | 0
Total Origination |  |  |  |  | 0
Principal Investing |  | 93673 | 15379 |  |  | 2669 | 3204 | 625
Energy Capital Services |  | 858 | 0 |  |  | 6027 | 7138 | 1539
CTG Assets |  |  | 14404
Total Investing
Commercial Transactions Group |  | 1400 | 2500 |  |  | 8467 | 8514 | 0
Office of the Chairman |  | 0 | 0 |  |  | 8285 | 7652 | 0
Overview |  | 0 | 48693 |  |  | 0 | 0 | 0
Total Commercial
Group Total |  |  |  |  |  | 79168 | 63376
Group Allocated to Teams |  | 0 |  |  |  | -48800 | -56377 | 0
Other Interest Related Charges |  | -22158 | -10795 |  |  | 14727 | 22603 | 0
Capital Charge Offset |  |  |  |  |  | -32741 | -39874 | -7133
ENA EBIT
Interest Expense/(Income) |  |  |  |  |  | 1223 | 12000 | 0
[NAME]
* Includes Capital Charge & Operating, Direct, and Allocated Expenses
Spreadsheet: 6395be08-30b7-40b2-8cb8-efe6af1bab8c
Sheet: Sheet1

CALCULO DE LAS PREVISIONES 2009-2011 A PARTIR DE LAS LIQUIDACIONES DE EJERCICIOS ANTERIORES                                                                                                                                                                                                                                   ESTADO CONSOLIDADO AYUNTAMIENTO Y ORGANISMOS AUTÓNOMOS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  |  | [NAME] liquidados |  |  |  |  | [NAME]
 | ESTADO DE INGRESOS |  | 2005 | 2006 |  | 2007 |  | 2008 | 2009 |  | 2010 |  | 2011
[NAME] | Denominación |  | Importe | Importe | Crec 05/06 | Importe | Crec 06/07 | Importe | Importe | Crec 08/09 | Importe | Crec 09/10 | Importe | Crec 10/11
1 | Impuestos directos
 |  |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0
2 | Impuestos indirectos
 |  |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0
3 | Tasas y otros ingresos
 |  |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0
4 | Transferencias corrientes
 |  |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0
5 | Ingresos patrimoniales
 |  |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0
 | Operaciones corrientes
 |  |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0
6 | Enajenación inversiones
 |  |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0
7 | Transferencias de capital
 |  |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0
 | Operaciones de capital
 |  |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0
 | Operaciones no financ.
 |  |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0
8 | Var. activos financieros
 | Var. activos financieros |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0
9 | Var. [NAME]
 | Var. [NAME] |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0
 | Operaciones financieras
 | Operaciones financieras |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0
TOTAL INGRESOS
 |  |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0
Cuadro 5.1
Spreadsheet: 67395d1268047617-extracting-non-matching-records-to-a-new-book-week1
Sheet: Week 1

Property Name | Type of Property | Your Property ID | Address 1 | City | State/Province/etc.
ABC Hotel | Hotel | [NAME] | 123 High St | Birmingham | UK
123 Resort | Resort | aaaaa2 | 456 School Road | [NAME] | UK
XYZ Hotel & Spa | Hotel | aaaaa3 | 789 Badger Drive | [NAME] | UK
[NAME] | Hotel | [NAME] | [NAME] | London | UK
Spreadsheet: 29871d1225101304-merging-two-worksheets-into-one-example1
Sheet: Master Donor List Example

 | Title (Mr., Mrs. [NAME]) | FirstName | LastName | SpouseFirst | SpouseLast | Company | [NAME] | Phone | Address | City | Country | State | ZipCode | Preferred Contact | Donation | PaymentMethod | DateofDonation | Recurring Donor | Tax Deductible | ThankYouNoteSent | Organization | [NAME] | Notes
JohnDoe | Mr. | [NAME] | Doe | [NAME] | Doe |  | [EMAIL] | 1112223333 | 1113 Doe Pl | Syracuse | USA | NY | 13210 |  |  |  |  | No | Yes | Yes |  | No
LauraKent | Ms. | [NAME] | Kent | Edmund | Kent |  | [EMAIL] | 222222222 | 1111 Doe Pl. | New York | USA | NY | 112233 |  |  |  |  | No | No | No |  | No
PeanutMM | Mr. | Peanut | MM | Eva | [NAME] |  | [EMAIL] | 4444444 | 4411 [NAME] | Los Angeles | USA | CA | 91321
XY1 | Mrs. | X | Y1 | [NAME] | Roosevelt |  | xxxx
Spreadsheet: 82765d1282781623-extract-data-to-different-workbook-example-workbook
Sheet: 6

 |  |  | 2008-01-06 00:00:00
Location | Trips | Liters | Gallons
[NAME] | 1 | 378.5 | 100
Centurion | 2 | 757 | 200
Dragon | 3 | 1135.5 | 300
Bldg 0039 | 4 | 1514 | 400
Fac 1 | 5 | 1892.5 | 500
Man | 6 | 2271 | 600
Dog Pen | 7 | 2649.5 | 700
Canal | 8 | 3028 | 800
Hot | 9 | 3406.5 | 900
Fac2 | 10 | 3785 | 1000
 | 55 | 20817.5 | 5500
 | 330 | 124905 | 33000
Spreadsheet: 56880795-bca0-430b-b5b0-cc7c52a3966f
Sheet: Sheet1

University | Competitor | Score
Swansea 1 | [NAME] | 182
Newcastle 1 | [NAME] | 181
Sheffield 1 | [NAME] | 180
Aberdeen 1 | [NAME] | 178
Cardiff 1 | [NAME] | 173
Sheffield [NAME] | [NAME] | 161
St. Andrews 2 | [NAME] | 158
Manchester 1 | [NAME] | 158
Sheffield 2 | [NAME] | 158
Bangor 2 | [NAME] | 158
Bangor 1 | [NAME] | 157
UCL 1 | [NAME] | 155
UCL 2 | [NAME] | 152
Kings 1 | [NAME] | 152
Lancaster 1 | [NAME] | 151
Loughborough 1 | [NAME] | 151
Newcastle 2 | Polly Harmer | 151
UEA 1 | [NAME] | 151
St. Andrews 1 | [NAME] | 148
Brunel 1 | Charlotte Steel | 146
[NAME] | [NAME] | 145
Oxford Brookes 1 | [NAME] | 142
Bristol 1 | [NAME] | 139
Durham 1 | [NAME] | 138
Kings Medics 1 | [NAME] | 136
Stirling 1 | [NAME] | 136
Derby 1 | Holly Jones | 134
Exeter 1 | [NAME] | 133
[NAME] | [NAME] | 132
Derby 2 | [NAME] | 131
[NAME] | [NAME] | 129
Aston 1 | Suvi Ellila | 129
Southampton 1 | Lauren Davies | 128
UEA 2 | [NAME] | 127
UEA 2 | [NAME] | 127
Lancaster 2 | [NAME] | 126
Leicester 1 | Gemma Fisher | 125
Hertfordshire 1 | [NAME] | 123
Plymouth 1 | Lydia Smith | 123
Chichester Individual | [NAME] | 122
Glamorgan 1 | [NAME] | 121
Exeter 2 | [NAME] | 120
Brunel 2 | [NAME] | 120
[NAME] | Alaina [NAME] | 119
[NAME] | Fip Tonkins | 119
Man Met 1 | [NAME] | 119
[NAME] | [NAME] | 119
[NAME] | [NAME] | 118
Leeds Met 2 | [NAME] | 117
Kings 2 | [NAME] | 116
Glasgow 1 | [NAME] | 115
Loughborogu 2 | Zoe Marshal | 115
Reading 1 | [NAME] | 114
[NAME] | [NAME] | 114
Leeds Met 1 | [NAME] | 113
[NAME] 1 | [NAME] | 112
Oxford Brookes 2 | [NAME] | 111
Royal Holloway 1 | [NAME] | 111
Reading 2 | [NAME] | 111
Dundee 1 | [NAME] | 111
[NAME] | [NAME] | 110
Essex 1 | [NAME] | 108
York 1 | [NAME] | 107
Aberystwyth 1 | Elanor Anstice | 107
Portsmouth 1 | Penelopy [NAME] | 106
Stirling 2 | Nicola Robinson | 105
Teesside 1 | [NAME] | 104
Portsmouth 2 | Beccy Stone | 103
[NAME] | [NAME] | 102
Leeds Met 2 | [NAME] | 100
Plymouth 1 | [NAME] | 92
[NAME] | [NAME] | 86
Kent 1 | [NAME] | 82
Southampton Solent 2 | [NAME] | 82
[NAME] | [NAME] | 76
[NAME] | [NAME] | 74
Southampton Solent 1 | [NAME] | 71
[NAME] | [NAME] | 54
Stirling 2 | [NAME] | 42
[NAME] | [NAME] | 22
Bristol 1 | [NAME] | 0
Leeds Met Individual | [NAME] | 0
Sheffield Hallam Individual | [NAME] | 0
Man Met 2 | [NAME] | 0
Leeds Met Individual | [NAME] | 0
Leeds Met Individual | [NAME] | 0
[NAME] | [NAME] | 0
Spreadsheet: 7d53dc20-b845-49ac-a229-4069ea0b9674
Sheet: Sheet1

Probesets downregulated in pkl | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Probesets downregulated in pkl and marked by H3K27me3 | Unnamed: 5
Probesets | AGI |  |  | Probesets | AGI
245307_at | AT4G16770 |  |  | 245330_at | AT4G14930
245319_at | AT4G16146 |  |  | 246978_at | AT5G24910
245325_at | AT4G14130 |  |  | 247469_at | AT5G62165
245330_at | AT4G14930 |  |  | 247586_at | AT5G60660
246344_at | AT3G56730 |  |  | 248104_at | AT5G55250
246978_at | AT5G24910 |  |  | 248245_at | AT5G53190
247469_at | AT5G62165 |  |  | 251131_at | AT5G01190
247586_at | AT5G60660 |  |  | 252510_at | AT3G46270
247657_at | AT5G59845 |  |  | 253014_at | AT4G37940
247780_at | AT5G58770 |  |  | 253070_at | AT4G37850
248104_at | AT5G55250 |  |  | 253525_at | AT4G31330
248245_at | AT5G53190 |  |  | 253822_at | AT4G28410
248434_at | AT5G51440 |  |  | 254769_at | AT4G13330
248657_at | AT5G48570 |  |  | 254909_at | AT4G11210
248790_at | AT5G47450 |  |  | 255129_at | AT4G08290
249037_at | AT5G44130 |  |  | 256128_at | AT1G18140
249557_at | AT5G38280 |  |  | 256368_at | AT1G66800
249596_s_at | AT5G38010;AT5G37950 |  |  | 256811_at | AT3G21340
249812_at | AT5G23830 |  |  | 257774_at | AT3G29250
249814_at | AT5G23840 |  |  | 262838_at | AT1G14960
250100_at | AT5G16570 |  |  | 264826_at | [NAME]
250268_s_at | AT5G12950;AT5G12960 |  |  | 266525_at | AT2G16970
250455_at | AT5G09980 |  |  | 267215_at | AT2G02630
250952_at | AT5G03570 |  |  | 267439_at | AT2G19060
250983_at | AT5G02780
251131_at | AT5G01190
251478_at | AT3G59695;AT3G59690
251545_at | AT3G58810
251931_at | AT3G53950
251952_at | AT3G53650
251975_at | AT3G53230
252391_at | AT3G47860
252502_at | AT3G46900
252510_at | AT3G46270
252950_at | AT4G38690
253014_at | AT4G37940
253050_at | AT4G37450
253070_at | AT4G37850
253177_s_at | AT4G35150;AT4G35160
253215_at | AT4G34950
253362_s_at | AT4G33110;AT4G33120
253367_at | AT4G33180
253525_at | AT4G31330
253618_at | AT4G30420
253822_at | AT4G28410
253827_at | AT4G28085
254041_at | AT4G25830
254387_at | AT4G21850
254769_at | AT4G13330
254774_at | AT4G13440
254909_at | AT4G11210
255129_at | AT4G08290
255908_s_at | AT1G18010;AT1G18000
255962_at | AT1G22335
256025_at | AT1G58370
256128_at | AT1G18140
256368_at | AT1G66800
256725_at | AT2G34070
256811_at | AT3G21340
257203_at | AT3G23730
257774_at | AT3G29250
258049_at | AT3G16220
258731_at | AT3G11880
259224_at | AT3G07800
259252_at | [NAME]
259822_at | AT1G66230
260264_at | AT1G68500
260840_at | AT1G29050
262275_at | AT1G68710
262347_at | [NAME]
262713_at | AT1G16520
262758_at | AT1G10780
262838_at | AT1G14960
263546_at | AT2G21550
263594_at | AT2G01880
263915_at | AT2G36430
264078_at | AT2G28470
264184_at | AT1G54790
264415_at | AT1G43160
264826_at | [NAME]
264988_at | AT1G27140
265246_at | AT2G43050
265276_at | AT2G28400
265560_at | [NAME]
266525_at | AT2G16970
266548_at | AT2G35210
267215_at | AT2G02630
267238_at | AT2G44130;AT2G44140
267439_at | AT2G19060
267623_at | AT2G39650
Spreadsheet: 815407d1674927208-sequential-numbering-skipping-blank-rows-sequential-numbering-with-blanks_sample
Sheet: Outcome

Firstname | Lastname | Numbering | Numbering
Spreadsheet: 692376d1598295863-rank-top-sales-person-from-order-list-sample-sales
Sheet: Sheet1

Order No | [NAME] | Units Sold |  |  | Rankings | [NAME] | Total Units Sold
1 | [NAME] | 5 |  |  | 1 | [NAME] | 51
2 | [NAME] | 30 |  |  | 2 | [NAME] | 46
3 | Sara | 2 |  |  | 3 | Sara | 37
4 | [NAME] | 6
5 | [NAME] | 8
6 | [NAME] | 23
7 | Sara | 34 |  |  |  |  | 51
8 | Sara | 1 |  |  |  | [NAME] | 46
9 | [NAME] | 16 |  |  |  | Sara | 37
10 | [NAME] | 9
11 | [NAME] | 5
12 | Janice | 16
Spreadsheet: 8b18caa1-348e-4b6f-b320-94868ac2e196
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
FETCE | Test | FETCE | Mitochondrial Respiratory Chain Enzyme Analysis - Skin Fibroblasts | Electron Transport Chain Enzymes | Spectrophotometric |  |  |  |  |  | Cultured Fibroblasts 2 T-25 flasks(s) filled to neck with culture media. Maintain sterility and forward promptly at ambient temperature. |  | Specimens other than	Fibroblasts, skin biopsy Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | A final report will be attached in MayoAccess.   Test Performed by: Baylor Medical Genetics Laboratories                               2450 [NAME].                               Houston, TX  77021 | Upon receipt | 6 weeks | 45 days |  | Profile |  |  |  |  | Baylor Medical Genetics Laboratories
FETCE | [NAME] | FIBROBLA | Fibroblasts |  |  |  | Ambient
FETCE | Result | Z1751 | Electron Transport Chain Enzymes | Electron Transport Chain Enzymes | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FETCE | Billing Component | FETCE |  | Cryopreservation, each cell line |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 88240
FETCE | Billing Component | FETCE |  | Skin or other solid tissue biopsy |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 88233
FETCE | Billing Component | FETCE |  | Enzyme Activity, each specimen |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 82657
FETCE | Billing Component | FETCE |  | Spectrophotometry |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 84311
Spreadsheet: 812712d1673337583-i-need-to-develop-a-grid-that-shows-how-many-entries-are-duplicated-accross-the-set-values-example
Sheet: Sheet1

Input Data |  |  |  | Required Results (Manual Calc)
Referral Source | Client ID |  |  |  | CARS.CO.ZA | MOTUS.CARS WEBSITE | GROUP WEBSITE | FACEBOOK | AUTOTRADER | CARFIND
CARS.CO.ZA | 9899 |  |  | CARS.CO.ZA | 2 |  |  |  | 1
CARS.CO.ZA | 9899 |  |  | MOTUS.CARS WEBSITE |  |  | 1
MOTUS.CARS WEBSITE | 2981 |  |  | GROUP WEBSITE |  | 1 | 1
GROUP WEBSITE | 2981 |  |  | FACEBOOK |  |  |  | 3
FACEBOOK | 4748 |  |  | AUTOTRADER | 1 |  |  |  |  | 1
FACEBOOK | 4748 |  |  | CARFIND |  |  |  |  | 1
CARS.CO.ZA | 8000
CARS.CO.ZA | 8000
AUTOTRADER | 8000
AUTOTRADER | 5830
CARFIND | 5830
FACEBOOK | 9216
FACEBOOK | 9216
GROUP WEBSITE | 1375
GROUP WEBSITE | 1375
FACEBOOK | 9638
FACEBOOK | 9638
Spreadsheet: 843655d1695442230-how-do-i-validate-data-from-2-different-tables-data-validation
Sheet: DataValidation

 | Y | DPROX | Y1 |  | X | DPROX | X1 |  | Sobre | Desde | Hasta
 | 11.A | 2 |  |  | 11.30 | 1.86
 | 11.B | 0.8 |  |  | 11.29 | 1.14
 | 11.C | 0.7 |  |  | 11.28 | 3
 | 11.D | 1.5 |  |  | 11.27 | 2
 | 11.E | 1 |  |  | 11.26 | 1
 | 11.F | 1.25 |  |  | 11.25 | 2
 | 11.G | 0.75 |  |  | 11.24 | 2
 | 11.H | 0.9 |  |  | 11.23 | 3
 | 11.I | 1.04 |  |  | 11.22 | 3
 | 11.J | 1.06 |  |  | 11.21 | 0.22
 | 11.J' | 1 |  |  | 11.2 | 1.78
 | 11.K | 1 |  |  | 11.19 | 2.5
 | 11.L | 1 |  |  | 11.18 | 0.5
 | 11.U | 0 |  |  | 11.16 | 0
 | Total |  |  |  | Total
Spreadsheet: 703124d1604766591-maximum-sum-in-a-column-with-a-criterion-glenns-saturday-puzzle
Sheet: Sheet2

Block A |  |  |  |  |  |  | Block B |  |  |  |  |  |  | Block C |  |  |  |  |  |  | Block D
Company | Name | Sales |  |  |  |  | Company | Name | Sales |  |  |  |  | Company | Name | Sales |  |  |  |  | Company | Name | Sales
A | Ana | 174 |  | Name | Amount |  | A | Ana | 174 |  | Name | Amount |  | A | Ana | 174 |  | Name | Amount |  | A | Ana | 174 |  | Name | Amount
A | [NAME] | 174 |  |  |  |  | A | [NAME] | 174 |  |  |  |  | A | [NAME] | 174 |  |  |  |  | A | [NAME] | 174
A | [NAME] | 25 |  |  |  |  | A | [NAME] | 25 |  |  |  |  | A | [NAME] | 25 |  |  |  |  | A | [NAME] | 25
A | [NAME] | 100 |  |  |  |  | A | [NAME] | 1000 |  |  |  |  | A | [NAME] | 100000 |  |  |  |  | A | [NAME] | 1000000
A | [NAME] | 100 |  |  |  |  | A | [NAME] | 1000 |  |  |  |  | A | [NAME] | 100000 |  |  |  |  | A | [NAME] | 1000000
A | [NAME] | 45 |  |  |  |  | A | [NAME] | 45 |  |  |  |  | A | [NAME] | 45 |  |  |  |  | A | [NAME] | 45
B | [NAME] | 541 |  |  |  |  | B | [NAME] | 541 |  |  |  |  | B | [NAME] | 541 |  |  |  |  | B | [NAME] | 541
B | Ana | 54 |  |  |  |  | B | Ana | 54 |  |  |  |  | B | Ana | 54 |  |  |  |  | B | Ana | 54
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Block E
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company | Name | Sales
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A | Ana | 174 |  | Name | Amount
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A | [NAME] | 174
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A | [NAME] | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A | [NAME] | 100000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A | [NAME] | 100000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A | [NAME] | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  | B | [NAME] | 541
 |  |  |  |  |  |  |  |  |  |  |  |  |  | B | Ana | 54
Spreadsheet: 796331d1663227840-filter-from-another-workbook-value-error-and-spill-errors-tracker_filter-1-
Sheet: Sheet1

 | 44484 | Client A | MFP | Hierarchy Amend
DS292715 | 44550 | Client A | MFP | Prism Analysis
DS295410 | 44617 | Client A | MFP | Missing Products/Barcodes
DS295907 | 44628 | Client A | MFP | Missing Products/Barcodes
DS296197 | 44630 | Client A | MFP | Hierarchy Amend
DS296649 | 44636 | Client A | MFP | New Hierarchy
DS296651 | 44636 | Client A | MFP | Missing Attribute
DS297252 | 44642 | Client A | MFP | New Hierarchy
DS297254 | 44642 | Client A | MFP | New Hierarchy
DS297255 | 44642 | Client A | MFP | New Hierarchy
DS298216 | 44658 | Client A | MFP | Standard Coding Error
DS298355 | 44659 | Client A | MFP | New Hierarchy
DS299472 | 44679 | Client A | MFP | New Attribute
Spreadsheet: scott_neal__38013__NY City Forecast
Sheet: Load Profile

 | NY City Load Forecast Based on Average Temperature in NY City
 | Enter number of degrees below normal in cell [NAME] and the number of degrees above  normal in cell F4.
 |  |  |  | 5 | 5
 | Month | Normal Temperatures NY City (10 Year Average 1/1/1990 to present) | NY City Load Forecast |  |  |  |  |  |  |  |  | Below normal | Above normal
 | Jan | 34.39516129032258
 | Feb | 36.25663716814159
 | Mar | 42.51478494623656
 | Apr | 53.12916666666667
 | May | 62.91285714285714
 | Jun | 72.0439393939394
 | Jul | 76.97067448680352
 | Aug | 75.2008797653959
 | Sep | 67.80909090909091
 | Oct | 57.63049853372434
 | Nov | 47.36212121212121
 | Dec | 38.72873900293255
Spreadsheet: 748739d1632320073-work-out-daily-amount-to-target-31-day-figures
Sheet: 22nd

 |  |  |  | TURNOVER |  |  |  |  | REVENUE
 | AREA 3 |  |  | Target | Needed Daily | Actual | [NAME] |  | Target | Needed Daily | Actual | [NAME] |  | [NAME]'s | ATV |  | [NAME] | SALT £ |  | TMC |  | BB+ |  | Errors
 | Asda - Aintree
 | Asda - Huyton
 | Asda - Hunts Cross
 | Asda - Horwich
 | Asda - Leigh
 | Asda - Burnley
 | Asda - Westbrook
 | Asda - Widnes
 | Asda - Bromborough
 | Asda - Accrington
 | Asda - Colne
 | Asda - Clayton Green
 | Asda - Runcorn
 | Asda - Blackburn
 | Asda - Walton
 | Asda - Blackpool
 | Asda - Wigan
 | Asda - Preston
Spreadsheet: 109228d1306159129-excel-2007-counting-with-multiple-criteria-including-date-range-sample-analysis
Sheet: Sheet1

Client | Type | O/S | Score | Subscription Date
Client 1 | Gold | O | 17 | 2010-02-03 00:00:00
Client 2 | Gold (Promo) | S | 36 | 2010-02-12 00:00:00
Client 3 | Gold (Promo) | S | 1 | 2010-02-22 00:00:00
Client 4 | Gold | S | 25 | 2010-03-07 14:41:00
Client 5 | Gold | O | 28 | 2010-03-24 00:00:00
Client 6 | Gold | O | 37 | 2010-04-07 00:00:00
Client 7 | Gold (Promo) | S | 0 | 2010-04-26 00:00:00
Client 8 | Silver | S | 4 | 2010-05-25 00:00:00
Client 9 | Gold | S | 47 | 2011-04-19 00:00:00
Client 10 | Silver | S | 50 | 2010-07-22 00:00:00
Client 11 | Silver | S | 24 | 2010-08-23 00:00:00
Client 12 | Silver | O | 3 | 2010-11-19 00:00:00
Client 13 | Silver | O | 0 | 2010-11-28 00:00:00
Client 14 | Silver | S | 12 | 2010-11-28 00:00:00
Client 15 | Silver | S | 1 | 2010-12-16 00:00:00
Client 16 | Gold | S | 34 | 2011-04-19 00:00:00
Client 17 | Gold | S | 53 | 2011-01-04 00:00:00
Client 18 | Silver | O | 58 | 2011-01-14 00:00:00
Client 19 | Gold | O | 5 | 2011-01-23 00:00:00
Client 20 | Silver | O | 6 | 2011-01-31 00:00:00
Client 21 | Gold | O | 38 | 2011-04-19 00:00:00
Client 22 | Gold | O | 36 | 2011-05-05 00:00:00
Spreadsheet: 745393d1629899193-return-numbers-high-to-low-using-formula-includes-negatives-book1
Sheet: Sheet1

JAN | FEB | MAR |  |  |  | Month |  | High to low | Should be (for Feb)
1 | 0 | 2 |  |  |  | FEB |  |  | 3
2 | 3 | 0 |  |  |  |  |  |  | 2
3 | 2 | 4 |  |  |  |  |  |  | 0
0 | 0 | 5 |  |  |  |  |  |  | 0
0 | -5 | 0 |  |  |  |  |  |  | -4
-5 | -4 | 0 |  |  |  |  |  |  | -5