tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: matthew_lenhart__26266__West Daily Prices1119-01
Sheet: Off Peak Detail

Report Date
Off-Peak Prices
 |  |  | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-01 00:00:00 |  |  |  |  | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00 | 2002-10-01 00:00:00 | 2002-11-01 00:00:00 | 2002-12-01 00:00:00 | 2003-01-01 00:00:00 | 2003-02-01 00:00:00 | 2003-03-01 00:00:00 | 2003-04-01 00:00:00 | 2003-05-01 00:00:00 | 2003-06-01 00:00:00 | 2003-07-01 00:00:00 | 2003-08-01 00:00:00 | 2003-09-01 00:00:00 | 2003-10-01 00:00:00 | 2003-11-01 00:00:00 | 2003-12-01 00:00:00 | 2004-01-01 00:00:00 | 2004-02-01 00:00:00 | 2004-03-01 00:00:00 | 2004-04-01 00:00:00 | 2004-05-01 00:00:00 | 2004-06-01 00:00:00 | 2004-07-01 00:00:00 | 2004-08-01 00:00:00 | 2004-09-01 00:00:00 | 2004-10-01 00:00:00 | 2004-11-01 00:00:00 | 2004-12-01 00:00:00 | 2005-01-01 00:00:00 | 2005-02-01 00:00:00 | 2005-03-01 00:00:00 | 2005-04-01 00:00:00 | 2005-05-01 00:00:00 | 2005-06-01 00:00:00 | 2005-07-01 00:00:00 | 2005-08-01 00:00:00 | 2005-09-01 00:00:00 | 2005-10-01 00:00:00 | 2005-11-01 00:00:00 | 2005-12-01 00:00:00 | 2006-01-01 00:00:00 | 2006-02-01 00:00:00 | 2006-03-01 00:00:00 | 2006-04-01 00:00:00 | 2006-05-01 00:00:00 | 2006-06-01 00:00:00 | 2006-07-01 00:00:00 | 2006-08-01 00:00:00 | 2006-09-01 00:00:00 | 2006-10-01 00:00:00 | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | 2007-07-01 00:00:00 | 2007-08-01 00:00:00 | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
5x8 [NAME] |  | Nov-Dec 01 |  |  | 2001 Total |  |  |  |  |  |  |  |  |  |  |  |  | 2002 | 2003 | 2004-2010 | > 2011 | Total Off-Peak
MID-COLUMBIA | TenMinSpin
COB | OpRes
NP15
ZP26
SP15 | NEPOOLU
Palo Verde | NEPOOLU
Mead | NEPOOL
ALBERTA
ALBERTA | NYPP
Sat 2x16
MID-COLUMBIA | TenMinSpin
COB | OpRes
NP15
ZP26
SP15 | NEPOOLU
Palo Verde | NEPOOLU
Mead | NEPOOL
ALBERTA
ALBERTA | NYPP
Sun 2x16
MID-COLUMBIA | TenMinSpin
COB | OpRes
NP15
ZP26
SP15 | NEPOOLU
Palo Verde | NEPOOLU
Mead | 53
ALBERTA
ALBERTA | 53.5
Spreadsheet: 24238d1214400848-problem-need-to-eliminate-redundant-steps-d-backup
Sheet: Day1

 |  |  |  | Net Costs Available
 |  |  | Date: | 2008-06-07 00:00:00
Town 1 | 2ULS | 1ULS | Red500RPM | Lead Free | [NAME] | Silver | Ethanol | 89 Gasahol
P1 | 0.99 | 1.98 | 2.97 | 3.96 | 4.95 | 5.94 | 7 | 7.92
P2 | 2.4255 | 0 | 0 | 0 | 0 | 0 | 0 | 0
P3 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
P4 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
P5 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
P6 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
P7 | 1 | 0 | 0 | 0 | 0 | 0 | 0
P8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Town 2
P1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
P2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Town 3
P1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
P2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
P3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
P4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Town 4 | 2ULS | 1ULS | Red500RPM | Lead Free | [NAME] | Silver | Ethanol | 89 Gasahol
P1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
P2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
P3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
P4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
P5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
P6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Town 5 | 0 | 0 |  | 0 | 0 | 0 |  | 0
P1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Town 6 | 0 | 0 |  | 0 | 0 | 0 |  | 0
P1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Town 7 | 0 | 0 |  | 0 | 0 | 0 |  | 0
P1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 736918d1623944128-using-another-cell-value-to-create-and-display-a-named-range-in-another-set-of-cells-example-file
Sheet: Data

 | Function to allow dynamic named range
 | Heading but also named range ref | Selection_1 | Selection_2 | Selection_3 | Selection_4
 | Component lists | Part 1 | Part 6 | Part 14 | Part 21
 |  | Part 2 | Part 7 | Part 15 | Part 22
 |  | Part 3 | Part 8 | Part 16 | Part 23
 |  | Part 4 | Part 9 | Part 17 | Part 24
 |  | Part 5 | Part 10 | Part 18
 |  |  | Part 11 | Part 19
 |  |  | Part 12 | Part 20
 |  |  | Part 13
