tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kimberly_watson__20552__imbalsumm0108
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 7793 | 6031 |  |  | 1235 | 1150 | 1454 | 1283
2 | 7791 | 6031 |  |  | 1177 | 1150 | 1476 | 1283
3 | 5994 | 6031 |  |  | 1174 | 1150 | 1523 | 1283
4 | 7564 | 6031 |  |  | 1155 | 1150 | 1485 | 1283
5 | 7266 | 6031 |  |  | 1111 | 1150 | 1460 | 1283
6 | 7106 | 6031 |  |  | 1102 | 1150 | 1390 | 1283
7 | 6854 | 6031 |  |  | 1149 | 1150 | 1444 | 1283
8 | 6932 | 6031 |  |  | 1096 | 1150 | 1417 | 1283
9 | 6825 | 6031 |  |  | 1073 | 1150 | 1479 | 1283
10 | 7236 | 6031 |  |  | 1025 | 1150 | 1307 | 1283
11 | 7066 | 6031 |  |  | 1044 | 1150 | 1444 | 1283
12
13
14
15
16
17
18
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  |  |  |  |  |  |  | 372841.88
2001-08-11 00:00:00
CBS Volume
 |  |  | 146405
Spreadsheet: 29198d1224049623-sumproduct-gives-wrong-answer-learning-plan-hoganas-draft
Sheet: Rooms

 |  |  |  |  |  |  |  |  |  |  |  |  | Week 46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 46
 |  |  |  |  |  |  |  |  |  |  |  |  | M |  |  |  | T |  |  |  | W |  |  |  | T |  |  |  | F |  |  |  | M |  |  |  | T |  |  |  | W |  |  |  | T |  |  |  | F |  |  |  | M |  |  |  | T |  |  |  | W |  |  |  | T |  |  |  | F |  |  |  | M |  |  |  | T |  |  |  | W |  |  |  | T |  |  |  | F |  |  |  | M |  |  |  | T |  |  |  | W |  |  |  | T |  |  |  | F
Roon Name | Location | Seats | Facilities |  |  |  |  |  |  |  |  |  | 08-10 | 10-12 | 13-15 | 15-17 | 08-10 | 10-12 | 13-15 | 15-17 | 08-10 | 10-12 | 13-15 | 15-17 | 08-10 | 10-12 | 13-15 | 15-17 | 08-10 | 10-12 | 13-15 | 15-17 | 08-10 | 10-12 | 13-15 | 15-17 | 08-10 | 10-12 | 13-15 | 15-17 | 08-10 | 10-12 | 13-15 | 15-17 | 08-10 | 10-12 | 13-15 | 15-17 | 08-10 | 10-12 | 13-15 | 15-17 | 08-10 | 10-12 | 13-15 | 15-17 | 08-10 | 10-12 | 13-15 | 15-17 | 08-10 | 10-12 | 13-15 | 15-17 | 08-10 | 10-12 | 13-15 | 15-17 | 08-10 | 10-12 | 13-15 | 15-17 | 08-10 | 10-12 | 13-15 | 15-17 | 08-10 | 10-12 | 13-15 | 15-17 | 08-10 | 10-12 | 13-15 | 15-17 | 08-10 | 10-12 | 13-15 | 15-17 | 08-10 | 10-12 | 13-15 | 15-17 | 08-10 | 10-12 | 13-15 | 15-17 | 08-10 | 10-12 | 13-15 | 15-17 | 08-10 | 10-12 | 13-15 | 15-17 | 08-10 | 10-12 | 13-15 | 15-17 | 08-10 | 10-12 | 13-15 | 15-17
Marknad | [NAME] | 18 |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 1 | 1
Process | [NAME] | 12 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
Spreadsheet: 112105d1308250623-vertical-line-alignment-with-x-axis-vline-test
Sheet: Scratch Sheet

 |  |  | 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
