tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 715154d1611588738-index-match-large-duplicate-formula-deviation-totalsorg
Sheet: Top 5 Metal

 | Top 5 Deviated Metal Container NSN's
 |  | January |  |  |  |  | February |  |  |  |  | March
 |  | NSN |  | QTY |  |  | NSN |  | QTY |  |  | NSN |  | QTY
 |  | April |  |  |  |  | May |  |  |  |  | June
 |  | NSN |  | QTY |  |  | NSN |  | QTY |  |  | NSN |  | QTY
 |  | July |  |  |  |  | August |  |  |  |  | September
 |  | NSN |  | QTY |  |  | NSN |  | QTY |  |  | NSN |  | QTY
 |  | October |  |  |  |  | November |  |  |  |  | December
 |  | NSN |  | QTY |  |  | NSN |  | QTY |  |  | NSN |  | QTY
Spreadsheet: eric_saibi__9976__111501R
Sheet: Spurlock 01

Owner Name |  | East Kentucky Power Company
Station Name |  | H L  Spurlock Power Station
Unit Name |  | Spurlock 01
NERC Region |  | ECAR
State |  | KY
Fuel Type |  | Coal
Capacity |  | 508 MW
Start Date |  | 2001-09-24 00:00:00
End Date |  | 2001-11-24 00:00:00
Prv. Start Date |  | 2001-09-24 00:00:00
Prv. End Date |  | 2001-11-15 00:00:00
Comments |  | SCR Tie-in is complete, but unit will stay down for testing of control system.
SIC |  | 4911
Plant ID |  | 1014316
Unit ID |  | 1006482
Outage ID |  | 16533
Spreadsheet: 43317d1241957581-analysing-survel-data-mode-or-count-survey-analysis
Sheet: Sheet3

25 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16
36 | 190096 | 16 | 16 | 16 | 16 | 16 | 16 | 28579716 | 16 | 16 | 16
729 | 81 | 49 | 16 | 16 | 16 | 16 | 16 | 16 | 64 | 193600 | 64
110224 | 64 | 64 | 169 | 121 | 64 | 64 | 18774889 | 2809 | 64 | 144 | 64
1600 | 64 | 64 | 169 | 144 | 64 | 1764 | 64 | 64 | 64 | 64 | 63001
144 | 64 | 64 | 1764 | 64 | 64 | 144 | 64 | 211600 | 64 | 64 | 144
303601 | 64 | 64 | 64 | 1600 | 144 | 64 | 64 | 64 | 3600 | 64 | 64
28430224 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64
81 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64
81 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64
100 | 193600 | 64 | 64 | 64 | 64 | 64 | 64 | 28622500 | 64 | 64 | 64
961 | 169 | 121 | 64 | 64 | 64 | 64 | 64 | 64 | 144 | 193600 | 64
110224 | 64 | 64 | 169 | 121 | 64 | 64 | 18774889 | 2809 | 64 | 144 | 64
1600 | 64 | 64 | 169 | 144 | 64 | 1764 | 64 | 64 | 64 | 64 | 63001
144 | 64 | 64 | 1764 | 64 | 64 | 144 | 64 | 211600 | 64 | 64 | 144
303601 | 64 | 64 | 64 | 1600 | 144 | 64 | 64 | 64 | 3600 | 64 | 64
28430224 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64
81 | 81 | 81 | 81 | 81 | 81 | 81 | 81 | 81 | 81 | 81 | 81
Spreadsheet: 140196d1328645072-search-on-several-criteria-search_criteria
Sheet: form

Nr PL | Nr pp | data_od | data_do | initial state | final state | [NAME] | number2 |  | Number of results
 |  |  |  | 112 |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | Enter what you're looking in cels A2:H2
Nr PL | Nr pp | data_od | data_do | initial state | final state | [NAME] | number2
161585 | 5902062 | 1999-01-13 00:00:00 | 1999-02-13 00:00:00 | 112 | 122 | 13 | 1
161840 | 5902062 | 1999-01-26 00:00:00 | 1999-02-26 00:00:00 | 112 | 135 | 26
Spreadsheet: 582458d1531897594-searching-for-a-value-and-returning-corresponding-row-sample-data
Sheet: Data Sheet