Spreadsheet: 802309d1666787109-xlookup-with-multiple-search-criteria-and-multiple-return-values-book2
Sheet: Sheet1

 |  |  | Material | Qty |  |  |  |  |  |  |  | Material | Qty | Material | Qty
 |  |  | Prod1 | 10 |  |  |  |  |  |  |  | Prod1 | 10 | Prod2 | 22
 |  |  | Prod2 | 22 |  |  |  |  |  |  |  | Prod3 | 30 | Prod4 | 40
 |  |  | Prod3 | 30
 |  |  | Prod4 | 40
Spreadsheet: 732965d1621341134-automatic-count-of-content-in-merged-cells-meeting_sheet
Sheet: Analysis

 |  | Type of Meetings
 | Date of Request | Meeting A | Meeting B | Meeting C | Meeting D | Meeting E | Meeting F | Meeting G | Meeting H | Meeting I | Meeting J | Meeting K | Meeting L | Meeting M | Meetings Not Accommodated | Number of Cancellations
Monday | 2021-05-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Tuesday | 2021-05-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
Wednesday | 2021-05-12 00:00:00
Thursday | 2021-05-13 00:00:00
Friday | 2021-05-14 00:00:00
Monday | 2021-05-17 00:00:00
Tuesday | 2021-05-18 00:00:00
Wednesday | 2021-05-19 00:00:00
Thursday | 2021-05-20 00:00:00
Friday | 2021-05-21 00:00:00
Monday | 2021-05-24 00:00:00
Tuesday | 2021-05-25 00:00:00
Wednesday | 2021-05-26 00:00:00
Thursday | 2021-05-27 00:00:00
Friday | 2021-05-28 00:00:00
Monday | 2021-05-31 00:00:00
Tuesday | 2021-06-01 00:00:00
Wednesday | 2021-06-02 00:00:00
Thursday | 2021-06-03 00:00:00
Friday | 2021-06-04 00:00:00
Monday | 2021-06-07 00:00:00
Tuesday | 2021-06-08 00:00:00
Wednesday | 2021-06-09 00:00:00
Thursday | 2021-06-10 00:00:00
Friday | 2021-06-11 00:00:00
Monday | 2021-06-14 00:00:00
Tuesday | 2021-06-15 00:00:00
Wednesday | 2021-06-16 00:00:00
Thursday | 2021-06-17 00:00:00
Friday | 2021-06-18 00:00:00
Monday | 2021-06-21 00:00:00
Tuesday | 2021-06-22 00:00:00
Wednesday | 2021-06-23 00:00:00
Thursday | 2021-06-24 00:00:00
Friday | 2021-06-25 00:00:00
Monday | 2021-06-28 00:00:00
Tuesday | 2021-06-29 00:00:00
Wednesday | 2021-06-30 00:00:00
Thursday | 2021-07-01 00:00:00
Friday | 2021-07-02 00:00:00
Monday | 2021-07-05 00:00:00
Tuesday | 2021-07-06 00:00:00
Wednesday | 2021-07-07 00:00:00
Thursday | 2021-07-08 00:00:00
Friday | 2021-07-09 00:00:00
Monday | 2021-07-12 00:00:00
Tuesday | 2021-07-13 00:00:00
Wednesday | 2021-07-14 00:00:00
Thursday | 2021-07-15 00:00:00
Friday | 2021-07-16 00:00:00
Monday | 2021-07-19 00:00:00
Tuesday | 2021-07-20 00:00:00
Wednesday | 2021-07-21 00:00:00
Thursday | 2021-07-22 00:00:00
Friday | 2021-07-23 00:00:00
Monday | 2021-07-26 00:00:00
Tuesday | 2021-07-27 00:00:00
Wednesday | 2021-07-28 00:00:00
Thursday | 2021-07-29 00:00:00
Friday | 2021-07-30 00:00:00
Monday | 2021-08-02 00:00:00
Tuesday | 2021-08-03 00:00:00
Wednesday | 2021-08-04 00:00:00
Thursday | 2021-08-05 00:00:00
Friday | 2021-08-06 00:00:00
Spreadsheet: 1e18222f-97e3-4a7e-affd-d5d6c6e53c6f
Sheet: kota tgl

