tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 69457d1269977017-link-2-workbooks-together-and-update-data-ericka
Sheet: Totals

Date |  | Category 1 | Category 2 | Category 3 | Category 4 | Category 5 | Category 6 | Category 7 | Category 8 | Category 9 | Category 10 | Category 11 | Category 12
1 |  | 5 |  | 4 |  | 4 | 4 | 400 | 22 | 2.2 | 10 | 5 | 80 | 0
2 |  |  |  |  |  |  |  |  | 5 | 1 | 5 |  | 0
3 |  | 5 |  |  |  |  |  |  |  | 0 |  |  | 0
4 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
5 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
6 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
7 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
8 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
9 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
10 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
11 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
12 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
13 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
14 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
15 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
16 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
17 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
18 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
19 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
20 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
21 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
22 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
23 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
24 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
25 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
26 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
27 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
28 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
29 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
30 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
31 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Totals |  | 10 | 0 | 4 | 0 | 4 | 4 | 400 | 27 | 3.2 | 15 | 5 | 80
 |  | 10 | 0 | 4 | 0 | 4 | 4 | 400 | 27 | 3.2 | 15 | 5 | 80
Spreadsheet: 108069d1305163053-using-dropdown-to-copy-rows-of-data-from-other-sheets-example-skills-matrix
Sheet: EA Skills

Environmental Analyst | EA I SKILLS | Ability to mash potatoes | Ability to walk and chew gum at the same time | Ability to sit in the same room as your mother-in-law for more than an hour | Ability to change a diaper | Ability to change a lightbulb | Able to drive a car blindfolded | Able to fix my Excel problems | Able to leap tall buildings in a single bound | Ability to get your work done on time | Ability to make me laugh
EA 1
EA 2
EA 3
EA 4
EA 5
EA 6
EA 7
EA 8
EA 9
EA 10
Spreadsheet: 706126d1606488978-results-from-multiple-cells-within-a-column-and-corresponding-row-and-column-exampleexcelissue
Sheet: Sheet2

 | 2020-10-23 00:00:00 | 2020-10-24 00:00:00 | 2020-10-25 00:00:00 | 2020-10-31 00:00:00 | 2020-11-01 00:00:00 | 2020-11-02 00:00:00 |  |  | Subject | Start Date | Start Time
00:30:00
01:00:00
01:30:00
02:00:00
03:00:00
04:00:00
05:00:00
06:00:00
07:00:00
08:00:00
08:30:00
09:00:00
09:30:00
10:00:00
10:30:00
11:00:00
11:30:00
12:00:00
12:30:00 |  |  |  |  |  |  |  |  |  | Information needed to be presented in this format
13:00:00 |  |  | (L2) Mumbai | (L4) Georgetown | (L2) Mexico City |  |  |  |  | This will need to be continually updated, so it needs to be dynamic.
13:01:00
13:30:00
14:00:00 |  |  |  | (L1) New York
14:30:00
15:00:00 | (L2) Rome
15:30:00
16:00:00 |  | (L2) Mexico City | (L3) Cairo | (L2) Mumbai | (L3) Sydney
16:30:00
17:00:00 | (L1) Edinburgh |  |  |  |  | (L3) Buenos Aires
17:01:00
17:59:00 |  |  |  |  |  |  |  |  | Information Presented in this Format
18:00:00
18:30:00
19:00:00 |  | (L2) [NAME] |  | (L2) Paris
19:01:00 | (P) Quito
19:30:00
20:00:00
20:15:00
20:30:00
21:00:00 |  |  |  | (L4) Milan
21:30:00
22:00:00
22:30:00
23:00:00 |  | (L1) New York | (L2) Buffalo | (L1) Los Angeles | (L2) Mumbai
23:30:00 |  |  |  |  |  | (L3) Taipei
Spreadsheet: 789736d1659339548-formula-to-populate-all-the-date-from-date-range-list-of-date-range-365-aligw
Sheet: Sheet1

 | Start | End |  | List | AliGW 365 | AliGW 2019
 | 2022-05-01 00:00:00 | 2022-05-11 00:00:00 |  | 2022-05-01 00:00:00
 |  |  |  | 2022-05-02 00:00:00 | 2022-05-02 00:00:00
 |  |  |  | 2022-05-03 00:00:00 | 2022-05-03 00:00:00
 |  |  |  | 2022-05-04 00:00:00 | 2022-05-04 00:00:00
 |  |  |  | 2022-05-05 00:00:00 | 2022-05-05 00:00:00
 |  |  |  | 2022-05-06 00:00:00 | 2022-05-06 00:00:00
 |  |  |  | 2022-05-07 00:00:00 | 2022-05-07 00:00:00
 |  |  |  | 2022-05-08 00:00:00 | 2022-05-08 00:00:00
 |  |  |  | 2022-05-09 00:00:00 | 2022-05-09 00:00:00
 |  |  |  | 2022-05-10 00:00:00 | 2022-05-10 00:00:00
 |  |  |  | 2022-05-11 00:00:00 | 2022-05-11 00:00:00