Name | Dept | Age
[NAME] | 501 | 28
[NAME] | 201 | 19
[NAME] | 101 | 22
[NAME] | 301 | 29
[NAME] | 201 | 22
[NAME] | 401 | 21
[NAME] | 101 | 23
[NAME] | 301 | 30
Spreadsheet: 700422d1603191861-dynamic-table_array-value-for-vlookup-function-funding-rate-data-exemple
Sheet: BSVUSDT

Date | Predicted Funding Rate | Funding Rate
2020-10-18 18:00:00 | 0.00010 | 0.00010
2020-10-18 10:00:00 | -0.00022 | -0.00022
2020-10-18 02:00:00 | -0.00011 | -0.00011
2020-10-17 18:00:00 | -0.00017 | -0.00017
2020-10-17 10:00:00 | -0.00018 | -0.00018
2020-10-17 02:00:00 | 0.00000 | 0.00000
2020-10-16 18:00:00 | -0.00009 | -0.00009
2020-10-16 10:00:00 | 0.00032 | 0.00032
2020-10-16 02:00:00 | 0.00016 | 0.00016
2020-10-15 18:00:00 | 0.00020 | 0.00020
2020-10-15 10:00:00 | 0.00021 | 0.00021
2020-10-15 02:00:00 | 0.00011 | 0.00011
2020-10-14 18:00:00 | 0.00041 | 0.00041
2020-10-14 10:00:00 | 0.00055 | 0.00055
2020-10-14 02:00:00 | 0.00010 | 0.00010
2020-10-13 18:00:00 | -0.00005 | -0.00005
2020-10-13 10:00:00 | 0.00016 | 0.00016
2020-10-13 02:00:00 | 0.00020 | 0.00020
2020-10-12 18:00:00 | 0.00018 | 0.00018
2020-10-12 10:00:00 | 0.00029 | 0.00029
2020-10-12 02:00:00 | 0.00024 | 0.00024
2020-10-11 18:00:00 | 0.00009 | 0.00009
2020-10-11 10:00:00 | 0.00007 | 0.00007
2020-10-11 02:00:00 | 0.00005 | 0.00005
2020-10-10 18:00:00 | 0.00032 | 0.00032
2020-10-10 10:00:00 | -0.00017 | -0.00017
2020-10-10 02:00:00 | 0.00031 | 0.00031
2020-10-09 18:00:00 | -0.00002 | -0.00002
2020-10-09 10:00:00 | 0.00020 | 0.00020
2020-10-09 02:00:00 | 0.00008 | 0.00008
2020-10-08 18:00:00 | -0.00011 | -0.00011
2020-10-08 10:00:00 | 0.00003 | 0.00003
2020-10-08 02:00:00 | 0.00012 | 0.00012
2020-10-07 18:00:00 | -0.00005 | -0.00005
2020-10-07 10:00:00 | -0.00006 | -0.00006
2020-10-07 02:00:00 | 0.00019 | 0.00019
2020-10-06 18:00:00 | 0.00005 | 0.00005
2020-10-06 10:00:00 | 0.00004 | 0.00004
2020-10-06 02:00:00 | 0.00024 | 0.00024
2020-10-05 18:00:00 | 0.00038 | 0.00038
2020-10-05 10:00:00 | -0.00006 | -0.00006
2020-10-05 02:00:00 | 0.00002 | 0.00002
2020-10-04 18:00:00 | 0.00024 | 0.00024
Spreadsheet: 111583d1307962378-excel-2007-partial-cell-match-test
Sheet: Sheet1

Column A | Column B
account development | [NAME]
accounting manager | [NAME]
actuary | amicable building
administration officer | anaesthetic sales
adr driver | analysis jobs
advertising account | analyst chemistry
air export | analyst grimsby
air import | analyst job
air quality | analyst jobs
analysis engineer | analyst manchester
analyst insurance | analyst norfolk
analyst manager | analyst programmer
analytical | analytical administrators
 | analytical cemist
 | analytical chemist
 | analytical chemistry
 | analytical jobs
 | analytical [NAME]
 | [NAME]
 | andover jobs
 | andover vmware
 | [NAME]
 | andrex job
 | air quality
 | administration officer
Spreadsheet: 880013d1727621255-stack-multiple-columns-into-one-column-in-excel-book5
Sheet: Table1

