tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 29198d1224049623-sumproduct-gives-wrong-answer-learning-plan-hoganas-draft
Sheet: Sheet4

 |  |  |  |  |  |  |  |  |  |  |  |  | Marknad |  | Marknad | Marknad
 |  |  |  |  |  |  |  |  |  |  |  |  | Marknad |  |  | Marknad | Marknad | Marknad
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Marknad | Marknad
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Marknad | Marknad
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Marknad | Marknad
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Marknad | Marknad
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Marknad | Marknad
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Marknad | Marknad
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Marknad | Marknad
Spreadsheet: 683010d1592425371-returning-occurrences-excel-help-1
Sheet: Sheet2

TM# | Name | Position | Attribute | Value
11111 | Employee 1 | Worker 1 | 1/1/2019 | Yes
11111 | Employee 1 | Worker 1 | 1/2/2019 | No
11111 | Employee 1 | Worker 1 | 1/4/2019 | Yes
11111 | Employee 1 | Worker 1 | 1/5/2019 | No
11111 | Employee 1 | Worker 1 | 1/7/2019 | Yes
11111 | Employee 1 | Worker 1 | 1/8/2019 | No
11111 | Employee 1 | Worker 1 | 1/10/2019 | Yes
11111 | Employee 1 | Worker 1 | 1/11/2019 | No
11111 | Employee 1 | Worker 1 | 1/13/2019 | Yes
11111 | Employee 1 | Worker 1 | 1/14/2019 | No
11111 | Employee 1 | Worker 1 | 1/16/2019 | Yes
11111 | Employee 1 | Worker 1 | 1/17/2019 | No
11111 | Employee 1 | Worker 1 | 1/19/2019 | Yes
11111 | Employee 1 | Worker 1 | 1/20/2019 | No
11111 | Employee 1 | Worker 1 | 1/22/2019 | Yes
11111 | Employee 1 | Worker 1 | 1/23/2019 | No
11111 | Employee 1 | Worker 1 | 1/25/2019 | Yes
11111 | Employee 1 | Worker 1 | 1/26/2019 | No
11111 | Employee 1 | Worker 1 | 1/28/2019 | Yes
11111 | Employee 1 | Worker 1 | 1/29/2019 | No
11111 | Employee 1 | Worker 1 | 1/31/2019 | Yes
Spreadsheet: 739008d1625429920-need-help-with-a-formula-to-deduct-a-conditionally-if-specific-cell-is-not-blank-excel-formula-help
Sheet: Sheet1

 |  | January | February | March | April | May | June
 | Number of Sales | 2000 | 1000 | 3000 | 6000 | 9000 | 5000
 | [NAME] | 15.21 | 15.92 | 19.97 | 21.04 | 20.52 | 21.25
 | Revenue
 |  |  |  | Manual Adjustments in %
 |  | January | February | March | April | May | June
 | Revenue
Spreadsheet: 877365d1724178300-match-data-of-vertical-column-to-horizontal-row-of-another-sheet-fa-test-paradise2sr-
Sheet: F1

Main Group | Category | Name of Party | Description | No | Units | Date | ID |  | UK | Russia
 | Apple | Google Inc | Black Apple | 25 | Pcs | 2081.04.25 | S-12 | 5263
Group A | Grapes | All the best | Imported | 85 | ctns | 2081.05.26 | Bh-36
Group A | Orange | New Era | [NAME] | 100 | [NAME] | 2081.04.08 | S-24 |  | 6356
Group B | Jasmine | [NAME] | Home Grown | 256 | Bdl | 2081.04.28 | S-94 | 526
Group C | Software | Microsoft Inc. | Bing | 1 | set | 2084.04.09 | Asw-44 |  |  | 652
Required Result
Main Group | Category | Name of Party | Description | No | Units | Date | ID | America | UK | Russia
Group A | Apple | Google Inc | Black Apple | 25 | Pcs | 2081.04.25 | S-12 | 5263
Group A | Grapes | All the best | Imported | 85 | ctns | 2081.05.26 | Bh-36
Group A | Orange | New Era | [NAME] | 100 | [NAME] | 2081.04.08 | S-24 |  | 6356
Sub Total
Group B | Jasmine | [NAME] | Home Grown | 256 | Bdl | 2081.04.28 | S-94 | 526
Sub Total
Group C | Software | Microsoft Inc. | Bing | 1 | set | 2084.04.09 | Asw-44 |  |  | 652
Sub Total
Grand Total
Spreadsheet: 799945d1665408053-count-if-across-multi-tabs-to-exclude-a-value-in-final-count-2022-10-11-oeldere-randomfluky
Sheet: Master Sheet