Spreadsheet: 54323d1254323655-calculated-item-in-pivot-tables-problem-book1
Sheet: DATA

SR1 | SR2 | KF | DATA
CEE | UKRAINE | SHIP | 100
FRANCE | FRANCE | SHIP | 100
CEE | SLOVENIA | SHIP | 100
CEE | HUNGARY | SHIP | 100
CEE | UKRAINE | FCST | 200
FRANCE | FRANCE | FCST | 200
CEE | SLOVENIA | FCST | 200
CEE | HUNGARY | FCST | 200
Spreadsheet: 0474fae9-f41c-4947-aaf0-e932ff198323
Sheet: Sheet1

CONTACT:
[NAME]
PA Department of Education
Division of Data Services
333 Market Street
Harrisburg, PA  17126-0333
[NAME]:  [EMAIL]
Phone:  (717) 787-2644
Fax:  (717) 787-3148
Text Telephone TTY:  (717) 783-8445
This workbook contains 2010-11 enrollments for all publicly funded schools in Pennsylvania as reported by school districts, area vocational-technical schools, charter schools, intermediate units, and state-operated educational facilities.  Local education agencies were asked to report those students who were enrolled and attending as of October 1, 2010.
County and Statewide Totals Notes:
Statewide and county totals include counts of students attending education classes on a full-time basis outside their parents' district of residence.  This data was obtained from the Bureau of Special Education (PENNDATA 2010).
Intermediate Unit and CTC Part-day enrollments are excluded from county and state totals.
Statewide and county totals are unique counts of students being educated by public Local Education Agencies.  LEA and School level reports may not sum to the County and Statewide totals.
DEFINITIONS:
[NAME] (EUG) - Full-time elementary nongraded programs including ungraded special education.
PRE-KINDERGARTEN (PK) - A program enrolling students who are up to two years younger than the entrance age for the local education agency's kindergarten program.  PKA represents a PreK Half Day morning (AM) program and PKP represents a PreK Half Day afternoon (PM) program.  PKF is used to indicate a PreK Full Day program.
K4 - The first year of a 2-year kindergarten program.  Students are generally 4 years old at the beginning of the school year.  K4A represents a K4 Half Day morning (AM) program and K4P represents a K4 Half Day afternoon (PM) program.  K4F is used to indicate a K4 Full Day program.
K5 - The second year of a 2-year kindergarten program or the single year of a traditional 1-year kindergarten program.  Students are generally 5 years old at the beginning of the school year.  K5A represents a K5 Half Day morning (AM) program and K5P represents a K5 Half Day afternoon (PM) program.  K5F is used to indicate a K5 Full Day program.
SECONDARY UNGRADED (SUG) - Full-time secondary nongraded programs including ungraded special education.
LEA Type codes are:
COMCTC - Comprehensive CTC
CS - Charter School
IU - Intermediate Unit
OCCCTC - Occupational CTC
SD - School District
SJCI - State Juvenile Correctional Institute
2011-04-20 00:00:00
Source: Pennsylvania Information Management System (PIMS)
Spreadsheet: 545436d1509466995-count-number-after-text-sample-abscence-calander
Sheet: John, Doe

Day | January | Februrary | March | April | May | June | July | August | September | October | November | December
1 | PTO: 5
2
3
4
5
6 | PTO: 5
7
8 | PTO: 5
9 | U.PTO: 10
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  | I'd like for it to be able to distinguish the values from PTO:# and  U.PTO: #
 | PTO of JAN | PTO of FEB | PTO of MAR | PTO of APR | PTO of MAY | PTO of JUNE | PTO of July | PTO of AUG | PTO of SEPT | PTO of OCT | PTO of NOV | PTO of DEC