A | A |  | 27
A | B |  | 28
A | C |  | 29
A | D |  | 30
A | E |  | 31
A | F |  | 32
A | G |  | 33
A | H |  | 34
A | I |  | 35
A | J |  | 36
A | K |  | 37
A | L |  | 38
A | M |  | 39
A | N |  | 40
A | O |  | 41
A | P |  | 42
A | Q |  | 43
A | R |  | 44
A | S |  | 45
A | T |  | 46
A | U |  | 47
A | V |  | 48
A | W |  | 49
A | X |  | 50
A | Y |  | 51
A | Z |  | 52
B | A |  | 53
B | B |  | 54
B | C |  | 55
B | D |  | 56
B | E |  | 57
B | F |  | 58
B | G |  | 59
B | H |  | 60
B | I |  | 61
B | J |  | 62
B | K |  | 63
B | L |  | 64
B | M |  | 65
B | N |  | 66
B | O |  | 67
B | P |  | 68
B | Q |  | 69
B | R |  | 70
B | S |  | 71
B | T |  | 72
B | U |  | 73
B | V |  | 74
B | W |  | 75
B | X |  | 76
B | Y |  | 77
B | Z |  | 78
C | A |  | 79
C | B |  | 80
C | C |  | 81
C | D |  | 82
C | E |  | 83
C | F |  | 84
C | G |  | 85
C | H |  | 86
C | I |  | 87
C | J |  | 88
C | K |  | 89
C | L |  | 90
C | M |  | 91
C | N |  | 92
C | O |  | 93
C | P |  | 94
C | Q |  | 95
C | R |  | 96
C | S |  | 97
C | T |  | 98
C | U |  | 99
C | V |  | 100
C | W |  | 101
C | X |  | 102
C | Y |  | 103
C | Z |  | 104
D | A |  | 105
D | B |  | 106
D | C |  | 107
D | D |  | 108
D | E |  | 109
D | F |  | 110
D | G |  | 111
D | H |  | 112
D | I |  | 113
D | J |  | 114
D | K |  | 115
D | L |  | 116
D | M |  | 117
D | N |  | 118
D | O |  | 119
D | P |  | 120
D | Q |  | 121
D | R |  | 122
D | S |  | 123
D | T |  | 124
D | U |  | 125
D | V |  | 126
D | W |  | 127
D | X |  | 128
D | Y |  | 129
D | Z |  | 130
E | A |  | 131
E | B |  | 132
E | C |  | 133
E | D |  | 134
E | E |  | 135
E | F |  | 136
E | G |  | 137
E | H |  | 138
E | I |  | 139
E | J |  | 140
E | K |  | 141
E | L |  | 142
E | M |  | 143
E | N |  | 144
E | O |  | 145
E | P |  | 146
E | Q |  | 147
E | R |  | 148
E | S |  | 149
E | T |  | 150
E | U |  | 151
E | V |  | 152
E | W |  | 153
E | X |  | 154
E | Y |  | 155
E | Z |  | 156
F | A |  | 157
F | B |  | 158
F | C |  | 159
F | D |  | 160
F | E |  | 161
F | F |  | 162
F | G |  | 163
F | H |  | 164
F | I |  | 165
F | J |  | 166
F | K |  | 167
F | L |  | 168
F | M |  | 169
F | N |  | 170
F | O |  | 171
F | P |  | 172
F | Q |  | 173
F | R |  | 174
F | S |  | 175
F | T |  | 176
F | U |  | 177
F | V |  | 178
F | W |  | 179
F | X |  | 180
F | Y |  | 181
F | Z |  | 182
Spreadsheet: 848553d1699281587-complex-problem-on-how-to-analyze-sales-data-sales-data
Sheet: Data Y2

Article number | Country | 2022.01 | 2022.02 | 2022.03 | 2022.04 |  | These are the week numbers
1001 | NL | 2 | 0 | 1 | 0
1001 | BE | 4 | 1 | 1 | 2 |  |  | 1002 isn't being sold this year so this should not be taken into the Pivot
1001 | FR | 5 | 0 | 1 | 6 |  |  | PL is a new country, so if this is included in the analysis then the numbers give a false perspective
1001 | DE | 1 | 8 | 2 | 5 |  |  | 1006 wasn't sold last year so this should not be taken into account as well
1001 | PL | 2 | 5 | 3 | 0
1003 | NL | 3 | 3 | 2 | 1
1003 | BE | 7 | 2 | 5 | 3
1003 | FR | 0 | 5 | 7 | 3
1003 | DE | 4 | 8 | 3 | 3
1003 | PL | 1 | 7 | 4 | 2
1004 | NL | 5 | 5 | 6 | 3
1004 | BE | 0 | 4 | 1 | 6
1004 | FR | 5 | 2 | 2 | 5
1005 | NL | 3 | 3 | 0 | 3
1005 | BE | 1 | 7 | 7 | 5
1006 | NL | 5 | 5 | 3 | 7
1006 | BE | 7 | 0 | 1 | 2
1006 | FR | 9 | 4 | 1 | 7
1006 | DE | 1 | 3 | 2 | 5
1006 | PL | 0 | 0 | 0 | 7
Spreadsheet: 136004d1326365314-linking-worksheets-multi-year-testing-data-sheets
Sheet: student record