Supplier | Amount
Smart Technologies (BD) Ltd. | 15000
MeghOps | 60000
Star Tech & Engineering Ltd. | 34640
[NAME] | 10554570
[NAME] | 57000
[NAME] | 22000
Product Plus Solutions Ltd. | 14400
i-NetworkBD | 4800
SR Technology | 221650
SR Technology | 280490
Mutual Trust Bank Ltd. | 18824.34
Mtec | 3155600
Global Brand Pvt. Ltd. | 31000
Global Brand Pvt. Ltd. | 246000
Star Tech & Engineering Ltd. | 124000
TECH Republic | 450000
Global Brand Pvt. Ltd. | 40500
Studio Innovation Ltd. | 240000
[NAME]. Ltd. | 276753.96
South Bangla | 35000
Star Tech & Engineering Ltd. | 37000
i-NetworkBD | 2500
Excel Technologies Ltd. | 37450
SR Technology | 11920
Marks Energy Solutions Ltd. | 100000
Global Brand Pvt. Ltd. | 335000
Smart Technologies (BD) Ltd. | 690000
Inflow Technologies (Singapore) Pte Ltd. | 54016
Inflow Technologies (Singapore) Pte Ltd. | 1500000
[NAME] | 114765
Bright Techinfo Limited | 2434326
Socradar Cyber Intelligence Inc | 2206976
National Bank Ltd. | 58
Mutual Trust Bank Ltd. | 4110.81
Starseed Technologies (S) Pte. Ltd. | 1933056
National Bank Ltd. | 58
Mutual Trust Bank Ltd. | 4359.33
Smart Technologies (BD) Ltd. | 252580
Smart Technologies (BD) Ltd. | 72660
Smart Technologies (BD) Ltd. | 11232
[NAME] | 86112
Smart Technologies (BD) Ltd. | 33696
3NS Technology BD | 257580
Digimark Solutions | 113650
Excel Technologies Ltd. | 1596130
Intelligent Solutions Ltd. | 297000
Marks energy Solutions Ltd. | 240000
Product plus Solutions Ltd. | 181360
Trade vision Corporation | 155400
Others Installation Charges | 119425
JNR Management Resources Pvt. Ltd. | 88920
Computer City Technologies Ltd. | 365000
RF Electronics | 13000
Inflow Technologies (Singapore) Pte Ltd. | 6172293.96
SLA Vietnam Co. Ltd. | 569520
MIS Technology | 270461
Rasa Technologies | 913360
Studio Innovation | 2271000
Excel Technologies Ltd. | 32000
Others | 1759924
Freight Forwarder | 450000
Bank Gurantee Charge | 9186.38
Bank Interest | 404508.8376
Smart Technologies (BD) Ltd. | 606330
Studio Innovation Ltd. | 552000
Inflow Technologies (Singapore) Pte Ltd. | 1569443.75
Inflow Technologies (Singapore) Pte Ltd. | 2513162.5
Inflow Technologies (Singapore) Pte Ltd. | 9375912
Genius Technology | 673000
RAH Infotech | 1581176.32
Asia iValue Pte. Ltd. | 485760
Bank Interest | 123741.63
Star Tech & Engineering Ltd. | 124000
Inflow Technologies (Singapore) Pte Ltd. | 935550
Inflow Technologies (Singapore) Pte Ltd. | 1927712.8
Forwrder | 40000
Inflow Technologies (Singapore) Pte Ltd. | 456950
[NAME] | 77440
Inflow Technologies (Singapore) Pte Ltd. | 98337.20000000001
Digimark Technologies Ltd. | 47000
Digimark Technologies Ltd. | 94000
Digimark Technologies Ltd. | 94000
Digimark Technologies Ltd. | 47000
Socradar Cyber Intelligence Inc | 1260000
Eguardian Local Services Pte. Ltd. | 1283940
Dhaka Distrbutions | 17200
Digimark Solutions | 47000
Digimark Solutions | 47000
Spreadsheet: 116110d1311606108-sum-best-8-out-10-oom-test1
Sheet: Sheet1

 | [NAME] | G2 | G3 | G4 | G5 | G6 | G7 | G8 | G9 | G10 | best 8 total | result wanted | notes