Values go here
 | Unexcused PTO of JAN | Unexcused PTO of FEB | Unexcused PTO of MAR | Unexcused PTO of APR | Unexcused PTO of MAY | Unexcused PTO of JUNE | Unexcused PTO of JULY | Unexcused PTO of AUG | Unexcused PTO of SEPT | Unexcused PTO of OCT | Unexcused PTO of NOV | Unexcused PTO of DEC
Spreadsheet: 92539d1292097271-comparing-item-numbers-in-2-price-lists-book1
Sheet: Sheet1

Our item number | Suppliers item number | Price |  |  | Our item number | Suppliers item number | Price | Our item number
E100000 | TJE16700 | 23.8 |  |  | E100000 | TJE16700 | 23.2 | E100000
E100001 | TJE16701 | 23.8 |  |  | E100001 | TJE16701 | 23.2 | E100001
#N/A | TJE16702 | 32.1 |  |  | E100002 | TJE16711 | 23.2 | E100002
#N/A | TJE16710 | 23.8 |  |  | E100003 | TJE16715 | 23.2 | E100003
E100002 | TJE16711 | 23.8 |  |  | E100004 | TJE16716 | 23.2 | E100004
E100003 | TJE16715 | 23.8
E100004 | TJE16716 | 23.8
#N/A | TJE16735 | 23.8
#N/A | TJE16736 | 23.8
#N/A | TJE16760 | 23.8
Spreadsheet: 863876d1711271055-google-sheet-function-to-excel-2016-function-stock-portfolio-tracking-spreadsheet-11
Sheet: Transactions_OSV

Date | Type | Stock | Transacted Units | Transacted Price (per unit) | Fees | Stock [NAME] | Previous Units | Cumulative Units | Transacted Value | Previous Cost | Cost of Transaction | Avg Stock Price | Cumulative Cost | Gains/Losses from Sale | [NAME] %
2016-01-03 00:00:00 | Buy | ORCL |  | 25.87 | 7.95 | 1 |  |  |  |  |  |  |  |  |  |  | IF($C2="", "", IFERROR(INDEX(FILTER($I$1:$I$2, ($C1:$C$2<>"") * (ROW($C1:$C$2)=MAX((($C1:$C$2=$C2) * ROW($C1:$C$2))))), 1), 0))
2016-01-04 00:00:00 | Buy | BAC |  | 5.8 | 7.95 | 1
2016-01-05 00:00:00 | Buy | WDC |  | 30.98 | 7.95 | 1
2016-05-04 00:00:00 | Buy | GRVY |  | 1.45 | 7.95 | 1
2016-05-05 00:00:00 | Buy | UHAL |  | 14.98 | 7.95 | 1
2016-05-06 00:00:00 | Buy | MMM | 155 | 34 | 0 | 1
2016-05-07 00:00:00 | Buy | MSFT |  | 26.77 | 7.95 | 1
2016-07-11 00:00:00 | Buy | IBM |  | 30.65 | 7.95 | 1
2016-07-11 00:00:00 | Buy | GS |  | 95.36 | 7.95 | 1
2016-07-11 00:00:00 | Buy | YHOO |  | 45.63 | 7.95 | 1
2016-07-11 00:00:00 | Buy | NFLX |  | 74 | 7.95 | 1
2016-09-14 00:00:00 | Sell | YHOO | 667 | 13.75 | 7.95 | 1
2016-09-14 00:00:00 | Sell | IBM | 326 | 99 | 7.95 | 1
2016-09-14 00:00:00 | Buy | ORCL | 100 | 100 | 7.95 | 1
2016-09-14 00:00:00 | Sell | GS | 100 | 120 | 7.95 | 1
2016-10-21 00:00:00 | Sell | UHAL | 667 | 95 | 7.95 | 1
2016-11-23 00:00:00 | Fee | AAPL | 0 | 0 | 40 | 1
2017-02-05 00:00:00 | Buy | WNC | 1541 | 13.22 | 3.95 | 1
2017-02-16 00:00:00 | Div | MMM | 155 | 3 | 0 | 1
2017-03-22 00:00:00 | Split | MMM | 0 | 0 | 0 | 4
2017-04-01 00:00:00 | Div | AAPL | 1 | 1822 | 0 | 1
2018-12-24 00:00:00 | Buy | MU | 20 | 29.02 | 4.95 | 1
2023-04-12 00:00:00 | Sell | MMM | 620 | 104.35 | 0 | 1
Spreadsheet: 94125d1293991572-excel-2007-populate-invoice-fields-based-on-invoice-number-client_db
Sheet: Post Codes