year | 2011
ID/Name | 102
 |  | spelling | maths | reading
 | Current Year
 | Previous Year
 | Improvement
Spreadsheet: 852144d1702236994-change-formatting-in-power-query-of-data-set-powerquery-example-misty15-
Sheet: Sheet2

Vendor | Category | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sept | Oct | Nov | Dec
Corvette | Overall Stat | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Corvette | Last OBM Risk | Satisfactory | Needs Improvement | Satisfactory | Ugrade Needed | Satisfactory | Satisfactory | Satisfactory | Satisfactory | Satisfactory | Satisfactory | Satisfactory | Satisfactory
Corvette | Last OAR Risk | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA
Corvette | Last ABC Risk | Unsatisfactory | Satisfactory | Satisfactory | Unsatisfactory | Satisfactory | Unsatisfactory | Satisfactory | Satisfactory | Satisfactory | Satisfactory | Satisfactory | Satisfactory
Bricklin | Overall Stat | 1 | 2 | 3 | 4 | 5 | 1 | 2 | 3 | 1 | 1 | 1 | 1
Bricklin | Last OBM Risk | Low Risk | Low Risk | Low Risk | Low Risk | High Risk | Low Risk | Low Risk | Low Risk | Low Risk | Low Risk | Low Risk | Low Risk
Bricklin | Last OAR Risk | Satisfactory | Unsatisfactory | Satisfactory | Satisfactory | Unsatisfactory | Satisfactory | Needs Improvement | Needs Improvement | Satisfactory | Satisfactory | Satisfactory | Satisfactory
Bricklin | Last ABC Risk | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA
Spreadsheet: 140564d1328803918-lookup-from-another-sheet-book2
Sheet: Sheet1

abc | Server1 | def | Y | 123
ghi | Server3 | jkl | N | 456
mno | PC2 | opq | Y | 789
rst | PC5 | uvw | Y | 12
cba | Server4 | fed | N | 345
Spreadsheet: 96862d1296129483-validation-lists-validation-1-
Sheet: Sheet1

Dept | Description | Helper |  | Validation | Dept | Description |  |  |  |  |  | d0001|Department No 1 | d0001 | Department No 1
d0001 | Department No 1 | d0001|Department No 1 |  | d0002|Department No 2 | [NAME] | Department No 2 |  |  |  |  |  | d0002|Department No 2 | [NAME] | Department No 2
[NAME] | Department No 2 | d0002|Department No 2 |  | d0008|Department No 19 | d0019 | Department No 19 |  |  |  |  |  | d0003|Department No 3 | d0003 | Department No 3
d0003 | Department No 3 | d0003|Department No 3 |  |  |  |  |  |  |  |  |  | d0004|Department No 4 | d0004 | Department No 4
d0004 | Department No 4 | d0004|Department No 4 |  |  |  |  |  |  |  |  |  | d0005|Department No 5 | d0005 | Department No 5
d0005 | Department No 5 | d0005|Department No 5 |  |  |  |  |  |  |  |  |  | d0006|Department No 6 | d0006 | Department No 6
d0006 | Department No 6 | d0006|Department No 6 |  |  |  |  |  |  |  |  |  | d0007|Department No 7 | d0007 | Department No 7
d0007 | Department No 7 | d0007|Department No 7 |  |  |  |  |  |  |  |  |  | d0008|Department No 8 | d0008 | Department No 8
d0008 | Department No 8 | d0008|Department No 8 |  |  |  |  |  |  |  |  |  | d0008|Department No 9 | d0009 | Department No 9
 |  |  |  |  |  |  |  |  |  |  |  | d0008|Department No 10 | d0010 | Department No 10
 |  |  |  |  |  |  |  |  |  |  |  | d0008|Department No 11 | d0011 | Department No 11
 |  |  |  |  |  |  |  |  |  |  |  | d0008|Department No 12 | d0012 | Department No 12
 |  |  |  |  |  |  |  |  |  |  |  | d0008|Department No 13 | d0013 | Department No 13
 |  |  |  |  |  |  |  |  |  |  |  | d0008|Department No 14 | d0014 | Department No 14
 |  |  |  |  |  |  |  |  |  |  |  | d0008|Department No 15 | d0015 | Department No 15
 |  |  |  |  |  |  |  |  |  |  |  | d0008|Department No 16 | d0016 | Department No 16
 |  |  |  |  |  |  |  |  |  |  |  | d0008|Department No 17 | d0017 | Department No 17
 |  |  |  |  |  |  |  |  |  |  |  | d0008|Department No 18 | d0018 | Department No 18
 |  |  |  |  |  |  |  |  |  |  |  | d0008|Department No 19 | d0019 | Department No 19