name 1 | 20 | 9 |  | 5 | 6 |  | 2 | 11 |  |  |  | 53 | less than 8 scores
name 2 | 0 | 3 | 2 | 15 | 1 |  | 6 | 10 | 9 | 8 |  | 54 | 0 is a score
name 3 | 11 | 2 | 11 | 2 | 0 |  | 8 | 7 | 6 | 10 |  | 55 | scores not unique values
Spreadsheet: 06bf0285-1299-4fef-9929-9412aabc640e
Sheet: Data for figure

WATER ABSTRACTIONS BY SECTOR - 1990 vs 2009
To be presented as a separate bar graph for each sector for 1990 and 2009 - within each bar of the graph showing 'stacking' by Region.
Data based on those received from [NAME], 23 JAN 2012 - see email of same date.
Information on year of data from word document from [NAME], email 30 JAN 2012
DATA FOR GRAPH
 | Units: mio.m3/year
 | Energy Cooling | Industry | Irrigation | Public Water Supply
Eastern - 1990 * | 21286.9 | 12702.7 | 8609.9 | 11057.9
Eastern - Latest year available | 19332 | 2351.5 | 1596 | 6416.2
Western - 1990 * | 44820.3 | 18089.5 | 2001.7 | 21342.7
Western - Latest year available | 32321 | 15573.9 | 749.8 | 18843
Southern - 1990 * | 22421.3 | 6559 | 40291.6 | 20116.3
Southern - Latest year available | 18928.4 | 4280 | 38491.8 | 22694.2
Turkey - 1994 | 67.3 | 733.5 | 25090 | 3235.2
Turkey - Latest year available | 92 | 658 | 34035 | 5779
Information for an [NAME] (see following worksheet):
(1) what countries are considered 'Eastern', 'Western' and 'Southern'
(2) *1990 exceptions by region/country and sector
(3) latest year for which data are available by region/country and sector
(4) missing data by country and sector.
Energy Cooling | 1990 | Latest Year
Western Europe | 44820.3 | 32321
Eastern Europe | 21286.9 | 19332
Southern Europe | 22421.3 | 18928.4
Turkey | 67.3 | 92
Industry | 1990 | Latest Year
Western Europe | 18089.5 | 15573.9
Eastern Europe | 12702.7 | 2351.5
Southern Europe | 6559 | 4280
Turkey | 733.5 | 658
Irrigation | 1990 | Latest Year
Western Europe | 2001.7 | 749.8
Eastern Europe | 8609.9 | 1596
Southern Europe | 40291.6 | 38491.8
Turkey | 25090 | 34035
Public Water Supply | 1990 | Latest Year
Western Europe | 21342.7 | 18843
Eastern Europe | 11057.9 | 6416.2
Southern Europe | 20116.3 | 22694.2
Turkey | 3235.2 | 5779
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: C5

Local 5
Nom:
Numéro de téléphone:
[NAME]:
Paiement dû le:
[NAME]:
Réservé:
Prix:
Payé: | NON
Mois réservés
Novembre 2011
Décembre 2011
Janvier 2012
Février 2012
Mars 2012
Avril 2012
Mai 2012
[NAME] 2012
Juillet 2012
Août 2012
Septembre 2012
Octobre 2012
Novembre 2012
Décembre 2012
Spreadsheet: 758097d1638641539-sum-from-multiple-sheets-with-final-sheet-choice-from-drop-down-menu-sum-indirect-eba
Sheet: SUM

 |  |  |  |  |  | Apr | 1 | [NAME]
 | B | C | D |  |  |  | 2 | Feb
Michel |  |  |  |  |  |  | 3 | Mar
[NAME] |  |  |  |  |  |  | 4 | Apr
Johnn |  |  |  |  |  |  | 5 | Mag
 |  |  |  |  |  |  | 6 | Giu
 |  |  |  |  |  |  | 7 | [NAME]
 |  |  |  |  |  |  | 8 | Ago
 |  |  |  |  |  |  | 9 | Set
 |  |  |  |  |  |  | 10 | Ott
 |  |  |  |  |  |  | 11 | Nov
 |  |  |  |  |  |  | 12 | Dic