Offices | Outdoor Workers | Everyone Else
Office 1
Office 2
Office 3
Count Work titles | Kolomlabels
Rijlabels | Office 1 | Office 2 | Office 3 | Eindtotaal
Indoors | 1 | 2 | 3 | 6
Haze |  |  | 1 | 1
[NAME] |  |  | 1 | 1
[NAME] |  |  | 1 | 1
[NAME] | 1 |  |  | 1
Tanya |  | 1 |  | 1
Titchy |  | 1 |  | 1
Kitchen | 1 | 3 | 1 | 5
[NAME] |  | 1 |  | 1
[NAME] |  |  | 1 | 1
[NAME] |  | 1 |  | 1
[NAME] | 1 |  |  | 1
Ursula |  | 1 |  | 1
Outdoors | 5 | 3 | 4 | 12
[NAME] |  | 1 |  | 1
[NAME] | 1 |  |  | 1
Boots |  | 1 |  | 1
[NAME] | 1 |  |  | 1
Lynsey |  |  | 1 | 1
[NAME] | 1 |  |  | 1
[NAME] | 1 |  |  | 1
Posy |  |  | 1 | 1
Pudding |  |  | 1 | 1
Rosy |  |  | 1 | 1
[NAME] | 1 |  |  | 1
Willow |  | 1 |  | 1
Warehouse | 1 |  |  | 1
Nicola | 1 |  |  | 1
Eindtotaal | 8 | 8 | 8 | 24
Spreadsheet: 758380d1638837116-pull-data-from-other-tabs-into-a-summary-tab-only-if-certain-data-selected-in-column-ssu-template-7-12-2021
Sheet: POST SSU TRAINING

 |  |  | POST SSU TRAINING
 | SMALL EQUIP |  |  |  | HANDPIECES & TIPS |  |  |  | SURGICAL & IMPLANTS |  |  |  | ENDODONTICS |  |  |  | CONSUMABLES |  |  |  | IMS & CASSETTES |  |  |  | OTHER
 | ITEM CODE | [NAME] | POST SSU TRAINING |  | ITEM CODE | [NAME] | POST SSU TRAINING |  | ITEM CODE | [NAME] | POST SSU TRAINING |  | ITEM CODE | [NAME] | POST SSU TRAINING |  | ITEM CODE | [NAME] | POST SSU TRAINING |  | ITEM CODE | [NAME] | POST SSU TRAINING |  | ITEM CODE | [NAME] | POST SSU TRAINING
Spreadsheet: 158376d1338206224-depentent-fropdown-list-with-some-specifice-features-essameldin_dep_drop_down_list_28may12_01
Sheet: SBOX

Tool No. | Bottom Connection | Pressure Rating | Cert. date
MWS 38634 | 5 3/4"-4 Otis pin/collar | 10,000 Psi | 2011-06-24 00:00:00
MWS 38635 |  | 10,000 Psi | 2011-10-19 00:00:00
AWS 44307 | 5 3/4"-4 Otis pin/collar | 10,000 Psi | 2011-10-19 00:00:00
AKWS-44038 | 5 3/4"-4 Otis pin/collar | 10,000 Psi | 2011-05-05 00:00:00
AKWS-44039 | 5 3/4"-4 Otis pin/collar | 10,000 Psi | 2011-12-06 00:00:00
AWS 44195 | 5 3/4"-4 Otis pin/collar | 10,000 Psi | 2011-08-13 00:00:00
AWS 44196 | 5 3/4"-4 Otis pin/collar | 10,000 Psi | 2011-10-19 00:00:00
Spreadsheet: 87402d1287249700-allocation-based-on-date-allocation-spreadsheet
Sheet: Sheet1

ABC Company
Allocation of Prepaid "Maintenance"
Fiscal Year 2010
Balance Sheet Account = 121110
 | Term |  |  | Accounting |  |  |  |  | Allocation
Vendor / Description | Start Date | End Date | Posting Date | Total Invoice | Acct GL - CC | System Entry | Location |  |  | 2010-01-01 00:00:00
Microsoft
SQL Server Support |  |  |  | 26000 | [PHONE] | Yes | [NAME]
PO: 450000001 | 2010-03-01 00:00:00 | 2010-12-01 00:00:00 | 2010-01-01 00:00:00 |  |  |  |  | Monthly Alloc
 |  |  |  |  |  |  |  | Bal @ Month