Spreadsheet: 744967d1629618058-lookup-data-with-3-criteria-one-of-them-in-merged-cell-lookup-report-ans-2
Sheet: Report

HELPER ROW
 | Area 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Area 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Area 3
 | Material 1 | Material 2 | Material 3 | Material 4 | Material 5 | Material 6 | Material 7 | Material 8 | Material 9 | Material 10 | Material 11 | Material 12 | Material 13 | Material 14 | Material 15 | Material 16 | Total |  | Material 1 | Material 2 | Material 3 | Material 4 | Material 5 | Material 6 | Material 7 | Material 8 | Material 9 | Material 10 | Material 11 | Material 12 | Material 13 | Material 14 | Material 15 | Material 16 | Total |  | Material 1 | Material 2 | Material 3 | Material 4 | Material 5 | Material 6 | Material 7 | Material 8 | Material 9 | Material 10 | Material 11 | Material 12 | Material 13 | Material 14 | Material 15 | Material 16 | Total
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
Spreadsheet: 269864d1381311092-concatenate-but-eliminate-the-error-cells-check
Sheet: Sheet1

Lookup values |  |  |  |  |  |  |  |  |  |  |  | Vlookup values |  |  |  | Required Output format
1 | apple | 1 |  | 1 |  |  |  |  |  |  | 1
15 |  | 2 | Milk | 2 |  |  |  |  |  |  | 2
14 | Fish | 3 |  | 3 | sweet |  |  |  |  |  | 3
4 | orange | 12 |  | 4 |  |  |  |  |  |  | 4
5 | Coke | 5 |  | 5 |  |  |  |  |  |  | 5
6 |  | 18 |  | 6
7 | Fish | 7 | rod | 7
8 |  | 8 |  | 8
11 | Coke | 9 | Rose | 9
Spreadsheet: 855764d1705270994-any-way-to-add-1-to-two-separate-cells-untitled-spreadsheet-2-
Sheet: Active List

 | min | inventory in stock | NEWLY MADE | Needed |  | Year total
Product 1 | 4 | 1 | 3 |  |  | ?
Product 2 | 5 | 2 | 1
Product 3 | 2 | 1
Product 4 | 4 | 1
Product 5 | 6 | 1
Product 6 | 8 | 5
Product 7 | 5 | 1
Product 8 | 3 | 2
Product 9 | 8 | 3
Product 10 | 4 | 1
Spreadsheet: 867566d1714401628-substitute-with-array-of-criteria-substitute-with-array-of-criteria_v2
Sheet: Sheet1

 | Data |  |  | Criteria to remove in data set |  |  |  | Required Output |  | [NAME]
 | text1 abc |  |  | text1 |  |  |  | abc
 | def [NAME] text1 |  |  | text2 |  |  |  | def
 | 39734 sdlkdjs - text3 |  |  | - text3 |  |  |  | 39734 sdlkdjs
 | sksj [NAME] (50 mins) |  |  | (50 mins) |  |  |  | sksj [NAME]
 | sksj [NAME] (50 mins) |  |  | text4 |  |  |  | sksj [NAME]
 | (50 mins) ghi moretext |  |  | moretext |  |  |  | ghi
 | text1 - text3 jkl |  |  |  |  |  |  | jkl
Spreadsheet: 78063d1278513197-selecting-specific-cells-find8digitnumbers
Sheet: Results

 | 73641949 |  |  |  |  |  |  |  |  | #N/A
 | 73641370 |  |  |  |  |  |  |  |  | #N/A
 | 73631865 |  |  |  |  |  |  |  |  | #N/A
 | 73814023 |  |  |  |  |  |  |  |  | #N/A
 | 73747681 |  |  |  |  |  |  |  |  | #N/A
 | 73751673 |  |  |  |  |  |  |  |  | #N/A
 | 73751436 |  |  |  |  |  |  |  |  | #N/A
 | 73808767 |  |  |  |  |  |  |  |  | #N/A