Spreadsheet: 822211d1679176039-distribute-quantity-according-to-order-price-inventory-distribution
Sheet: Sheet1

 |  |  | Order | 1 |  |  | Order | 2 |  |  | Order | 3 |  |  | Order | 4 |  |  | Order | 5 |  |  | Order | 6 |  |  | Order | 7 |  |  | Order | 8 |  |  | Order | 9 |  |  | Order | 10
 |  |  | Quantity | Price | Distribute | € Total | Qtd | Preço | Distribute | € Total | Qtd | Preço | Distribute | € Total | Qtd | Preço | Distribute | € Total | Qtd | Preço | Distribute | € Total | Qtd | Preço | Distribute | € Total | Qtd | Preço | Distribute | € Total | Qtd | Preço | Distribute | € Total | Qtd | Preço | Distribute | € Total | Qtd | Preço | Distribute | € Total
 |  |  | 10 | 20 |  | 200 | 10 | 14 |  |  | 40 | 12 |  |  | 50 | 1 |  |  | 15 | 10 |  |  | 25 | 20 |  |  | 74 | 30 |  |  | 20 | 5 |  |  | 9 | 1 |  |  | 20 | 12.5
Code | Product | Stock Total |  |  |  | Code | Product | Stock Total
5665468 | A | 200 |  |  |  | 5665468 | B | 150
[NAME] | Price | Distribute | Total | Rank |  | [NAME] | Price | Distribute | Total | Rank |  | [NAME] | Price | Distribute | Total
3 | 100 |  |  |  |  | 3 | 100 |  |  |  |  |  | 20 | 0 | 200
4 | 4 |  |  |  |  | 4 | 4 |  |  |  |  | 10 | 14 | 0 | 0
20 | 11 |  |  |  |  | 20 | 11 |  |  |  |  | 40 | 12 | 0 | 0
3 | 20 |  |  |  |  | 3 | 20 |  |  |  |  | 50 | 1 | 0 | 0
31 | 5 |  |  |  |  | 31 | 5 |  |  |  |  | 15 | 10 | 0 | 0
15 | 15 |  |  |  |  | 15 | 15 |  |  |  |  | 25 | 20 | 0 | 0
5 | 7 |  |  |  |  | 5 | 7 |  |  |  |  | 74 | 30 | 0 | 0
4 | 3 |  |  |  |  | 4 | 3 |  |  |  |  | 20 | 5 | 0 | 0
11 | 12 |  |  |  |  | 11 | 12 |  |  |  |  | 9 | 1 | 0 | 0
12 | 6 |  |  |  |  | 12 | 6 |  |  |  |  | 20 | 12.5 | 0 | 0
Spreadsheet: 846944d1698074370-vba-follow-non-traditional-hyperlink-to-another-tab-same-sheet-book1
Sheet: SheetsLinks

Today
 |  | Worksheet Names
 |  | 0619
 |  | 0626
 |  | 0703
 |  | 0710
 |  | 0717
 |  | 0724
 |  | 0731
 |  | 0807
 |  | 0814
 |  | 0821
 |  | 0828
 |  | 0904
 |  | 0911
 |  | 0918
 |  | 0925
 |  | 1002
 |  | 1009
 |  | 1016
 |  | 1023
 |  | 1030
 |  | 1106
 |  | 1113
 |  | 1120
 |  | 1127
 |  | 1204
 |  | 1211
 |  | 1218
 |  | 1225
Spreadsheet: 679533d1590479023-text-join-ignoring-blanks-but-limited-to-a-maximum-of-five-entries-topictest-spreadsheet-draft-3-
Sheet: 01 Calculations (2)

Question Number
MathsWatch Clip |  | N18 | N18 | N19b | N19a | 21 | N2b | N17b | N28b | N29b | [NAME] | G21a | S7
 |  | Use negative number in a temperature context | Use negative number in a temperature context | Multiply and divide using negative numbers | Add and subtract using negative numbers | Use inverse operations to find missing numbers in calculations | Order decimal numbers | Multiply and divide numbers by powers of 10 | Multiply decimal numbers without a calculator | Divide decimal numbers without a calculator | Extend a geometric sequence where the term to term rule is | Multiply 3 decimals together to find the volume of a cuboid | Find the mean of decimal numbers | Total Marks | First 3 Incorrect Questions | Suggested MathsWatch Clips
 | % | 3 | 3 | 3 | 4 | 5 | 2 | 3 | 1 | 1 | 2 | 2 | 2