Microsoft Office Support |  |  |  | 36000 | [PHONE] | Yes | [NAME]
PO: 450000002 | 2010-07-01 00:00:00 | 2010-12-01 00:00:00 | 2010-07-01 00:00:00 |  |  |  |  | Monthly Alloc
 |  |  |  |  |  |  |  | Bal @ Month
Microsoft [NAME] |  |  |  | 48000 | [PHONE] | Yes | Plant01
PO: 450000003 | 2010-07-01 00:00:00 | 2010-12-01 00:00:00 | 2010-06-01 00:00:00 |  |  |  |  | Monthly Alloc
 |  |  |  |  |  |  |  | Bal @ Month
Microsoft Priority Support |  |  |  | 60000 | [PHONE] | Yes | Plant02
PO: 450000004 | 2010-07-01 00:00:00 | 2011-06-01 00:00:00 | 2010-08-01 00:00:00 |  |  |  |  | Monthly Alloc
 |  |  |  |  |  |  |  | Bal @ Month
 |  |  |  |  |  |  |  |  | Consolidated Balance:
 |  |  |  |  |  |  |  |  | System Balance: | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Consolidated Expense:
Spreadsheet: 6fddf864-0872-40b4-b7b6-8d1a38b56d43
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
FFVOX | Test | FFVOX | Fluvoxamine (Luvox) | Fluvoxamine (Luvox) | High Performance Liquid Chromatography with Ultraviolet Detection; (HPLC-UV) |  |  |  |  |  | Submit only 1 of the following specimens:  Plasma Draw blood in a green-top sodium heparin tube(s), plasma gel tube is not acceptable. Spin down and send 3mL of plasma refrigerated in a plastic vial.   Serum  Draw blood in a plain, red-top tube(s), serum gel tube is not acceptable. Spin down and send 3 mL of serum refrigerated in a plastic vial. | 0.6 mL | Hemolysis	NA Thawing	Cold OK; Warm OK Lipemia	NA Icterus	NA Other	NA | Units:	ng/mL  Expected fluvoxamine concentrations on recommended daily dosage regimens: 	50 - 900 ng/mL  Test Performed by:	Medtox Laboratories, Inc.  			402 W. County Road D 			St. Paul, MN 55112 | Monday through Sunday | 3 days | 5 - 7 days | 1 | 82491 |  |  |  |  | Medtox Laboratories, Inc.
FFVOX | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
FFVOX | Result | FFVOX | Fluvoxamine (Luvox) | Fluvoxamine (Luvox) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 97790d1296860396-classifying-by-description-atq-asset-list
Sheet: Sheet3

 |  |  |  | KEYWORD | CLASS
 | PRESSURE INDICATOR | P IND |  | PUMP | PUMP
 | TEMPERATURE INDICATOR | T IND |  | MOTOR | MOTOR
 | PUMP | PUMP |  | STARTER | MOTOR
 | MOTOR | MOTOR |  | PRESSURE INDICATOR | P IND
 | STARTER | MOTOR |  | TEMPERATURE INDICATOR | T IND
 | UNIT HEATER | HEAT |  | PRESSURE TRANSMITTER | P TRANS
 | CABINET HEATER | HEAT |  | FLOW TRANSMITTER | T TRANS
 | GLYCOL PUMP | PUMP |  | MUFFIN | GRINDER
 |  |  |  | TANK | TANK
 |  |  |  | RESERVOIR | TANK
 |  |  |  | HEATER | HEAT
 |  |  |  | FILTER | FILTER
 |  |  |  | [NAME] | [NAME]
 |  |  |  | EMG | EMG
 |  |  |  | EYEWASH | EMG
 |  |  |  | BREAKER | PWR REG
 |  |  |  | FUSE | PWR REG
 |  |  |  | SWITCH | PWR REG
 |  |  |  | CIRCUIT BOARD | PWR REG
 |  |  |  | RELAY | PWR REG
 |  |  |  | TRANSFORMER | PWR REG
 |  |  |  | CONTROL | CONTROL
 |  |  |  | COMPRESSOR | COMP
 |  |  |  | DRYER | DRYER
 |  |  |  | AHU | HVAC
 |  |  |  | EXHAUST FAN | HVAC
 |  |  |  | ACTUATOR | ACT
 |  |  |  | HEAT EXCHANGER | HX
 |  |  |  | SEQUENCER | CONTROL
 |  |  |  | TEST | TEST
 |  |  |  | LIGHT | IND
 |  |  |  | BUTTON | PWR REG
 |  |  |  | RESET | PWR REG
 |  |  |  | AUTODIALER | ALARM
 |  |  |  | ANNUNCIATOR | IND
 |  |  |  | PLC | CONTROL