73644768 |  |  |  |  |  |  |  |  |  | #N/A
 |  |  | 73821222 |  |  |  |  |  |  | #N/A
 |  |  | 73823953 |  |  |  |  |  |  | #N/A
 |  |  | 73827486 |  |  |  |  |  |  | #N/A
 |  |  | 73829790 |  |  |  |  |  |  | #N/A
 |  |  | 73827988 |  |  |  |  |  |  | #N/A
 |  |  | 73828002 |  |  |  |  |  |  | #N/A
 |  |  | 73827985 |  |  |  |  |  |  | #N/A
 |  |  | 73771120 |  |  |  |  |  |  | #N/A
 |  |  | 73853927 |  |  |  |  |  |  | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 80763d1280955026-count-days-between-dates-open-jobs-count
Sheet: Sheet1

Open Jobs in Days: | <35 Days | 36-60 Days | 61-90 Days
Legal | 0 | 0 | 0
Finance | 0 | 0 | 0
HR | 0 | 0 | 0
TOTAL JOBS | 0 | 0 | 0
Department | Date of Posting
Legal | 2010-07-01 00:00:00
Finance | 2010-07-10 00:00:00
Legal | 2010-07-15 00:00:00
Finance | 2010-07-20 00:00:00
HR | 2010-07-25 00:00:00
Legal | 2010-08-01 00:00:00
Legal | 2010-08-01 00:00:00
Spreadsheet: 150292d1334394826-sorting-and-conditional-selecting-of-data-from-sheet-1-inserted-to-sheet-2-sorting-and-conditional-selecting_pt_jpr73
Sheet: Data

Test | Year | Text
Test 1 | 2008 | Random text 1
Test 2 | 2010 | Random text 2
Test 3 | 2007 | Random text 3
Test 4 | 2008 | Random text 4
Test 5 | 2008 | Random text 5
Test 6 | 2010 | Random text 6
Spreadsheet: 754523d1636301750-iferror-with-icon-set-or-alternative-text-inv-tracker
Sheet: INV

 | Inventory |  |  |  |  |  |  |  |  |  |  |  |  | Stock Tracker
 |  |  |  |  |  |  |  |  |  |  |  |  | Date
 |  |  |  |  |  |  |  |  |  |  |  |  | Description/Event
 |  |  |  |  |  |  |  |  |  |  |  |  | Contact
 |  |  |  |  |  |  |  |  |  |  |  |  | Department
 |  |  |  |  |  |  |  |  |  |  |  |  | Job Number
 |  |  |  |  |  |  |  |  |  |  |  |  | Budget Code
 | Index | Reorder | Shelf | Price | Product | Group | Opening stock | Usage | Closing stock | Reorder level | Reorder time in days | Reorder quantity | Supplier | Tracker 1 | Tracker 2 | Tracker 3
 | 1 |  | A1 | 1 | Product 1 | Promo | 60 |  |  | 50 | 7 | 100 | Supplier 1 | 2 | 7
 | 2 |  | A1 | 2 | Product 2 | Promo | 50 |  |  | 50 | 7 | 10 | Supplier 2
 | 3 |  | A1 | 3 | Product 3 | Promo | 50 |  |  | 50 | 7 | 100 | Supplier 3
 | 4 |  | A1 | 1.1 | Product 4 | Promo | 50 |  |  | 50 | 7 | 100 | Supplier 4
 | 5 |  | A2 | 0.22 | Product 5 | Promo | 110 |  |  | 110 | 10 | 100 | Supplier 5 |  |  | 5
 | 6 |  | A11 | 0.75 | Product 6 | Promo | 120 |  |  | 110 | 12 | 75 | Supplier 6
 | 7 |  | A3 | 0.5 | Product 7 | Promo | 110 |  |  | 110 | 14 | 50 | Supplier 7
 | 8 |  | A4 | 1 | Product 8 | Promo | 75 |  |  | 75 | 7 | 75 | Supplier 7
 | 9 |  | A5 | 6 | Product 9 | Promo | 75 |  |  | 75 | 30 | 100 | Supplier 8 | 10
 | 10 |  | A6 | 0.65 | Product 10 | Promo | 75 |  |  | 75 | 2 | 50 | Supplier 9
 | 11 |  | A7 | 0.4 | Product 11 | Promo | 75 |  |  | 75 | 5 | 50 | Supplier 10
 | 12 |  | A9 | 0.55 | Product 12 | Promo | 101 |  |  | 100 | 5 | 50 | Supplier 11
 | 13 |  | A10 | 0.55 | Product 13 | Promo | 55 |  |  | 50 | 5 | 50 | Supplier 12 | 6