Suburb
[NAME]
[NAME]
Alkimos
[NAME]
Applecross PO Boxes
Applecross, WA 6153
Ardross, WA 6153
Armadale PO Boxes, WA 6992
Armadale, WA 6112
Ascot, WA 6104
Ashby, WA 6065
Ashfield, WA 6054
Attadale, WA 6156
Atwell, WA 6164
[NAME], WA 6164
Australind, WA 6233
Balcatta, WA 6021
Balcatta PO Boxes, WA 6914
Baldivis, WA 6171
Balga, WA 6061
Ballajura, WA 6066
Banjup, WA 6164
[NAME]
Banksiadale, WA 6213
[NAME], WA 6210
Baskerville, WA 6056
Bassendean PO Boxes, WA 6934
Bassendean, WA 6054
[NAME], WA 6150
Bayswater PO Boxes, WA 6933
Bayswater, WA 6053
Beaconsfield, WA 6162
Beckenham, WA 6107
Bedford, WA 6052
Bedfordale, WA 6112
Beechboro, WA 6063
Beeliar, WA 6164
Beldon, WA 6027
Belhus, WA 6069
Bellevue, WA 6056
Belmont PO Boxes, WA 6984
Belmont, WA 6104
Hamersley, WA 6022
[NAME], WA 6028
[NAME], WA 6030
Wangara, WA 6065
Morley, WA 6062
Redcliffe, WA 6104
Spreadsheet: dad16f34-0227-4f45-a067-7dd3da4ff201
Sheet: Sheet1

Walk Through Request | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Walking through paperwork for processing of any type of payments must be approved by the
the appropriate Vice Chancellor.
I, |  |  | request permission for staff members to perform the following task(s),
which do not fall within the timeline of normal processing set forth by the Budget, Purchasing,
and Accounts Payable departments:
 | Budget Department
 | Fund check requisition(s) upon presenting.
 | Purchasing Department
 | Create purchase order(s) upon presenting requisition(s).
 | Accounts Payable
 | Process paperwork for payment upon presenting.
 | Print and release check(s) earlier than the scheduled printing process.
Reason for request:
Signature - Vice Chancellor |  |  |  |  |  | Date
Walk Through Request
Walking through paperwork for processing of any type of payments must be approved by the
the appropriate Vice Chancellor.
I, |  |  | request permission for staff members to perform the following task(s),
which do not fall within the timeline of normal processing set forth by the Budget, Purchasing,
and Accounts Payable departments:
 | Budget Department
 | Fund check requisition(s) upon presenting.
 | Purchasing Department
 | Create purchase order(s) upon presenting requisition(s).
 | Accounts Payable
 | Process paperwork for payment upon presenting.
 | Print and release check(s) earlier than the scheduled printing process.
Reason for request:
Signature - Vice Chancellor |  |  |  |  |  | Date
Spreadsheet: darrell_schoolcraft__7334__imball0203
Sheet: monthly

 | March
 | Vol Imbalance