HASIL PENILAIAN PLPG TAHAP 1-4 TAHUN 2011
NO | NOMOR PESERTA | NAMA PESERTA | ASAL SEKOLAH | KAB/KOTA | STATUS
1 | 11036502010020 | HIDAYAH | TK N PEMBINA | [NAME] | LULUS
2 | 11036502010002 | ELLY DESWATI | TK ELKANA | [NAME] | LULUS
3 | 11036502010021 | [NAME] | TK AISYIYAH IV | [NAME] | LULUS
4 | 11036502010003 | DUROTUN NAELY | TK IHSANIYAH 1 | [NAME] | LULUS
5 | 11036502010026 | ENDAH WAHYUNINGSIH | TK AISYIYAH BUSTANUL ATHFAL X | [NAME] | MENGULANG UJIAN TULIS
6 | 11036502010023 | AMETA | TK AL HIDAYAH II | [NAME] | MENGULANG UJIAN TULIS
7 | 11036502010007 | CHOTILAH | TK PUI CAB TEGAL | [NAME] | MENGULANG UJIAN TULIS
8 | 11036502010011 | DARTINI | TK KARTIKA IV 28 | [NAME] | MENGULANG UJIAN TULIS
9 | 11036502010017 | ASIH PRATIWI | TK AISYIYAH V | [NAME] | MENGULANG UJIAN TULIS
10 | 11036502010029 | ENDANG CAHYANINGSIH | TK IHSANIYAH 2 | [NAME] | MENGULANG UJIAN TULIS
Spreadsheet: chris_dorland__1603__MIRANT - Nov 30 2001 Termination
Sheet: MIDS

1
 | AECOUS | CGPR-AECO/BASIS | NGMR-AECO/C | NYMEX | STATION-2/C$ | IF-NTWST/CANB-I | NGMR-AECO/IDX | FX | CND BA RATE | US BA RATE
2002-01-01 00:00:00 |  |  |  |  |  | 0.03 | 0
2002-02-01 00:00:00 |  |  |  |  |  | 0.03 | 0
2002-03-01 00:00:00 |  |  |  |  |  | 0.03 | 0
2002-04-01 00:00:00 |  |  |  |  |  |  | 0
2002-05-01 00:00:00 |  |  |  |  |  |  | 0
2002-06-01 00:00:00 |  |  |  |  |  |  | 0
2002-07-01 00:00:00 |  |  |  |  |  |  | 0
2002-08-01 00:00:00 |  |  |  |  |  |  | 0
2002-09-01 00:00:00 |  |  |  |  |  |  | 0
2002-10-01 00:00:00 |  |  |  |  |  |  | 0
2002-11-01 00:00:00 |  |  |  |  |  |  | 0
2002-12-01 00:00:00 |  |  |  |  |  |  | 0
2003-01-01 00:00:00 |  |  |  |  |  |  | 0
2003-02-01 00:00:00 |  |  |  |  |  |  | 0
2003-03-01 00:00:00 |  |  |  |  |  |  | 0
Spreadsheet: 871785d1718201373-march-fishing-xls-hpe-needed-sac-league
Sheet: 1

SAC
Name | lbs | oz | Oz (total) | Points
 | 57 | 3 |  | 8
 | 48 | 5 | 772.9999999999999 | 5
 | 57 | 3 | 915 | 8
 | 87 |  | 1392 | 10
 | 27 | 11 | 443.0000000000001
 | 35 | 14 | 574
 | 75 | 6 | 1206 | 9
 | 43 | 7 | 695 | 2
 | 51 | 11 | 827 | 6
 | 0 | 0
 | 43 | 9 | 697 | 3
 | 37 | 5 | 597
 | 44 |  | 704 | 4
 | 0 | 0
 | DNW |  | DNW | 1
Spreadsheet: 0a805602-a27a-4620-9383-c5440c47562a
Sheet: 8a