Spreadsheet: 5638573f-5dcb-4f5c-96d4-2e1b2e6a1fb9
Sheet: Table 8.4

8.4 Short-term interest rates
 |  |  |  |  |  | Months (c)
 | Annual average (a) (b) |  |  |  |  | 2013 | 2014
Country | 2010 | 2011 | 2012 | 2013 |  | Dec | Jan | Feb | Mar
Australia | 5 | 4.725 | 3.03 | 2.675 |  | 2.675 | 2.655 | 2.675 | 2.675
Canada | 0.202 | 0.998 | 0.8260000000000001 | 0.9390000000000001 |  | 0.917 | 0.889 | 0.879 | 0.85
China | 1.91 | 4.62 | 5.97 | 4.71 |  | 5.9 | 5.88 | 5.43 | 5.13
France | 0.7000000000000001 | 1.001 | 1.343 | 0.187 |  | 0.27536 | 0.29183 | 0.2881 | 0.30495
Germany | 0.7000000000000001 | 1.001 | 1.343 | 0.187 |  | 0.27536 | 0.29183 | 0.2881 | 0.30495
Italy | 0.7000000000000001 | 1.001 | 1.343 | 0.185 |  | 0.2754 | 0.2918 | 0.2881 | 0.305
Japan | 0.4636400000000001 | 0.34 | 0.33643 | 0.30917 |  | 0.22091 | 0.22087 | 0.21691 | 0.21182
Korea | 2.86 | 2.8 | 3.56 | 2.89 |  | 2.651 | 2.653 | 2.65 | 2.65
Malaysia | 2.13 | 2.96 | 3.19 | 3.16 |  | 3.17 | 3.24 | 3.24 | 3.3
New Zealand | 3.375 | 2.765 | 2.84 | 2.825 |  | 2.825 | 2.925 | 3.045 | 3.175
Philippines | 3.887 | 0.775 | 1.556 | 0.198 |  | 0.001 | 0.603 | 1.458 | 1
Singapore | 0.3750000000000001 | 0.2813000000000001 | 0.25 | 0.25 |  | 0.25 | 0.30435 | 0.3125 | 0.3125
Thailand | 1.3512 | 2.15 | 3.2608 | 2.8661 |  | 2.3904 | 2.3936 | 2.3898 | 2.2516
United Kingdom | 0.65 | 0.8 | 1.05 | 0.53 |  | 0.5 | 0.5 | 0.5 | 0.5
United States | 0.34 | 0.34 | 0.43 | 0.27 |  | 0.24 | 0.24 | 0.24 | 0.23
(a) 3 month interbank  rate
(b) Years shown are calendar years.
(c)  Monthly average
Source: Datastream
 |  |  |  |  |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  |  |  |  |  | Early May 2014
Spreadsheet: 105197d1302627299-transfer-data-from-master-sheet-to-different-sheets-sample
Sheet: Master Sheet

[NAME] | 2011-04-01 00:00:00 | 80 | Tech Test
[NAME] | 2011-04-07 00:00:00 | 85 | Tech Test
[NAME] | 2011-04-14 00:00:00 | 90 | Tech Test
[NAME] | 2011-04-28 00:00:00 | 95 | Tech Test
[NAME] | 2011-04-01 00:00:00 | 80 | Science Test
[NAME] | 2011-04-07 00:00:00 | 85 | Science Test
[NAME] | 2011-04-14 00:00:00 | 90 | Science Test
[NAME] | 2011-04-01 00:00:00 | 95 | Tech Test
[NAME] | 2011-04-07 00:00:00 | 80 | Tech Test
[NAME] | 2011-04-01 00:00:00 | 85 | Science Test
[NAME] | 2011-04-07 00:00:00 | 90 | Science Test
[NAME] | 2011-04-14 00:00:00 | 95 | Science Test
[NAME] | 2011-04-28 00:00:00 | 80 | Science Test
[NAME] | 2011-04-30 00:00:00 | 85 | Science Test
Cooper | 2011-04-01 00:00:00 | 77 | History Test
Cooper | 2011-04-07 00:00:00 | 80 | History Test
Cooper | 2011-04-14 00:00:00 | 99 | History Test
Janice | 2011-04-01 00:00:00 | 95 | History Test
Janice | 2011-04-07 00:00:00 | 80 | History Test
Janice | 2011-04-14 00:00:00 | 85 | History Test
Janice | 2011-04-28 00:00:00 | 77 | History Test
Spreadsheet: 233163d1367648901-excel-advanced-filtering-on-multiple-sheets-kjdeutinlab30-1-
Sheet: Population