Spreadsheet: 826312d1681922311-copying-data-from-a-new-daily-file-to-a-master-file-with-all-data-temp-mac-sheets
Sheet: MASTER

ID # | Test Date | Milliamps | Test Date2 | Milliamps3 | Test Date4 | Milliamps5 | Test Date6 | Milliamps7 | Test Date8 | Milliamps9 | Test Date10 | Milliamps11 | Test Date12 | Milliamps13
33413 | 44475 | 7
33435 | 2020-04-23 00:00:00 | 6 | 2021-10-13 00:00:00 | 4
33472 | 43962 | 10
33337 | 2012-10-26 00:00:00 | 7 | 2013-05-06 00:00:00 | 7 | 2013-11-12 00:00:00 | 7 | 2014-05-05 00:00:00 | 7 | 2016-06-03 00:00:00 | 7 | 2017-04-26 00:00:00 | 7 | 2017-12-12 00:00:00 | 8
33629 | 2012-10-26 00:00:00 | 7 | 2013-05-06 00:00:00 | 5 | 2013-11-12 00:00:00 | 7 | 2014-05-22 00:00:00 | 7 | 2014-12-18 00:00:00 | 7 | 2015-07-09 00:00:00 | 7 | 2016-01-11 00:00:00 | 7
33336 | 2012-07-13 00:00:00 | 6 | 2013-01-07 00:00:00 | 7 | 2013-08-08 00:00:00 | 7 | 2014-02-14 00:00:00 | 7 | 2014-08-28 00:00:00 | 7 | 2015-02-11 00:00:00 | 7 | 2015-09-04 00:00:00 | 7
33360 | 2012-07-13 00:00:00 | 8 | 2013-01-07 00:00:00 | 8 | 2014-07-29 00:00:00 | 8 | 2015-02-11 00:00:00 | 9 | 2015-07-31 00:00:00 | 8 | 2016-02-04 00:00:00 | 9 | 2016-09-30 00:00:00 | 9
33287 | 2012-10-15 00:00:00 | 11 | 2013-03-15 00:00:00 | 12 | 2013-09-13 00:00:00 | 12 | 2014-03-24 00:00:00 | 12 | 2014-09-24 00:00:00 | 12 | 2015-03-27 00:00:00 | 13 | 2016-03-02 00:00:00 | 12
33288 | 2012-10-26 00:00:00 | 7 | 2013-11-01 00:00:00 | 7 | 2014-04-30 00:00:00 | 7 | 2014-11-20 00:00:00 | 7 | 2015-12-07 00:00:00 | 7 | 2016-06-28 00:00:00 | 7 | 2016-12-08 00:00:00 | 7
33289 | 2012-09-05 00:00:00 | 7 | 2013-08-23 00:00:00 | 7 | 2014-01-31 00:00:00 | 7 | 2014-08-07 00:00:00 | 7 | 2015-06-12 00:00:00 | 7 | 2015-10-01 00:00:00 | 12 | 2015-12-23 00:00:00 | 7
33290 | 2012-07-13 00:00:00 | 9 | 2013-02-08 00:00:00 | 9 | 2013-03-14 00:00:00 | 10 | 2013-08-08 00:00:00 | 10 | 2014-09-24 00:00:00 | 10 | 2015-06-12 00:00:00 | 9 | 2015-12-11 00:00:00 | 10
33293 | 2012-10-26 00:00:00 | 7 | 2013-05-06 00:00:00 | 7 | 2013-11-12 00:00:00 | 7 | 2014-05-22 00:00:00 | 7 | 2015-07-15 00:00:00 | 7 | 2016-01-15 00:00:00 | 7 | 2016-08-09 00:00:00 | 7
Spreadsheet: 0bb685ab-0234-4395-9a90-0e4893b69e6a
Sheet: Sheet1

Unnamed: 0 | IMPERIAL VALLEY COLLEGE | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | MEN'S SOCCER SCHEDULE
 | FALL 2012