Product1 | Cleared2 | Uncleared | TOTAL
Basis | 33 | 98 | 131
Cap/Floor | 0 | 89 | 89
Debt Option | 0 | 0 | 0
Exotic | 0 | 0 | 0
Fixed-Fixed | 0 | 19 | 19
Fixed-Float | 12316 | 1930 | 14246
FRA | 1314 | 171 | 1485
Inflation | 0 | 124 | 124
OIS | 93 | 139 | 232
Swaption | 0 | 808 | 808
TOTAL
Spreadsheet: 54659d1254716704-import-data-range-based-on-specific-criteria-wrk-shedule-daily-tab-
Sheet: TEMPLATE

MCAW / MCSH / MMSH / T- 12 WORK SCHEDULE  WEEK |  |  |  |  |  |  |  | 47 | WEEK TOTAL HRS = |  |  |  | 0
WO # | TASK # | UNIT # | USI # | EQUIP # | WORK ORDER DESC | HOLDS | STATUS | TARGET START | HOURS | PRIORITY | WO TYPE | EARLY DATE | LATE  DATE | ITEM # | CREW
2009-11-16 00:00:00
MCAW | Mon TOTAL HRS = |  | 0 |  |  |  | MCSH | MON TOTAL HOURS = |  | 0 |  | MMSH | MON TOTAL HOURS = |  |  | NOTES
MCAW | Mon Resource % = |  | 0 |  |  |  | MCSH | MON RESOURCE % = |  | 0 |  | MMSH | MON RESOURCE % = |  | 0
Spreadsheet: 747948d1631798871-removed-duplicate-values-from-2-lists-to-give-only-the-unique-values-in-list-3-example-1
Sheet: Example

Header1 | Header2 |  | Header3 | Header4 |  | Header3 | Header4
A | 1 |  | A | 1 |  | B | 2 |  | Only want columns G and H to pull through values that are not duplicated between Columns A and B and Columns D and E so the expected result would be pulling what I have typed into G and H.
B | 2 |  | C | 3 |  | D | 4
C | 3 |  | E | 5 |  | F | 6
D | 4 |  | G | 7 |  | H | 8
E | 5 |  | I | 9 |  | J | 10
F | 6 |  | K | 11 |  | L | 12
G | 7 |  | M | 13 |  | N | 14
H | 8 |  | O | 15 |  | P | 16
I | 9 |  | Q | 17 |  | R | 18
J | 10 |  | S | 19 |  | T | 20
K | 11 |  | U | 21 |  | V | 22
L | 12 |  | W | 23 |  | X | 24
M | 13 |  | Y | 25 |  | Z | 26
N | 14
O | 15
P | 16
Q | 17
R | 18
S | 19
T | 20
U | 21
V | 22
W | 23
X | 24
Y | 25
Z | 26
Spreadsheet: 66007d1266618778-look-up-dependent-dependant
Sheet: Sheet1

 |  |  |  | day
quoted time |  |  | say hello
type |  |  | cook tea
 |  |  | have a bath
 |  |  | say good bye
s/o
s/f
1-3 weeks | 2 |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8
2-4 weeks | 3 |  |  | s/o | say hello | day 1 | day 1 | day 1 | day 1 | day 1 | day 1 | day 1
3-5 weeks | 4 |  |  |  | cook tea | day 3 | day 4 | day 5 | day 6 | day 7 | day 8 | day 9
4-6 weeks | 5 |  |  |  | have a bath | day 8 | day 9 | day 10 | day 11 | day 12 | day 13 | day 14
5-7 weeks | 6 |  |  |  | say good bye | day14 | day15 | day16 | day17 | [NAME] | [NAME] | day20
6-8 weeks | 7
7-9 weeks | 8 |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  |  | s/f | say hello | day  2 | day  2 | day  2 | day  2 | day  2 | day  2 | day  2
 |  |  |  |  | cook tea | day 4 | day 5 | day 6 | day 7 | day 8 | day 9 | day 10
 |  |  |  |  | have a bath | day 6 | day 7 | day 8 | day 9 | day 10 | day 11 | day 12
 |  |  |  |  | say good bye | day 9 | day 10 | day 11 | day 12 | day 13 | day 14 | day 15