2009 Pop | STATE | CAPITAL
>10,000,000 | Florida | Florida
 |  |  |  | STATE | AREA | 2009 POP | TREE | [NAME] | BIRD | CAPITAL
 |  |  |  | Alaska | 663267 | 698473 | [NAME] | Forget-me-not | [NAME] | Juneau
 |  |  |  | California | 163695 | 36961664 | California Redwood | Golden poppy | California Valley Quail | Sacramento
 |  |  |  | Delaware | 2489 | 885122 | American Holly | Peach blossom | Blue Hen Chicken | Dover
 |  |  |  | Florida | 65755 | 18537969 | Cabbage Palmetto | Orange blossom | Mockingbird | Florida
 |  |  |  | Illinois | 57914 | 12910409 | [NAME] | Native violet | Cardinal | Springfield
 |  |  |  | Montana | 147042 | 974989 | Ponderosa Pine | Bitterroot | Western Meadowlark | Helena
 |  |  |  | New York | 54556 | 19541453 | Sugar Maple | Rose | Bluebird | Albany
 |  |  |  | North Dakota | 70700 | 646844 | American Elm | Wild prairie rose | Western Meadowlark | Bismarck
 |  |  |  | Ohio | 44825 | 11542645 | Ohio [NAME] | Scarlet carnation | Cardinal | Columbus
 |  |  |  | Pennsylvania | 46056 | 12604767 | Eastern Hemlock | Mountain laurel | [NAME] | Harrisburg
 |  |  |  | South Dakota | 77353 | 812383 | White Spruce | Pasque flower | Ring-necked Pheasant | [NAME]
 |  |  |  | Texas | 268580 | 24782302 | Pecan | Texas Blue Bonnet | Mockingbird | [NAME]
 |  |  |  | Vermont | 9615 | 621760 | Sugar Maple | Red clover | Hermit Thrush | Montpelier
 |  |  |  | Wyoming | 97813 | 544270 | Cottonwood | Indian paint brush | Western Meadowlark | [NAME]
Spreadsheet: 131287d1322843348-returning-month-when-a-customer-started-purchasing-returning-month-when-a-customer-started-purchasing
Sheet: Sample2

Month/Year | First Purchase | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00
Company A |  | 100 | 200 | 300 | 400
Company B |  | 0 | 0 | 0 | 250
 |  | AGGREGATE with just ENTER
Spreadsheet: 0800b23e-0b13-4cb9-9f8f-f4b208a5cfbf
Sheet: Age