DAY | DATE | OPPONENT | PLACE | TIME
SEPT 19 | WEDNESDAY | COLLEGE OF THE DESERT | COD | 16:00:00
SEPT 25 | TUESDAY | *MIRA COSTA COLLEGE | MCC | 16:00:00
SEPT 28 | FRIDAY | *PALOMAR COLLEGE | PC | 15:15:00
OCT 2 | TUESDAY | *SOUTHWESTERN COLLEGE | IVC | 15:15:00
OCT 5 | FRIDAY | BYE
OCT 9 | TUESDAY | *SAN DIEGO CITY COLLEGE | IVC | 15:15:00
OCT 11 | THURSDAY | VICTOR VALLEY | VV | 15:00:00
OCT 12 | FRIDAY | *SAN DIEGO MESA COLLEGE -DH | SDMC | 16:00:00
OCT 16 | TUESDAY | *CUYAMACA COLLEGE | CC | 15:15:00
OCT 19 | FRIDAY | *MIRA COSTA COLLEGE | IVC | 15:00:00
OCT 23 | TUESDAY | *PALOMAR COLLEGE | IVC | 15:00:00
OCT 26 | FRIDAY | *SOUTHWESTERN COLLEGE - DH | SWC | 13:00:00
OCT 30 | TUESDAY | BYE
NOV 2 | FRIDAY | *SAN DIEGO CITY COLLEGE | SDCC | 13:00:00
NOV 6 | TUESDAY | *SAN DIEGO MESA COLLEGE | IVC | 15:00:00
NOV 8 | THURSDAY | CHAFFEY COLLEGE | CC | 15:00:00
NOV 9 | FRIDAY | *CUYAMACA COLLEGE - DH | IVC | 15:00:00
* Denotes Conference Games |  | DH Denotes Double Headers
[NAME], Head Coach |  | (760) 355 - 6325
[NAME], Asst. Coach |  | (760) 355 - 6325
[NAME], Athletic Director |  | (760) 355 - 6341
[NAME], Secretary |  | (760) 355 - 6325
[NAME], [NAME] |  | (760) 355 - 6329
Athletic Fax |  | (760) 355 - 6514 |  | 2012-08-31 00:00:00
ATHLETICS DEPARTMENT 380 E. ATEN ROAD, IMPRIAL, CA 92251
Spreadsheet: 716444d1612208959-need-to-count-if-5-blank-rows-are-present-in-a-column-card-usage-chart_6mth-susp-365term
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | P
2020 | 0001-6 | 0002-4 | 0003-2 | 0004-0 | 0005-7 | 0006-5 | 0007-3 | 0008-1 | 0009-9
OCT |  |  | P
NOV |  |  | P
DEC |  | P | P |  |  |  |  | P
JAN |  | P | P | P
FEB |  | P | P |  |  |  | P | P | P
MAR | P | P | P |  |  |  |  | P | P
APR |  | P | P |  |  |  | P |  | P
MAY |  |  | P
JUN |  |  | P |  | P
JUL | P | P | P |  | P |  | P | P
AUG |  | P | P |  | P |  |  | P | P
SEP |  | P | P |  |  |  |  | P
2021
OCT | P | P | P
NOV |  | P
DEC | P
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
2022
Spreadsheet: 884998d1734390393-match-and-index-function-example-for-excel
Sheet: Table