Spreadsheet: 867542d1714390177-need-attendace-sheet-for-saleman-visited-diffrent-regions-with-different-items-book4-12-aligw
Sheet: Sheet1

 |  | Salesman | Items | Region |  |  |  | REG-1 | [NAME] | REG-3 | REG-4 | REG-5 | [NAME] | REG-7 | REG-8 | REG-9 | REG-10 | REG-11
 |  | Salesman101 | Item-1 | REG-1 |  | Salesman101 | Item-1
 |  | Salesman101 | Item-2 | REG-3 |  | Salesman101 | Item-2 |  |  | P
 |  | Salesman101 | Item-3 | REG-3 |  | Salesman101 | Item-3 |  |  | P
 |  | Salesman101 | Item-4 | [NAME] |  | Salesman101 | Item-4 |  |  |  |  |  | P
 |  | Salesman111 | Item-1 | REG-3 |  | Salesman111 | Item-1 |  |  | P
 |  | Salesman111 | Item-2 | REG-1 |  | Salesman111 | Item-2 | P
 |  | Salesman111 | Item-3 | REG-3 |  | Salesman111 | Item-3 |  |  | P
 |  | Salesman111 | Item-4 | REG-3 |  | Salesman111 | Item-4 |  |  | P
 |  | Salesman111 | Item-5 | [NAME] |  | Salesman111 | Item-5 |  |  |  |  |  | P
 |  | Salesman111 | Item-6 | REG-3 |  | Salesman111 | Item-6 |  |  | P
 |  | Salesman111 | Item-7 | REG-5 |  | Salesman111 | Item-7 |  |  |  |  | P
Spreadsheet: 00b416c4-1b70-479f-8b4c-9229ecc1a3bb
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6427.0 Producer Price Indexes, Australia
 | Table 25. Output of the Administrative and support services industries, group and class index numbers
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Index Numbers ;  721 Employment services ; |  |  | Original | A3343924F | 2001-09-01 00:00:00 | 2012-12-01 00:00:00 | 46 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7211  Employment placement and recruitment services ; |  |  | Original | A2314247W | 1998-09-01 00:00:00 | 2012-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7212 Labour supply services ; |  |  | Original | A2314250K | 1998-09-01 00:00:00 | 2012-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  729 Other administrative services ; |  |  | Original | A3343926K | 2001-09-01 00:00:00 | 2012-12-01 00:00:00 | 46 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7292 Document preparation services ; |  |  | Original | A3343928R | 2001-09-01 00:00:00 | 2012-12-01 00:00:00 | 46 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7293 Credit reporting and debt collection services ; |  |  | Original | A3343930A | 2001-09-01 00:00:00 | 2012-12-01 00:00:00 | 46 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7294 Call centre operation ; |  |  | Original | A3343932F | 2001-09-01 00:00:00 | 2012-12-01 00:00:00 | 46 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7299 Other administrative services n.e.c. ; |  |  | Original | A3343934K | 2001-09-01 00:00:00 | 2012-12-01 00:00:00 | 46 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  731 Building cleaning, pest control and gardening services ; |  |  | Original | A3343936R | 2001-09-01 00:00:00 | 2012-12-01 00:00:00 | 46 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7311 Building and other industrial cleaning services ; |  |  | Original | A2314262V | 1998-09-01 00:00:00 | 2012-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7312 Building pest control services ; |  |  | Original | A2314259F | 1998-03-01 00:00:00 | 2012-12-01 00:00:00 | 60 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2013
Spreadsheet: 30266d1225724570-lookup-multiple-values-help-with-this-spreadsheet
Sheet: Sheet2