A |  | 3 | 3 | 0 | 4 | 0 | 2 | 3 | 0 | 1 | 1 | 2 | 2
B |  | 3 | 3 | 2 | 4 | 5 | 1 | 2 | 1 | 0 | 2 | 2 | 2
C |  | 3 | 3 | 2 | 0 | 4 | 2 | 3 | 0 | 1 | 2 | 2 | 2
D |  | 3 | 2 | 2 | 4 | 5 | 0 | 3 | 1 | 1 | 2 | 0 | 2
E |  | 2 | 3 | 3 | 4 | 4 | 2 | 3 | 1 | 1 | 2 | 2 | 2
F |  | 3 | 0 | 3 | 1 | 2 | 2 | 3 | 1 | 1 | 2 | 2 | 2
G |  | 3 | 3 | 3 | 2 | 2 | 0 | 1 | 1 | 1 | 2 | 2 | 2
H |  | 3 | 0 | 0 | 4 | 5 | 2 | 3 | 1 | 0 | 1 | 2 | 2
I |  | 3 | 3 | 3 | 3 | 5 | 2 | 3 | 1 | 1 | 2 | 2 | 2
J |  | 2 | 3 | 0 | 4 | 2 | 2 | 3 | 1 | 1 | 2 | 2 | 2
K |  | 3 | 0 | 0 | 4 | 5 | 1 | 3 | 1 | 1 | 2 | 0 | 2
L |  | 3 | 3 | 2 | 2 | 0 | 2 | 2 | 1 | 1 | 2 | 2 | 2
M |  | 3 | 2 | 3 | 0 | 5 | 0 | 3 | 0 | 1 | 2 | 2 | 2
N |  | 3 | 3 | 1 | 4 | 5 | 2 | 3 | 1 | 1 | 2 | 2 | 2
O |  | 3 | 2 | 3 | 0 | 0 | 2 | 3 | 1 | 1 | 2 | 2 | 2
P |  | 3 | 3 | 1 | 4 | 5 | 2 | 3 | 1 | 1 | 1 | 0 | 2
Q |  | 2 | 3 | 1 | 1 | 3 | 1 | 3 | 1 | 1 | 2 | 2 | 2
R |  | 3 | 0 | 3 | 4 | 0 | 2 | 3 | 1 | 1 | 2 | 2 | 2
S |  | 3 | 3 | 0 | 4 | 0 | 2 | 1 | 1 | 1 | 2 | 2 | 2
T |  | 3 | 3 | 3 | 3 | 5 | 2 | 3 | 1 | 1 | 2 | 1 | 2
U |  | 2 | 3 | 1 | 4 | 0 | 1 | 3 | 1 | 1 | 2 | 2 | 2
V |  | 3 | 0 | 3 | 4 | 5 | 0 | 3 | 1 | 1 | 2 | 2 | 2
W |  | 3 | 3 | 3 | 4 | 5 | 2 | 2 | 0 | 1 | 2 | 2 | 2
X |  | 3 | 3 | 1 | 3 | 5 | 2 | 3 | 1 | 1 | 2 | 2 | 2
Y |  | 3 | 3 | 3 | 4 | 0 | 0 | 3 | 1 | 1 | 1 | 0 | 2
Z |  | 3 | 0 | 3 | 3 | 5 | 0 | 3 | 1 | 1 | 2 | 1 | 2
AA |  | 3 | 3 | 0 | 4 | 3 | 2 | 1 | 1 | 1 | 2 | 2 | 2
AB |  | 3 | 3 | 3 | 4 | 4 | 2 | 3 | 1 | 1 | 2 | 2 | 2
AC |  | 0 | 0 | 0 | 4 | 5 | 1 | 2 | 0 | 0 | 1 | 0 | 2
AD |  | 3 | 3 | 0 | 4 | 5 | 2 | 3 | 1 | 0 | 2 | 2 | 2
AE |  | 3 | 3 | 3 | 4 | 5 | 0 | 3 | 1 | 1 | 2 | 2 | 2
Spreadsheet: 710933d1609324270-max-of-sumproduct-fields-match-a-range-of-criteria-book1-9-ans
Sheet: Sheet1

A | 66 | 24 | X |  |  | FORMULA
B | 86 | 3 | C
C | 92 | 11 | K
 | 74 | 1 | A
 | 51 | 1 | A
 | 60 | 3 | C
 | 58 | 4 | D
 | 3 | 10 | J
 | 2 | 2 | B |  |  |  |  |  | 1X6 | 6X3