Entity 1 | Entity 2 | Wtg 1 | [NAME] | [NAME]
SY | Blank | 1 | 0 | 1 | Only entity with only one entiy and 100% weight
SY | SR | 0.7 | 0.3 | 1.01
SY | NR | 0.7 | 0.3 | 1.02
SY | SO | 0.7 | 0.3 | 1.03
SY | EMG | 0.7 | 0.3 | 1.04
SY | NCH | 0.7 | 0.3 | 1.05
SY | SW | 0.7 | 0.3 | 1.06
SY | RE | 0.7 | 0.3 | 1.07
SY | NH | 0.7 | 0.3 | 1.08
SY | SR | 0.6 | 0.4 | 1.09 | Repeat here but with different mix in weighting
SY | NR | 0.6 | 0.4 | 1.1
SY | SO | 0.6 | 0.4 | 1.11
SY | EMG | 0.6 | 0.4 | 1.12
SY | NCH | 0.6 | 0.4 | 1.13
SY | SW | 0.6 | 0.4 | 1.14
SY | RE | 0.6 | 0.4 | 1.15
SY | NH | 0.6 | 0.4 | 1.16
SY | SS | 0.8 | 0.2 | 1.17 | Only entity with 80/20 weight
SY | SR | 0.5 | 0.5 | 1.18 | Repeat here but with different mix in weighting
SY | NR | 0.5 | 0.5 | 1.19
SY | SO | 0.5 | 0.5 | 1.2
SY | EMG | 0.5 | 0.5 | 1.21
SY | NCH | 0.5 | 0.5 | 1.22
SY | SW | 0.5 | 0.5 | 1.23
SY | RE | 0.5 | 0.5 | 1.24
SY | NH | 0.5 | 0.5 | 1.25
Spreadsheet: 220489d1363180691-extract-non-zero-value-data-sample-solution
Sheet: Sheet1

 |  | Models
 |  | [NAME] | Helen | [NAME] | Isabel |  |  | Isabel
 | Product Code | Unit Price | Unit Price | Unit Price | Unit Price |  | 1
 | Door x 40 | 100 | 90 | 0 | 0 |  | 2
 | Door x 41 | 110 | 100 | 0 | 91 |  | 3
 | Door x 42 | 0 | 0 | 85 | 100 |  | 4
 | Door x 43 | 95 | 0 | 85 | 0 |  | 5
 | Door x 44 | 81 | 0 | 90 | 0 |  | 6
 | Door x 45 | 95 | 95 | 100 | 115 |  | 7
 | Door x 46 | 0 | 110 | 105 | 105 |  | 8
 | Door x 47 | 0 | 92 | 95 | 0 |  | 9
 | Door x 48 | 112 | 0 | 0 | 85 |  | 10
 | Door x 49 | 0 | 100 | 0 | 0 |  | 11
 | Door x 50 | 83 | 95 | 0 | 95 |  | 12
 | Door x 51 | 0 | 100 | 0 | 0 |  | 13
 | Door x 52 | 110 | 110 | 85 | 85 |  | 14
 | Door x 53 | 0 | 104 | 95 | 95 |  | 15
 | Door x 54 | 112 | 112 | 0 | 100 |  | 16
 | Door x 55 | 0 | 95 | 95 | 95 |  | 17
 | Door x 56 | 95 | 0 | 0 | 0 |  | 18
 | Door x 57 | 0 | 0 | 0 | 0 |  | 19
 | Door x 58 | 102 | 100 | 105 | 120 |  | 20
 | Door x 59 | 100 | 0 | 85 | 110 |  | 21
 | Door x 60 | 100 | 100 | 95 | 110 |  | 22
Spreadsheet: 158781d1338392377-excel-2007-compare-sheets-and-view-removed-rows-book2
Sheet: Sheet1

User Name | UserID | Title | Telephone # | [NAME] | User Status | User Role
[NAME] | CD3056S | Non-employee | 15685556664 | email | Active | Analyst
[NAME] C | DC7704S | Non-employee | 15685556664 | email | Active | Analyst
[NAME] | GJ9088S | Non-employee | 15685556664 | email | Active | Analyst
[NAME] | JG28957 | Non-employee | 15685556664 | email | Active | Analyst
[NAME] | JO12495 | Non-employee | 15685556664 | email | Active | Analyst
[NAME] | JR91483 | Non-employee | 15685556664 | email | Active | Analyst
[NAME] | SL93417 | Non-employee | 15685556664 | email | Active | Analyst
Spreadsheet: benjamin_rogers__1066__NewCo-7-15-00
Sheet: NewCo_Tax

NewCo FEDERAL TAXES
 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