Identifier | NM Value | Size | type
25-007 | 86 | 1 | click
29-015 | 45 | 1 1/16 | click
31-016 | 20 | 9/16 | click
54-018 | 240 | 24mm | impulse
5-01-0506 | 12 |  | impulse
5-07-0606 | 7.5 | 12mm | impulse
28-062 | 108 | 1 1/4 | click
28-063 | 108 | 1 1/4 | click
31-063 | 58 | 7/8 | click
52-065 | 47 | 9/16 | impulse
2-27-0707 | 55 | 16mm | impulse
2-84-0807 | 25 | 16mm | impulse
2-87-0897 | 135 | 3/4 | impulse
2-90-0897 | 4.5 |  | impulse
5-03-1003 | 12
2-34-1006 | 47 | 9/16 | impulse
5-05-1006 | 10 | 9mm | impulse
5-06-1006 | 12 | 9mm | impulse
55-106 | 215 | 15/16 | impulse
Spreadsheet: 823281d1679872672-formula-needed-to-sum-multiple-cells-based-on-monthly-dates-sum-based-on-monthly-dates
Sheet: Sheet1

 |  |  |  |  | FORMULAS GO BELOW: F-J, 3-14 |  |  |  |  |  | TOTALS SHOULD CALCULATE TO THIS BELOW
 |  |  |  |  | DK | INSP | CONT | APPR | CLS |  | DK | INSP | CONT | APPR | CLS
 |  |  | Jan | 2023-01-01 00:00:00 |  |  |  |  |  |  | 1 | 1 | 1
 |  |  | Feb | 2023-02-01 00:00:00 |  |  |  |  |  |  | 3 | 3 | 2 | 2 | 1
 |  |  | Mar | 2023-03-01 00:00:00 |  |  |  |  |  |  | 1 | 1 | 1
 |  |  | Apr | 2023-04-01 00:00:00 |  |  |  |  |  |  | 1 | 1 | 1 | 1
 |  |  | May | 2023-05-01 00:00:00
 |  |  | Jun | 2023-06-01 00:00:00
 |  |  | July | 2023-07-01 00:00:00
 |  |  | Aug | 2023-08-01 00:00:00
 |  |  | Sep | 2023-09-01 00:00:00
 |  |  | Oct | 2023-10-01 00:00:00
 |  |  | Nov | 2023-11-01 00:00:00 |  |  |  |  |  |  | 2 | 1 | 1 | 1
 |  |  | Dec | 2023-12-01 00:00:00
 |  |  |  | DATE | DK | INSP | CONT | APPR | CLS
 |  |  |  | 2023-01-21 00:00:00 | 1 | 1 | 1
 |  |  |  | 2023-02-05 00:00:00 | 1 | 1 | 1 | 1
 |  |  |  | 2023-02-11 00:00:00 | 1 | 1 | 1 | 1 | 1
 |  |  |  | 2023-02-24 00:00:00 | 1 | 1
 |  |  |  | 2023-03-15 00:00:00 | 1 | 1 | 1
 |  |  |  | 2023-04-19 00:00:00 | 1 | 1 | 1 | 1
 |  |  |  | 2023-11-08 00:00:00 | 1 | 1 | 1 | 1
 |  |  |  | 2023-11-24 00:00:00 | 1
Spreadsheet: 761921d1641301996-creating-3-dependent-drop-down-lists-dv-named-range-example-dependent-drop-down-lists-aligw
Sheet: Sheet1

Dependent drop-down lists
Category | Big
Level | Well Manager
Type of work | 2
Category | Level
Big | Fat
B | D
 | E
 | Well Manager
Type of work
AD | BD | AC | BC | AE | BE | AF | BF
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
3 | 3 | 3 | 3 | 3 | 3
4 | 4 | 4 | 4 | 4 | 4
 | 5 | 5 | 5 | 5 | 5
 | 6 |  | 6
 | 7
 | 8
 | 9
Spreadsheet: 201966d1356251250-i-need-to-find-cell-reference-based-on-matching-data-ghozi-24122012-i-need-to-find-cell-reference-based-on-matching-data
Sheet: Sheet1

 |  | Serial 1 | Serial 2 | Serial 3 |  |  |  | OK7V0T
 |  |  |  |  |  |  |  | OK6TBP
 |  | box-4 | OK4KCU | OK4KI0 | OK4LLS
 |  | box-4 | OK60ZD | OK62AP | OK62QU
 |  | box-4 | OK6TA5 | OK6TBP | OK6TFW
 |  | box-4 | OK7V0T | OK7WC4 | OK7WL1
 |  | box-4 | FOC | OK4827 | OK483E
 |  | box-4 | OKIA9L | OKIAEC | OKIAI9
Spreadsheet: 116673d1311975613-selective-columns-abbey-hill
Sheet: Ls

Loom. S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hole | par | stroke index | strokes | points | penalty
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 48497292-d1c3-469e-bfa8-e36aa8d80c3c
Sheet: Sheet1