Spreadsheet: kate_symes__18949__NP 15 pages
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-03-28 00:00:00 |  | 142.39 | 35120 | 78.18 | 4400
 | 2001-03-27 00:00:00 |  | 140.58 | 29520 | 76.2 | 4000
 | 2001-03-26 00:00:00 |  | 266.09 | 24560 | 155.06 | 6160
 | 2001-03-25 00:00:00 |  |  |  |  |  | 153.65 | 16680
 | 2001-03-24 00:00:00 |  | 270.02 | 21120 | 152.5 | 5840
 | 2001-03-23 00:00:00 |  | 270.02 | 21120 | 152.5 | 5840
 | 2001-03-22 00:00:00 |  | 294.15 | 12720 | 177.94 | 7200
 | 2001-03-21 00:00:00 |  | 406.47 | 10320 | 234.87 | 5400
 | 2001-03-20 00:00:00 |  | 391.63 | 25920 | 261.33 | 9000
 | 2001-03-19 00:00:00 |  | 362.59 | 19760 | 274.08 | 10440
 | 2001-03-18 00:00:00 |  |  |  |  |  | 262.23 | 32520
 | 2001-03-17 00:00:00 |  | 237.03 | 39120 | 176.44 | 8200
 | 2001-03-16 00:00:00 |  | 238.66 | 44720 | 176.44 | 8200
 | 2001-03-15 00:00:00 |  | 190.53 | 14720 | 144.42 | 7600
 | 2001-03-14 00:00:00 |  | 177.21 | 17120 | 139.11 | 8840
 | 2001-03-13 00:00:00 |  | 178.33 | 18000 | 141.6 | 9400
 | 2001-03-12 00:00:00 |  | 207.12 | 14000 | 167.55 | 6200
 | 2001-03-11 00:00:00 |  |  |  |  |  | 167.57 | 18000
 | 2001-03-10 00:00:00 |  | 189.97 | 30000 | 155.94 | 17200
 | 2001-03-09 00:00:00 |  | 189.87 | 30000 | 155.94 | 17200
 | 2001-03-08 00:00:00 |  | 229.83 | 26400 | 158.24 | 4200
 | 2001-03-07 00:00:00 |  | 340.07 | 30160 | 231.96 | 15000
 | 2001-03-06 00:00:00 |  | 362.98 | 29744 | 264.17 | 13200
 | 2001-03-05 00:00:00 |  | 340.79 | 20544 | 261.21 | 8664
 | 2001-03-04 00:00:00 |  |  |  |  |  | 261.21 | 25992
 | 2001-03-03 00:00:00 |  | 271.59 | 21456 | 238.52 | 8664
 | 2001-03-02 00:00:00 |  | 271.59 | 21456 | 238.52 | 8664
 | 2001-03-01 00:00:00 |  | 282.13 | 32240 | 216.41 | 12640
 | 2001-02-28 00:00:00 |  | 210.95 | 35888 | 157.73 | 17224
 | 2001-02-27 00:00:00 |  | 212.87 | 43088 | 151.44 | 17224
 | 2001-02-26 00:00:00 |  | 213.28 | 12320 | 160.3 | 8024
Spreadsheet: 838594d1691157910-how-do-i-count-a-block-of-numbers-in-excel-example
Sheet: Sheet1

Name | Products | Qty
Row 1 | [PHONE], [PHONE] | 2
Row 2 | [PHONE], [PHONE], [PHONE] | 3
Row 3 | [PHONE], [PHONE], [PHONE], [PHONE] | 4
Row 4 | [PHONE], [PHONE], [PHONE] | 3
Row 5 | [PHONE], [PHONE], [PHONE], *[PHONE] | 4
Row 6 | [PHONE], [PHONE], [PHONE] | 3
Row 7 | [PHONE], [PHONE], [PHONE] | 3
 | Looking for a formula that automaticly counts the qty