('000 $) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 |  | Total | Check
STATE TAXES
ENA
FPLE
State Taxes (allocated to Projects)
FEDERAL TAXES
ENA (EBITDA less Power Contract Amortization)
FPLE
EBITDA from Plants
Less Corporate G&A
Plus Revenue to FPLE (Fees & Interests)
ENA: Interest Expense
FPLE: Interest Expense
Less Interest Expense
Plus Interest Income
ENA: Less Tax Depreciation
FPLE: Less Tax Depreciation
Less Tax Depreciation
Less State Taxes
Federal Taxable Income
Federal Tax Rate | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35
Federal Tax Expense/ (Benefit)
NOL Carryforward with PTC
NOL Utilization
Total Federal Cash Taxes Payable/(Benefit)
Wind Portfolio PTC
DEFERRED INCOME TAXES w/o Development Projects
Total Cash Taxes Paid
Total Book Taxes
Total Deferred Taxes
Cummulative Deferred Taxes
Deferred Tax Asset
Deferred Tax Liability
Spreadsheet: 677995d1589647378-data-validation-excel-dependant-list-doesnt-work-example1702
Sheet: All Exercise Activities

Date | Exercise | Category | Sub Category | Song | Artist | Key | Duration
 | Playing [NAME] | AEU
 | [NAME] | Ear Training
 | Melodic Repetition | Ear Training
 | [NAME] (Large Intervals) | Ear Training
 | [NAME] (Descending) | Ear Training
 | [NAME] (Large Intervals Descending) | Ear Training
 | Guitar Open Chords | Guitar
 | Guitar Open Inversion Chords | Guitar
 | Guitar Movable Chords | Guitar
 | Guitar Movable Inversion Chords | Guitar
 | [NAME] | Guitar
 | Guitar Intervals | Guitar
 | Guitar Harmonics | Guitar
 | Guitar Songs | Guitar
 | Playing Guitar | Guitar
 | Guitar Scales | Guitar
 | Theory AEU | AEU
 | Theory | Intellectual
 | [NAME] | Intellectual
 | [NAME] | AEU
 | Theory Chord Spellings | Intellectual
 | [NAME] | Keyboard
 | [NAME] | Keyboard
 | [NAME] | Keyboard
 | [NAME] | Keyboard
 | Playing Keyboard | Keyboard
 | [NAME] | Keyboard
Spreadsheet: b8f447ee-e1db-4616-84f2-9e897fffd506
Sheet: Sheet1

[NAME] | 5'-3' sequences | Unnamed: 2 | Product Size | Annealing temp | Tm
CONTIG6907 | TGCCGTTTGTTTGGTGTCTAT |  | 136 | 58 | 64.1
 | TCCACCACAGAACATTTCCAT |  |  |  | 64.1
CONTIG3885 | ACGTTCAGATGCAAAGAATGC |  | 129 | 55 | 64
 | TCAGTTGAACGAAGTTGACCA |  |  |  | 63.3
CONTIG3766 | CAGCCAAAGCTTGACATAAGG |  | 145 | 58 | 63.5
 | TTGACCAGTGATGTTCCACAA |  |  |  | 64.1
CD141219 | TTGCAGCATACAGTTGTTTCG |  | 134 | 58 | 63.7
 | ACTGGCATGTTGTTGGAAATC |  |  |  | 63.6
CD140068 | TCAGTTGAAGATACCGCTCGT |  | 113 | 58 | 63.6
 | TTGTTCATTCCGAGCCAATAG |  |  |  | 63.7
CD136148 | ATGGTCGGTCGAACGTAAAG |  | 109 | 58 | 63.7
 | TGGTAATCGGAGTGGTTTGTC |  |  |  | 63.6
[NAME] | GTTTTTGGCATATCACCGAAG |  | 143 | 58 | 63
 | [NAME] |  |  |  | 63.7
SMHP1ELAS | TTGGAGAGTGGTGAGATGGAG |  | 150 | 58 | 64.2
 | CGGAACAAAACAAAACACACA |  |  |  | 63.3
SCMFSP | CCTATGGCGGTGATTATGGTA |  | 128 | 58 | 63.2
 | GGGTTTGTAAGTGCCACCTTT |  |  |  | 63.8
SCMSLRNA | ACGCCTGATCACAAACACCAA |  | 124 | 58 | 63.5
 | CCGTGTGAGTGAGCGATTGAC |  |  |  | 63.5
CD091034 | CAATAGGCTGCCTTCAATGG |  | 104 | 55 | 64.3
 | CCAGACCTGTCGAGACAAGAG |  |  |  | 64
CD088220 | GGTGACGGGGTAGTGAAAGAT |  | 102 | 58 | 63.9
 | ATCACGTTCGACATTCTCTGC |  |  |  | 64.1
CONTIG3886 | ATTCACAGCAACATCACTTTC |  | 123 | 58 | 59.2
 | CCAGCTTTGCACATACCTGAT |  |  |  | 63.9
CD088762 | ATGTTAGCACCGGTTGATGAT |  | 120 | 58 | 63
 | ATGAGTTCGTTCCACTTGACG |  |  |  | 64
CONTIG6375 | TTGACAAGGTGTTTCTTGTTCAC |  | 124 | 55 | 62.8
 | ATCTGATCGAACTTCCGCATT |  |  |  | 64.6
CONITG5693 | AGAGTACCCGTGTTTTGTGTG |  | 146 | 58 | 61.5
 | CCGACGAGTATATTGAACAGGA |  |  |  | 62.7
CONTIG4231 | [NAME] |  | 102 | 58 | 63.5
 | GTCAACATTTATTGGAATGACA |  |  |  | 58.8
CONTIG4019 | CAGATGAATTCAAAAGCCAAA |  | 133 | 54 | 57.9
 | TGTGATCGTGATCAAACTATCG |  |  |  | 58.7
Alpha-tubulin | CTTCGAACCAGCAAATCAGA |  | 158 | 59 | 62.9
 | [NAME] |  |  |  | 62.9
Spreadsheet: 8368debd-e0aa-479e-92ce-4f32016fe8f5
Sheet: Report

Unit | Unit Priority | Objective Name | Strategic Direction | Impact Type | Resource Id | Resource Name | Resource Type | Year 1 Cost | Year 1 Savings | Year 2 Cost | Year 2 Savings | Year 3 Cost | Year 3 Savings | Year 4 Cost | Year 4 Savings
Administrative Applications | 1 | Provide user training | None | -- Pick One -- | 1.1.r1 | Class setup | OneTime | 25000 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Administrative Applications | 1 | Provide user training | None | -- Pick One -- | 1.1.r2 | Documentation and [NAME] | OnGoing | 68000 | 0 | 69500 | 0 | 72000 | 0 | 0 | 0
Administrative Applications | 3 | Provide current documentation | None | -- Pick One --
Administrative Applications | 2 | Publicize provided opportunities | None | -- Pick One --
Administrative Applications | 4 | Permissions maintenance | None | -- Pick One --
Administrative Applications | 2 | Implement structured project management | None | -- Pick One -- | 2.1.r1 | Project Manager | OnGoing | 108000 | 0 | 110000 | 0 | 113000 | 0 | 0 | 0
Administrative Applications | 1 | Staff development | None | -- Pick One --
Administrative Applications | 1 | Reclass UL Position | None | -- Pick One --
Administrative Applications | 1 | Consolidate HR | None | -- Pick One -- | 4.1.r1 | UL | OnGoing | 54000 | 0 | 55000 | 0 | 56500 | 0 | 0 | 0
Administrative Applications | 1 | Consolidate Finance | None | -- Pick One --
Spreadsheet: 839631d1692119336-formula-to-create-code-from-table-values-sample-code-sheet
Sheet: Sheet2

Contract | Code |  | Month | Month Code
DEC 22 EMINI S&P 500 | [NAME] |  | JAN | F
DEC 22 EMINI S&P 500 |  |  | FEB | G
DEC 22 CBT T-BONDS |  |  | MAR | H
DEC 23 CBT T-BONDS |  |  | APR | J
DEC 22 CBT T-BONDS |  |  | MAY | K
DEC 22 CBT WHEAT |  |  | JUN | M
NOV 22 CBT SOYBEANS |  |  | JUL | N
NOV 23 CBT SOYBEANS |  |  | AUG | Q
DEC 22 IMM J-YEN |  |  | SEP | U
DEC 22 CBT T-BONDS |  |  | OCT | V
NOV 22 CBT SOYBEANS |  |  | NOV | X
 |  |  | DEC | Z
Spreadsheet: darrell_schoolcraft__7805__imbalsumm0108
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 87555 | 87075
2 | 98252 | 97649
3 | 78608 | 77218
4 | 101009 | 100503
5 | 90729 | 89600
6 | 91681 | 90563
7 | 105225 | 103990
8 | 109389 | 107112
9 | 96923 | 96695
10 | 62710 | 62247
11 | 98145 | 100814
12 | 93439 | 93039
13 | 102036 | 101331
14 | 104231 | 108641
15 | 108131 | 109178
16 | 94371 | 94262
17 | 91954 | 91776
18 | 87470 | 86776
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | 21602.9
2001-08-18 00:00:00
CBS Volume
 |  |  | -43475
Spreadsheet: 772087d1647001938-aggregate-a-list-based-on-condition-aggregate-a-list-based-on-condition
Sheet: Sheet

 | Condition | Value
 | VALUE | test1 |  | VALUE
 | NO | test2
 | VALUE | test3
 | VALUE | test4
 | no | test5
 | VALUE | test6
 | VALUE | [NAME]
 | NO | test8
 | VALUE | test9
 | VALUE | test10
 | VALUE | test11
 |  | test12
 | VALUE