Season Schedule | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Date | Game Number | Visiting Team | Visiting Score | Home Team | Home Score | Game Time/Status | Venue
2012-04-20 | 1 | Hershey | 1 | W-B/Scranton | 3 | Final | [NAME] Arena at Casey Plaza Wilkes-Barre, PA
2012-04-21 | 2 | Hershey | 2 | W-B/Scranton | 7 | Final | [NAME] Arena at Casey Plaza Wilkes-Barre, PA
2012-04-25 | 3 | W-B/Scranton | 3 | Hershey | 4 | Final OT | Giant Center Hershey, PA
2012-04-27 | 4 | W-B/Scranton | 1 | Hershey | 4 | Final | Giant Center Hershey, PA
2012-04-28 | 5 | Hershey | 1 | W-B/Scranton | 2 | Final | [NAME] Arena at Casey Plaza Wilkes-Barre, PA
Spreadsheet: 830178d1684766685-price-list-to-update-values-based-on-a-drop-down-list-of-companies-price-list-test
Sheet: Sheet1

 |  | Price List
 | Select Company From Dropdown ---->
 | LIST 1 |  |  |  |  |  | LIST 2
 | Item1 |  |  |  | 12 |  | Item 1 |  |  |  | 68
 | Item 2 |  |  |  | 16 |  | Item 2 |  |  |  | 87
 | Item 3 |  |  |  | 10 |  | Item 3 |  |  |  | 67
 | Item 4 |  |  |  | 11 |  | Item 4 |  |  |  | 56
 | Item5 |  |  |  | 19 |  | Item 5 |  |  |  | 43
 | Item6 |  |  |  | 60 |  | Item 6 |  |  |  | 34
 | Item7 |  |  |  | 25 |  | Item 7 |  |  |  | 25
 | Item8 |  |  |  | 38 |  | Item 8 |  |  |  | 67
 | Item9 |  |  |  | 87 |  | Item 9 |  |  |  | 84
 | Item10 |  |  |  | 99 |  | Item 10 |  |  |  | 63
 | Item11 |  |  |  | 102 |  | Item 11 |  |  |  | 32
Spreadsheet: 691297d1597624263-count-cells-in-1-column-and-average-based-on-multiple-criteria-different-columns-sample321
Sheet: Sheet1

Material | Value | Year 1 | Year 2 | Year 3 | Year 4
Silk | 2 | 50 | 30 | 40 | 30
Velvet | 1 | 20 | 20 | 0 | 44
Cotton | 2 | 17 | 10 | 0 | 38
Wool | 3 | 23 | 30 | 43 | 50
Chiffon | 3 | 45 | 40 | 0 | 50
[NAME] | 1 | 0 | 5 | 54 | 30
Flannel | 1 | 0 | 9 | 60 | 89
Materials Count
Year 3 average for value 1
Spreadsheet: 91f3a186-13ba-4426-8f5e-dbd78ae7835d
Sheet: Sheet1

Reporting School: | Kankakee Valley | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Date: | 2009-12-22 00:00:00 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
Overall Record:
Conference Record:
School | 1st | 2nd | 3rd | 4th | OT | Final
Kankakee Valley | 6 | 15 | 13 | 16
Knox | 13 | 11 | 17 | 19
Add. Stats
 |  |  |  |  |  |  | Total | Offensive | Defensive | Total |  |  | Blocked
Player | 2PA | 2PM | 3PA | 3PM | FTA | FTM | Points | Rebounds | Rebounds | Rebounds | Assists | Steals | Shots | TO | Fouls | #GM
Zach Overby | 6 | 4 | 0 | 0 | 6 | 4 | 12 | 1 | 1 | 2 | 2 | 0 | 0 | 4 | 2 | 7
Brad Leegwater | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 7
[NAME] | 0 | 0 | 1 | 1 | 0 | 0 | 3 | 0 | 1 | 1 | 2 | 0 | 0 | 1 | 1 | 7
Zach DeFries | 5 | 2 | 1 | 0 | 0 | 0 | 4 | 0 | 3 | 3 | 1 | 2 | 0 | 3 | 5 | 7
[NAME] Dahm | 2 | 1 | 2 | 2 | 2 | 2 | 10 | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 4 | 7
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7
[NAME] | 6 | 1 | 1 | 0 | 0 | 0 | 2 | 0 | 4 | 4 | 2 | 1 | 0 | 2 | 4 | 7
[NAME] | 2 | 2 | 0 | 0 | 0 | 0 | 4 | 0 | 3 | 3 | 1 | 1 | 3 | 1 | 0 | 7
[NAME] | 9 | 5 | 0 | 0 | 2 | 1 | 11 | 3 | 1 | 4 | 2 | 1 | 1 | 2 | 5 | 7
[NAME] | 6 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 2 | 3 | 1 | 1 | 0 | 1 | 2 | 7
[NAME] | 1 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 7
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0