Tract Number | Total Pop | Under 5 | 5 to 17 | 18 to 24 | 25 to 34 | 35 to 44 | 45 to 54 | 55 to 64 | 65 to 74 | 75 to 84 | 85+ | Under 18 | 65+
3521.01 | 1654 | 68 | 55 | 363 | 688 | 238 | 109 | 90 | 32 | 9 | 2 | 123 | 43
3521.02 | 2277 | 87 | 84 | 289 | 639 | 300 | 266 | 271 | 166 | 125 | 50 | 171 | 341
3522 | 1849 | 67 | 118 | 167 | 477 | 225 | 198 | 215 | 175 | 150 | 57 | 185 | 382
3523 | 3450 | 213 | 180 | 423 | 1346 | 562 | 320 | 213 | 101 | 61 | 31 | 393 | 193
3524 | 2126 | 178 | 386 | 289 | 432 | 292 | 242 | 177 | 84 | 35 | 11 | 564 | 130
3525 | 2894 | 119 | 293 | 432 | 975 | 388 | 286 | 237 | 102 | 43 | 19 | 412 | 164
3526 | 2378 | 107 | 219 | 345 | 793 | 296 | 224 | 184 | 104 | 78 | 28 | 326 | 210
3527 | 2057 | 93 | 241 | 265 | 515 | 285 | 241 | 204 | 107 | 80 | 26 | 334 | 213
3528 | 2115 | 93 | 170 | 290 | 685 | 292 | 224 | 197 | 99 | 46 | 19 | 263 | 164
3529 | 2646 | 127 | 150 | 210 | 899 | 420 | 267 | 339 | 150 | 61 | 23 | 277 | 234
3530 | 3584 | 164 | 221 | 366 | 1249 | 463 | 324 | 339 | 268 | 137 | 53 | 385 | 458
3531.01 | 2460 | 83 | 139 | 782 | 854 | 252 | 152 | 120 | 51 | 19 | 8 | 222 | 78
3531.02 | 5040 | 50 | 59 | 3494 | 1213 | 118 | 25 | 39 | 21 | 12 | 9 | 109 | 42
3532 | 4897 | 186 | 252 | 1141 | 1730 | 573 | 342 | 374 | 183 | 95 | 21 | 438 | 299
3533 | 3471 | 168 | 296 | 317 | 1062 | 525 | 409 | 398 | 181 | 85 | 30 | 464 | 296
3534 | 2848 | 199 | 321 | 327 | 799 | 428 | 308 | 261 | 129 | 51 | 25 | 520 | 205
3535 | 2602 | 127 | 205 | 296 | 831 | 314 | 265 | 284 | 164 | 81 | 35 | 332 | 280
3536 | 4551 | 129 | 220 | 1563 | 1302 | 416 | 295 | 343 | 190 | 71 | 22 | 349 | 283
3537 | 5365 | 107 | 137 | 2445 | 1421 | 364 | 279 | 249 | 175 | 105 | 83 | 244 | 363
3538 | 4702 | 140 | 144 | 538 | 2018 | 591 | 408 | 424 | 243 | 137 | 59 | 284 | 439
3539 | 7090 | 179 | 139 | 3688 | 2199 | 497 | 145 | 99 | 89 | 36 | 19 | 318 | 144
3540 | 4366 | 98 | 151 | 1352 | 1156 | 427 | 339 | 392 | 275 | 133 | 43 | 249 | 451
3541 | 2907 | 77 | 114 | 438 | 768 | 271 | 221 | 366 | 344 | 237 | 71 | 191 | 652
3542 | 2907 | 153 | 412 | 122 | 314 | 321 | 392 | 518 | 389 | 189 | 97 | 565 | 675
3543 | 3346 | 215 | 415 | 223 | 620 | 547 | 395 | 377 | 215 | 189 | 150 | 630 | 554
3544 | 1647 | 100 | 200 | 92 | 310 | 238 | 238 | 244 | 143 | 56 | 26 | 300 | 225
3545 | 2236 | 94 | 138 | 188 | 625 | 297 | 239 | 301 | 222 | 98 | 34 | 232 | 354
3546 | 4538 | 330 | 579 | 277 | 978 | 658 | 558 | 494 | 281 | 200 | 183 | 909 | 664
3547 | 2509 | 116 | 208 | 248 | 733 | 353 | 277 | 265 | 165 | 107 | 37 | 324 | 309
3548 | 1903 | 81 | 143 | 172 | 573 | 266 | 227 | 244 | 106 | 66 | 25 | 224 | 197
3549 | 6058 | 461 | 844 | 540 | 1260 | 945 | 818 | 656 | 331 | 153 | 50 | 1305 | 534
3550 | 2689 | 117 | 269 | 173 | 702 | 381 | 305 | 330 | 211 | 142 | 59 | 386 | 412
Citywide | 105162 | 4526 | 7502 | 21855 | 30166 | 12543 | 9338 | 9244 | 5496 | 3087 | 1405 | 12028 | 9988
Spreadsheet: 39823d1238088585-looking-up-a-range-of-cells-with-criterias-attached-forum-example
Sheet: Handlers

Agent | Band | Rate | Value
[NAME] | IRL NB | 0.052 | 0
[NAME] | IRL NB | 0.2 | 1 |  |  | Band & Rate can vary from day to day.
[NAME] | All-In-One | 0.25 | 1
[NAME] | Farm | 0.32 | 0.31
Zak | PEN | 0.12 | 0