Spreadsheet: 6ec2d07a-7160-4c99-abcc-603213ff9f02
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
FHPCF | Test | FHPCF | Heparin Cofactor II | Heparin Cofactor II | Chromogenic |  |  |  | 1 | mL | Draw blood in a light blue-top (sodium citrate) tube. Spin down and send 1 mL of citrated plasma frozen in a plastic vial. Note: Separate specimens must be submitted when multiple tests are ordered. | 0.5 mL | Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | 65-145%   RUO-When making a clinical diagnosis, this test should be used in conjunction with other established laboratory tests or clinical observations.   Test Performed By:  Esoterix Coagulation                                          8490 Upland Dr.                                          Suite 100                                          Englewood, CO 80112 | Every other Wednesday | 1-6 days | 20 days | 1 | 85130 |  |  |  |  | Esoterix Coagulation
FHPCF | [NAME] | NACIT | [NAME] |  |  |  | Frozen
FHPCF | Result | Z0213 | Heparin Cofactor II | Heparin Cofactor II | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 3268-0
Spreadsheet: 100154d1298576360-currency-conditional-formatting-error-copy-of-example-formating
Sheet: currency input 

Currency input
 |  |  |  |  |  |  |  |  |  |  | USD
Select the currency |  |  |  |  |  |  |  |  |  |  | PLN
Currency | GBP |  |  |  |  |  |  |  |  |  | HRK
Current exchange rates
 | GBP | EUR | USD | PLN | HRK
GBP | 1 | 1.1678 | 1.6108 | 4.6553 | 8.6702
EUR | 0.8564 | 1 | 1.3795 | 3.9867 | 7.4243
USD | 0.6207 | 0.7247 | 1 | 2.89 | 5.3825
PLN | 0.2148 | 0.2508 | 0.346 | 1 | 1.8625
HRK | 0.1153 | 0.1346 | 0.1858 | 0.5369 | 1
Spreadsheet: 157233d1337677083-trouble-with-tabulating-final-score-selection-done-by-radio-buttons-test
Sheet: Scoresheet

Criteria/Subcriteria | Weight |  |  |  |  |  | Total
Quality | 0.2
Product Quality | 0.25
Corrective Action Management | 0.25
Quality Management Policies / Practices / Processes | 0.25
Document Management Quality | 0.25
 | Weight |  |  |  |  |  | Total
Price/Cost | 0.1
CPI | 0.5
Cost Reduction Efforts | 0.25
Payment Term Flexibility | 0.25
 | Weight |  |  |  |  |  | Total
Management | 0.2
Communication | 0.5
Representation | 0.25
Sub-Tier Supplier Management | 0.25
 | Weight |  |  |  |  |  | Total
Technical | 0.2
Technical Compliance | 0.5
Manpower | 0.25
Technical Project Management | 0.25
 | Weight |  |  |  |  |  | Total
Responsiveness | 0.2
Timeliness | 0.5
[NAME] | 0.25
Effective Communication | 0.25
 | Weight |  |  |  |  |  | Total
Compliance of Schedule | 0.1
SPI | 0.5
Schedule/Delivery Improvement Efforts | 0.5
Note: The %'s are defaults and can be altered
Spreadsheet: 844943d1696533976-priority-task-list-book3-hd
Sheet: Top 10

Priority | Task # | Title | Desciption
1 | 1004 | Title 4 | [NAME] 4 |  |  | Title 4 | [NAME] 4
2 | 1020 | Title 20 | [NAME] 20 | 2 | 1020 | Title 20 | [NAME] 20
3 | 1006 | Title 6 | [NAME] 6 | 3 | 1006 | Title 6 | [NAME] 6
4 | 1024 | Title 24 | [NAME] 24 | 4 | 1024 | Title 24 | [NAME] 24
5 | 1016 | Title 16 | [NAME] 16 | 5 | 1016 | Title 16 | [NAME] 16
6 | 1008 | Title 8 | [NAME] 8 | 6 | 1008 | Title 8 | [NAME] 8
7 | 1018 | Title 18 | [NAME] 18 | 7 | 1018 | Title 18 | [NAME] 18
8 | 1010 | Title 10 | [NAME] 10 | 8 | 1010 | Title 10 | [NAME] 10
9 | 1028 | Title 28 | [NAME] 28 | 9 | 1028 | Title 28 | [NAME] 28
10 | 1032 | Title 32 | [NAME] 32 | 10 | 1032 | Title 32 | [NAME] 32
1
2
3
4
5 |  |  |  | What I'm getting
6
7
8
9
10
VLOOKUP(LARGE($D$2:$D$36,37-ROW()),$D$2:$F$36,2,) |  |  |  | Works on Top 20 Tab
VLOOKUP(LARGE(List!$A$2:$A$41,42-ROW()),List!$A$2:$D$41,2,) |  |  |  | Does not work on this tab