[NAME]
Lonestar
PG&E
SoCal
PGETX
El Paso
Red Cedar
Amoco Florida
Oasis
Agave
Conoco
Northwest
TransColorado
Duke
Mewborne
Amoco Abo
NNG
PNM
NGPL
Mojave
EOG
OneOK
Continental
CIG
Calpine
[NAME]
[NAME]
North Star Steele
Citizens-Griffith
Citizens
PEPL
MiVida_Rich
[NAME]
WTGinc
Dominion
[NAME]
Amarillo
SWGasTrans
Stratland
Plains
Burlington
Spreadsheet: 79349d1279635318-creating-worksheets-from-cell-values-buckshead-datasheet-example
Sheet: Sheet2

 | DATA RANGE
 | 0 | 0 | 2 | 3 | 6 | F
 | 1 | A | 7 | 2 | 14 | N
 | 2 | B | 3 | 3 | 9 | I
 | 3 | C | 4 | 2 | 8 | H
 | 4 | D | 1 | 7 | 7 | G
 | 5 | E | 4 | 2 | 8 | H
 | 6 | F | 4 | ` |  | 0
 | 7 | G |  |  |  | 0
 | 8 | H |  |  |  | 0
 | 9 | I
 | 10 | J
 | 11 | K
 | 12 | L
 | 13 | M
 | 14 | N
 | 15 | O
 | 16 | P
 | 17 | Q
 | 18 | R
 | 19 | S
 | 20 | T
 | 21 | U
Spreadsheet: 273934d1382969227-counting-text-in-cells-dependant-on-a-date-range-sample-enquiry-quote-reg-master-nov-2012-march-2013
Sheet: Totals

 |  |  |  |  |  |  |  |  |  | [NAME] assigned to
Yearly | Enquiries | [NAME] | Ongoing Enquiries | Quoted | Won | Lost | Quotes Disguarded | Ongoing Quotes | Unique Projects | JT | PE | JG
Quarterly | Enquiries | [NAME] | Ongoing Enquiries | Quoted | Won | Lost | Quotes Disguarded | Ongoing Quotes | Unique Projects
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Monthly | Enquiries | [NAME] | Ongoing Enquiries | Quoted | Won | Lost | Quotes Disguarded | Ongoing Quotes | Unique Projects |  |  |  |  |  |  |  | Start date | End Date
April |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YEAR | 2013-04-01 00:00:00 | 2014-03-31 00:00:00
May |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q1 | 2013-04-01 00:00:00 | 2013-06-30 00:00:00
June |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q2 | 2013-07-01 00:00:00 | 2013-09-30 00:00:00
July |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3 | 2013-10-01 00:00:00 | 2013-12-31 00:00:00
August |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q4 | 2014-01-01 00:00:00 | 2014-03-31 00:00:00
September |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | April | 2013-04-01 00:00:00 | 2013-04-30 00:00:00
October |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May | 2013-05-01 00:00:00 | 2013-05-31 00:00:00
November |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June | 2013-06-01 00:00:00 | 2013-06-30 00:00:00
December |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July | 2013-07-01 00:00:00 | 2013-07-31 00:00:00
January |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August | 2013-08-01 00:00:00 | 2013-08-31 00:00:00
February |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September | 2013-09-01 00:00:00 | 2013-09-30 00:00:00
March |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October | 2013-10-01 00:00:00 | 2013-10-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November | 2013-11-01 00:00:00 | 2013-11-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December | 2013-12-01 00:00:00 | 2013-12-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January | 2014-01-01 00:00:00 | 2014-01-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February | 2014-02-01 00:00:00 | 2014-02-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March | 2014-03-01 00:00:00 | 2014-03-31 00:00:00
Spreadsheet: 191976d1352270071-how-to-count-the-text-and-at-the-same-time-disregard-counting-those-that-repeats-yan-workbook
Sheet: Sheet1

ID NUMBERs | DATE |  | ANSWER |  |  | RANGE of DATE to look
1 | 2012-12-02 00:00:00 |  |  |  |  | 2012-12-18 00:00:00
1 | 2012-12-03 00:00:00 |  |  |  |  | 2012-12-02 00:00:00
3 | 2012-12-04 00:00:00
1 | 2012-12-05 00:00:00
2 | 2012-12-06 00:00:00
1 | 2012-12-07 00:00:00
1 | 2012-12-08 00:00:00
1 | 2012-12-09 00:00:00
2 | 2012-12-10 00:00:00
1 | 2012-12-11 00:00:00
1 | 2012-12-12 00:00:00
2 | 2012-12-13 00:00:00
2 | 2012-12-14 00:00:00
2 | 2012-12-15 00:00:00
1 | 2012-12-16 00:00:00
1 | 2012-12-17 00:00:00
2 | 2012-12-18 00:00:00
Spreadsheet: 49813d1249211147-mixing-numbers-up-random-5
Sheet: Sheet1

numbers | random number | rank random  unique in unlikely case of duplicates | groups off 9
11 | 0.1427182833531249 | 50 | 99
15 | 0.8475878110392896 | 11 | 22
22 | 0.3712192168631212 | 36 | 333
22 | 0.9552558127133459 | 2 | 199
30 | 0.7786636577702781 | 15 | 88
30 | 0.467109961901496 | 32 | 22
30 | 0.6982628345922839 | 21 | 150
30 | 0.850625530820059 | 10 | 99
30 | 0.2046651837992792 | 47 | 66
30 | 0.2280970927212851 | 45 | 30
30 | 0.3528746157408542 | 38 | 15
30 | 0.7929281909292347 | 14 | 150
30 | 0.5590901160142039 | 29 | 333
30 | 0.03535637549636572 | 53 | 30
30 | 0.4462907498077532 | 34 | 30
30 | 0.2327808619445677 | 44 | 333
150 | 0.3521721575994545 | 39 | 66
150 | 0.8940867842429121 | 7 | 219
150 | 0.03763504963975972 | 52 | 333
150 | 0.8251495120802217 | 12 | 50
99 | 0.004685139857237175 | 54 | 30
99 | 0.2240855379262953 | 46 | 215
99 | 0.9553949741463332 | 1 | 66
99 | 0.1453680911386641 | 49 | 219
99 | 0.8713500728202519 | 8 | 215
219 | 0.7403921676938845 | 18 | 215
219 | 0.6028059216396287 | 24 | 215
219 | 0.368283422792973 | 37 | 215
219 | 0.1228222497877545 | 51 | 30
186 | 0.4486421655366226 | 33 | 88
186 | 0.3260347351707202 | 40 | 88
186 | 0.1984611116434347 | 48 | 30
186 | 0.2979044501723633 | 41 | 186
199 | 0.9309321427802948 | 4 | 30
22 | 0.8959012452751445 | 6 | 50
66 | 0.8574568471938937 | 9 | 22
66 | 0.2950232912300361 | 42 | 219
66 | 0.6350701701847552 | 23 | 30
66 | 0.2354683844808241 | 43 | 150
66 | 0.7463309861732681 | 17 | 186
88 | 0.9279422076659714 | 5 | 186
88 | 0.531748487504653 | 30 | 66
88 | 0.5132227831968965 | 31 | 66
215 | 0.5722807767206719 | 28 | 30
215 | 0.58083517371875 | 27 | 30
215 | 0.593568091844161 | 25 | 99
215 | 0.6435570015055614 | 22 | 30
215 | 0.5846387861183908 | 26 | 186
333 | 0.9488454687162289 | 3 | 99
333 | 0.8226752620838225 | 13 | 11
333 | 0.7050759252204504 | 19 | 219
333 | 0.7619885900431074 | 16 | 150
50 | 0.7012698133575022 | 20 | 30
50 | 0.3821639840286997 | 35 | 99
Spreadsheet: 831206d1685499675-is-there-a-max-number-of-characters-in-the-criteria-in-vlookup-sos
Sheet: Sheet1

 |  | 270
match / vlookup
 | >> look for
aggregate
match + left/mid (Array)
Spreadsheet: michelle_lokay__26631__imbalsumm0102
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
[NAME] | 12353 | WestarCarson | 500168 | Westar Ward
 | Scheduled | Measured | Scheduled | Measured
1 | 15000 | 15797 | 38264 | 38260
2 | 7500 | 15788 | 40528 | 41288
3 | 0 | 185 | 55919 | 52978
4 | 0 | 0 | 55926 | 52792
5 | 0 | 0 | 55221 | 55832
6 | 0 | 0 | 54884 | 57868
7 | 0 | 0 | 66274 | 56585
8 | 20000 | 21165 | 76897 | 66594
9 | 15000 | 15951 | 44028 | 46999
10 | 15000 | 15902 | 58028 | 49276
11 | 15000 | 15970 | 58028 | 52714
12 | 15000 | 0 | 58028 | 47027
13 | 15000 | 15987 | 40790 | 34024
14 |  |  | 70773 | 84136
15 |  |  | 34028 | 29675
16 |  |  | 74028 | 73764
17 |  |  | 62786 | 64068
18 |  |  | 63203 | 64331
19 |  |  | 64028 | 64011
20
21
22
23
24
25
26
27
28
29
30
31
index
2001-01-31 00:00:00 |  |  |  |  | 840348.85
2001-02-19 00:00:00
Spreadsheet: robin_rodrigue__33345__Canada Power Positions_Jun19
Sheet: ROM_hrs

Rest of Month - Hours
Today
 |  |  | Mid-C Convention |  |  | AB Convention |  |  |  | ROM Hours- Mid C |  |  | ROM Hours - AB |  |  |  | ROM Positions
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NET - 5 X 11 + 48
Monthly Totals  -Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prices |  |  |  |  |  | [NAME] by weekday / sat / sun |  |  |  | MTM
Days |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAU | TAU | Duke
Date | Weekday | NERC holiday | Peak Hours (6 X 16) | Off-Peak Hours (6 X 8 + 24) |  | Peak Hours (HE 8 - 20) | Peak Hours (HE 21 - 23) | Off Peak Hours (HE 1 - 7, 24) |  | Peak Hours (6 X 16) | Off-Peak Hours (6 X 8 + 24) |  | Peak Hours (5 X 16) | Off Peak Hours (5 X 8) | Weekends (2 X 24) |  | Peak Hours (HE 8 - 20) | Peak Hours (HE 21 - 23) | Off Peak Hours (HE 1 - 7, 24) | 5 X 13 - 1 | 5 X 11 + 48 - 1 |  | 5 X 13 - 1 | 7 X 24 - 1 | 7X24 - 2 | 5 X 13 - 1 | 5 X 11 + 48 - 1 |  | 5 X 13 | 7 X 24 | 5 X 11 + 48 |  | 5 X 13 - 1 | 7 X 24 - 1 | 7X24 - 2 | 5 X 13 - 1 | 5 X 11 + 48 - 1
2000-06-01 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-02 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-03 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-04 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-05 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-06 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-07 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-08 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-09 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-10 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-11 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-12 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-13 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-14 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-15 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-16 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-17 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-18 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-19 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-20 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-21 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-22 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-23 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-24 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-25 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-26 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-27 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-28 00:00:00 |  | N |  |  |  |  | 3 | 8
2000-06-29 00:00:00 |  | Y |  |  |  |  | 3 | 8
2000-06-30 00:00:00 |  | N |  |  |  |  | 3 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | rom profit
Spreadsheet: 144690d1331102402-hyperlink-vlookup-copying-different-columns-by-order-from-hyperlink-doc-to-another-book2
Sheet: Sheet1

2012-03-02 00:00:00 | KIR | 37 | 512-15 | 200 | 200 | 20 | 2500 |  | TF | Z | 5
2012-03-06 00:00:00 | F-KA | 75 | 1112-14 | 180 | 100 | 100 | 5800 |  | TF | Z | 11
2012-03-03 00:00:00 | F-KA | 77 | 112-25 | 150 | 140 | 25 | 1700 |  | TD | P | 1
Spreadsheet: 780850d1652814997-counting-quantity-of-a-product-number-throughout-multiple-tabs-estimate-totals
Sheet: Sign Types

Product No.
CB-CH-FL-C-TC-H-12
CB-CH-FL-C-TC-H-15
CB-CH-FL-C-TC-H-18
CB-CH-FL-C-TC-H-21
CB-CH-FL-C-TC-H-24
CB-CH-FL-C-TC-H-27
CB-CH-FL-C-TC-H-30
CB-CH-FL-C-TC-H-33
CB-CH-FL-C-TC-H-36
CB-CH-FL-W-TC-H-12
CB-CH-FL-W-TC-H-15
CB-CH-FL-W-TC-H-18
CB-CH-FL-W-TC-H-21
CB-CH-FL-W-TC-H-24
CB-CH-FL-W-TC-H-27
CB-CH-FL-W-TC-H-30
CB-CH-FL-W-TC-H-33
CB-CH-FL-W-TC-H-36
CB-CH-FL-C-TC-H-RWY-12
CB-CH-FL-C-TC-H-RWY-15
CB-CH-FL-C-TC-H-RWY-18
CB-CH-FL-C-TC-H-RWY-21
CB-CH-FL-C-TC-H-RWY-24
CB-CH-FL-C-TC-H-RWY-27
CB-CH-FL-C-TC-H-RWY-30
CB-CH-FL-C-TC-H-RWY-33
CB-CH-FL-C-TC-H-RWY-36