tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 849774d1700164268-countif-based-on-a-parameter-sample-excel
Sheet: PRICES

Currency
USD | 14.99
EUR | 19.99
USD | 24.99
USD | 14.99
EUR | 19.99
USD | 14.99
USD | 9.99
USD | 14.99
USD | 9.99
USD | 11.99
USD | 24.99
USD | 9.99
AUD | 34.99
EUR | 19.99
USD | 24.99
USD | 9.99
USD | 21.99
USD | 14.99
USD | 9.99
EUR | 19.99
USD | 9.99
USD | 14.99
USD | 14.99
USD | 9.99
USD | 14.99
USD | 24.99
USD | 14.99
USD | 14.99
BRL | 50
USD | 14.99
USD | 14.99
USD | 14.99
BGN | 43.99
USD | 14.99
USD | 14.99
USD | 14.99
USD | 14.99
USD | 14.99
USD | 14.99
USD | 14.99
USD | 14.99
[NAME] | 17490
USD | 21.99
USD | 21.99
COP | 45000
USD | 14.99
USD | 14.99
USD | 14.99
USD | 14.99
EUR | 12.99
USD | 14.99
EUR | 19.99
CZK | 530
USD | 14.99
DKK | 170
USD | 14.99
USD | 9.99
USD | 9.99
USD | 14.99
USD | 14.99
EGP | 469
USD | 14.99
USD | 14.99
USD | 14.99
EUR | 19.99
USD | 14.99
USD | 14.99
USD | 24.99
USD | 14.99
EUR | 19.99
EUR | 19.99
USD | 9.99
USD | 14.99
USD | 14.99
USD | 14.99
USD | 14.99
USD | 14.99
USD | 24.99
EUR | 19.99
USD | 14.99
GBP | 19.99
EUR | 19.99
USD | 14.99
USD | 9.99
USD | 9.99
USD | 14.99
GBP | 19.99
USD | 14.99
USD | 14.99
USD | 9.99
USD | 9.99
USD | 14.99
USD | 9.99
HKD | 159
HUF | 4900
USD | 24.99
INR | 1299
IDR | 220000
USD | 14.99
EUR | 19.99
GBP | 19.99
ILS | 79.9
EUR | 19.99
USD | 9.99
[NAME] | 2240
GBP | 19.99
USD | 14.99
KZT | 11490
USD | 14.99
USD | 14.99
EUR | 19.99
USD | 21.99
USD | 24.99
USD | 14.99
EUR | 12.99
USD | 14.99
USD | 14.99
USD | 14.99
USD | 14.99
CHF | 19.99
EUR | 19.99
EUR | 19.99
USD | 14.99
USD | 24.99
USD | 14.99
USD | 14.99
MYR | 65.9
USD | 14.99
USD | 14.99
EUR | 19.99
USD | 14.99
USD | 9.99
USD | 14.99
USD | 14.99
USD | 14.99
[NAME] | 335
USD | 14.99
USD | 24.99
USD | 21.99
USD | 14.99
USD | 24.99
USD | 9.99
USD | 14.99
USD | 14.99
MMK | 31400
USD | 14.99
USD | 14.99
USD | 14.99
EUR | 19.99
USD | 14.99
NZD | 34.99
USD | 9.99
USD | 14.99
[NAME] | 6900
USD | 14.99
USD | 21.99
NOK | 215
USD | 21.99
PKR | 4000
USD | 14.99
USD | 9.99
USD | 14.99
USD | 9.99
PEN | 55.9
PHP | 690
USD | 21.99
USD | 21.99
PLN | 105.99
EUR | 16.99
QAR | 78.99
USD | 14.99
USD | 14.99
RON | 111.99
USD | 14.99
USD | 9.99
USD | 21.99
USD | 9.99
USD | 9.99
USD | 9.99
USD | 9.99
USD | 9.99
USD | 14.99
EUR | 19.99
USD | 14.99
SAR | 81.99
USD | 14.99
USD | 24.99
USD | 14.99
USD | 14.99
SGD | 29
USD | 9.99
EUR | 19.99
EUR | 19.99
USD | 14.99
USD | 14.99
ZAR | 389.99
USD | 21.99
KRW | 22500
USD | 14.99
EUR | 19.99
USD | 14.99
SDG | 8996
USD | 9.99
USD | 24.99
USD | 14.99
SEK | 215
CHF | 25
TWD | 450
USD | 24.99
THB | 799
USD | 14.99
USD | 20.99
USD | 14.99
USD | 9.99
USD | 14.99
TRY | 419.99
USD | 24.99
USD | 9.99
USD | 14.99
USD | 14.99
USD
AED
GBP | 19.99
TZS | 35900
USD | 9.99
USD | 24.99
USD | 14.99
EUR | 19.99
USD | 9.99
VND | 354000
USD | 21.99
USD | 14.99
USD | 14.99
YER | 3795
USD | 14.99
USD | 14.99
Spreadsheet: dutch_quigley__9291__Paribas Pos 11-30
Sheet: Sheet1

Starting | ending |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Futures | Delta | xpit | refco | give ups | efs | efs | efs | efs | efs | ryan | george | TFS EFS | efs | efs | efs | PARIBAS
1651 | -596.6521254084871 |  | -91 |  |  |  |  | -1300
-966 | 729.8052833480842 |  |  |  |  |  |  |  |  | -25
1022 | 268.639829527915 |  | -31 |  |  |  |  | -1400
-2590 | 79.33601842464344 | -300 |  |  |  |  |  | 1400 | 1300 |  |  | 200 |  |  | 100
-248 | 223.6998754285239 |  |  |  | 45 |  | 15 |  |  |  |  | 200 |  |  | 100
455 | 342.4387384085602 | -1000 |  |  |  | 102 | 15 |  |  |  | -50 | 200 |  |  | 100
-184 | 0 |  |  |  | -400 | 143 | 115 |  |  |  |  | 200 |  |  | 100
-9650 | 2.112422381704798 |  |  |  | 400 | 144 |  | 3800 |  |  | 50 | 200 |  |  | 100
-3854 | 207.8617613645993 |  | 112 |  |  | 124 | 265 |  |  | 83 |  | 200 |  |  | 100
37 | -30.87569218765297 |  | 101 |  | 41 | 131 | -334 |  |  | 50 |  | 200 |  |  | 100
92 | -376.8496778696891 |  |  |  |  | 89 | 100 |  |  | 25
122 | -335 | -122 |  |  |  | 93 |  |  |  | 25
0 | 0 |  |  |  |  | -143 | -100 |  |  |  |  | -100 | 900 | -200
3797 | 0 |  |  |  |  | -35 |  | -3800 |  |  |  | -100 | 900 | -200
-245 | 18.14062493330999 |  |  |  |  | -142 |  |  |  |  |  | -100 | 900 | -200
-538 | 0 |  |  |  |  | -44 |  |  |  |  |  | -100 | 900 | -200
-1077 | 0 |  |  |  |  | -44 |  | 1300 |  |  |  | -100 | 900 | -200
4063 | 19.96186888828024 |  |  |  |  | -44 | -100 | -3000 | -1300 | -14 |  | -100 | 900 | -200
3499 | 0 |  |  |  |  | -44 |  | -3500 |  | -20 |  | -100 | 900 | -200
0 | 0 |  |  |  |  | -44 |  |  |  |  |  | -100 | 900 | -200
-3 | 0 |  |  |  |  | -43 |  |  |  |  |  | -100 | 900 | -200
0 | 0 |  |  | 1800 |  | -44 |  | -1800 |  |  |  | -100 | 900 | -200
0 | 0 |  |  |  |  | -99 |  |  |  |  |  | -100 | 900 | -200
1090 | 0 |  |  | 1523 |  | -100 |  | -2500 |  |  |  | -100 | 900 | -200
-121 | 0
725 | 0
-29 | 0
-144 | 0
-9 | 0
0 | 0
0 | 0
1553 | 0 |  |  |  |  |  |  |  |  | -12
86 | -88.4258210225306 |  |  |  |  |  |  |  |  | -12
945 | 0
40 | 0
Spreadsheet: 761212d1640723251-need-formula-to-output-multiple-data-in-one-cell-from-workbook-copy-of-2022-reston-team-vacation-calendar
Sheet: March

 |  | 2022-02-28 00:00:00 | 2022-03-01 00:00:00 | 2022-03-02 00:00:00 | 2022-03-03 00:00:00 | 2022-03-04 00:00:00 | 2022-03-05 00:00:00
 |  | 2022-03-07 00:00:00 | 2022-03-08 00:00:00 | 2022-03-09 00:00:00 | 2022-03-10 00:00:00 | 2022-03-11 00:00:00 | 2022-03-12 00:00:00
 |  | 2022-03-14 00:00:00 | 2022-03-15 00:00:00 | 2022-03-16 00:00:00 | 2022-03-17 00:00:00 | 2022-03-18 00:00:00 | 2022-03-19 00:00:00
 |  | 2022-03-21 00:00:00 | 2022-03-22 00:00:00 | 2022-03-23 00:00:00 | 2022-03-24 00:00:00 | 2022-03-25 00:00:00 | 2022-03-26 00:00:00
 |  | 2022-03-28 00:00:00 | 2022-03-29 00:00:00 | 2022-03-30 00:00:00 | 2022-03-31 00:00:00 | 2022-04-01 00:00:00 | 2022-04-02 00:00:00
 |  | 2022-04-04 00:00:00 | Notes
Spreadsheet: 600188d1543511981-vlookup-if-formula-help-to-report-summary-of-tasks-sample-task-list-ans
Sheet: Bill

BILL
MONTHLY TASK LIST
CLIENT | TASK | DUE | PRIORITY
 |  |  |  |  | Column C format for date.
Spreadsheet: 758595d1638964870-extracting-same-cell-data-from-multiple-worksheets-variation-tracker
Sheet: Additional Works Summary Sheet

Project Name
Project Number
EOL Forecast Dated
Ref | Description of Works | Date | Quotation Value £ | Estimated Value/Achieved value  % | Estimated Value/Achieved value  £ | Add to forecast (Y) | Staff | Labour | Plant | Permanent Materials | Temporary Materials | Sub-Contractors | Overhead and Profit | Total
 |  |  |  | 0.8 |  | y
 |  |  |  | 0
TOTAL
Spreadsheet: 877884d1724828931-consolidate-data-by-row-need-help
Sheet: Sheet1

 |  |  | RESULT
name | item used |  | name | item used | item used | item used
[NAME] | mask |  | [NAME] | mask | vest | uniform
[NAME] | vest |  | [NAME] | candy | fruits
[NAME] | uniform |  | [NAME] | dress
[NAME] | candy
[NAME] | fruits
[NAME] | dress
Spreadsheet: 751227d1633981475-count-continuous-instances-and-get-max-value-from-corresponding-column-sample2
Sheet: Sheet1

No. of Days | Flow | Flow Cat | Flow category | Date | helper |  | Date | Description | FORMULAs | Variable
 | 904 | 1 | low | 2016-10-18 00:00:00 |  |  | 2015-11-19 00:00:00 | Low_No. of pulses_15 Days |  | No. of Low Pulses
 | 872 | 1 | low | 2016-10-19 00:00:00 |  |  | 2015-11-19 00:00:00 | Low_Duration of total pulses_15 Days |  | Low-Count
 | 888 | 1 | low | 2016-10-20 00:00:00 |  |  | 2015-11-19 00:00:00 | Low_Max peak discharge pulse_15 Days |  | Low-maxQtyForLow
 | 904 | 1 | low | 2016-10-21 00:00:00 |  |  | 2015-11-19 00:00:00 | Low_Duration of [NAME] continuous pulse_15 Days |  | Low-continuous count
 | 833 | 1 | low | 2016-10-22 00:00:00 |  |  | 2015-11-19 00:00:00 | Low_Max peak discharge in continuous pulse_15 Days |  | Low-maxQtyForContinuousCount
 | 818 | 1 | low | 2016-10-23 00:00:00
 | 810 | 1 | low | 2016-10-24 00:00:00 |  |  |  | Low Flow_No. of pulses_15 Days
 | 787 | 1 | low | 2016-10-25 00:00:00
 | 780 | 1 | low | 2016-10-26 00:00:00
 | 757 | 1 | low | 2016-10-27 00:00:00
 | 735 | 1 | low | 2016-10-28 00:00:00
 | 735 | 1 | low | 2016-10-29 00:00:00
 | 735 | 1 | low | 2016-10-30 00:00:00
 | 61600 | 4 | large | 2015-10-31 00:00:00
 | 57700 | 4 | large | 2015-11-01 00:00:00
 | 10700 | 4 | large | 2015-11-02 00:00:00
 | 4070 | 4 | large | 2015-11-03 00:00:00
1 | 2640 | 4 | large | 2015-11-04 00:00:00
2 | 2220 | 4 | large | 2015-11-05 00:00:00
3 | 2260 | 4 | large | 2015-11-06 00:00:00
4 | 2040 | 1 | low | 2015-11-07 00:00:00
5 | 2060 | 1 | low | 2015-11-08 00:00:00
6 | 1930 | 1 | low | 2015-11-09 00:00:00
7 | 1330 | 1 | low | 2015-11-10 00:00:00
8 | 1150 | 1 | low | 2015-11-11 00:00:00
9 | 1020 | 1 | low | 2015-11-12 00:00:00
10 | 936 | 1 | low | 2015-11-13 00:00:00
11 | 841 | 1 | low | 2015-11-14 00:00:00
12 | 772 | 1 | low | 2015-11-15 00:00:00
13 | 735 | 1 | low | 2015-11-16 00:00:00
14 | 904 | 1 | low | 2015-11-17 00:00:00
15 | 1900 | 1 | low | 2015-11-18 00:00:00
 | 1550 | 1 | low | 2015-11-19 00:00:00
Spreadsheet: fa9bbb7c-f59b-470b-8551-89b8066cee57
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
FSMA | Test | FSMA | Spinal Muscular Atrophy Diagnostic Test | SMA Evaluation | [NAME], ddCt Method | EDTA (lavender-top) tube: EDTA OR Yellow-Top (ACD) Tube: ACD OR |  |  | 4 | mL | Draw 4 mL whole blood in a lavender-top (EDTA) or yellow-top (ACD) tube. Ship refrigerate. | 2 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | Testing is complete. Report has been attached in MayoAccess.   Test Performed by: Athena Diagnostics                              377 Plantation Street                              Four Biotech Park                              Worcester, MA 01605 | Upon Receipt | 7 days | 9 - 11 days | 1 | 81401 |  |  |  |  | Athena Diagnostics
FSMA | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Refrigerated | 14 days
FSMA | Result | Z0100 | SMA Evaluation | SMA Evaluation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 685009d1593666167-formula-to-copy-certain-criteria-to-another-worksheet-rr_06_26_20-1-2-
Sheet: container cases

 |  |  |  | Greg | Larrel | [NAME] | [NAME] | Sharlya | [NAME] |  | total
 |  | 2020-06-24 00:00:00 |  | 2 | 0 | 0 | 4 | 0 |  |  | 6
 |  | Z+AA |  | TS003858842 |  |  | TS003855368 |  | TS003858781
 |  |  |  | Greg | Larrel | [NAME] | [NAME] | Sharlya | [NAME]
 |  |  |  | 2 | 0 | 0 | 4 | 0 | 0
 |  | AD+AE |  | TS003863246
 |  |  |  | Greg | Larrel | [NAME] | [NAME] | Sharlya | [NAME]
 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  | AH+AI |  |  |  |  | TS003868552
Spreadsheet: 256673be-e9b4-4c4d-840d-6b369202b252
Sheet: Sheet1

Title | Creator/Author | Publication Date | OSTI Identifier | Report Number(s) | DOE Contract Number | Other Number(s) | Resource Type | Specific Type | Resource Relation | Research Org. | Sponsoring Org. | Subject | Related Subject | Description/Abstract | Contributor Organizations | Host Website | Format | Availability | DOI | Full Text
SmartGrid:  Quarterly Data Summaries from the Data Hub and SmartGrid Project Information (from OpenEI and SmartGrid.gov) |  |  | 1088044 |  |  |  | Collection | Interactive Data Map(s); Numeric Data |  |  | USDOE Office of Electricity Delivery and Energy Reliability (OE) | 29 ENERGY PLANNING, POLICY, AND ECONOMY; 24 POWER TRANSMISSION AND [NAME] | Metrics | Both OpenEI and SmartGrid.gov are DOE portals to a wealth of information about the federal initiatives that support the development of the technologies, policies and projects transforming the electric power industry.  Projects funded through the U.S. Recovery Act are organized by type and pinned to an interactive map at http://en.openei.org/wiki/Gateway:Smart_Grid.  Each project title links to more detailed information.  The Quarterly Data Summaries from the Data Hub at SmartGrid.gov are also available on OpenEI at http://en.openei.org/datasets/node/928.  In addition, the SmartGrid Information Center contains documents and reports that can be searched or browsed.  Smart Grid Resources introduces international SmartGrid programs and sites, while OpenEI encourages users to add SmartGrid information to the repository. |  | Open Energy Information (OpenEI) |  |  |  | http://www.osti.gov/dataexplorer/servlets/purl/1088044
Spreadsheet: 92247d1291866209-delivering-data-based-on-a-table-copy-of-disk2010
Sheet: Values

XBH | Sevens | Value
1 | 1 | 1
2 | 1 | 5
2 | 2 | 10
2 | 3 | 20
2 | 4 | 30
2 | 5 | 40
2 | 6 | 50
2 | 7 | 60
2 | 0 | 5
3 | 0 | 10
3 | 1 | 15
3 | 2 | 25
3 | 3 | 35
3 | 4 | 45
3 | 5 | 55
3 | 6 | 65
4 | 0 | 20
4 | 1 | 30
4 | 2 | 40
4 | 3 | 50
4 | 4 | 60
4 | 5 | 70
5 | 0 | 35
5 | 1 | 45
5 | 2 | 55
5 | 3 | 65
5 | 4 | 75
Spreadsheet: eric_saibi__9944__110101R
Sheet: Garrison 04

Owner Name |  | U S Army Corps of Engineers
Station Name |  | Garrison Hydro Power Station
Unit Name |  | [NAME] 04
NERC Region |  | MAPP
State |  | ND
Fuel Type |  | Hydro
Capacity |  | 109 MW
Start Date |  | 2001-11-05 00:00:00
End Date |  | 2002-11-25 00:00:00
Prv. Start Date |  | 2001-11-01 00:00:00
Prv. End Date |  | 2002-11-25 00:00:00
Comments |  | Finishing up on # 5 Rewind/ Replacement
SIC |  | 4911
Plant ID |  | 1027978
Unit ID |  | 1007301
Outage ID |  | 1244
Spreadsheet: 849797d1700180755-ifs-or-if-and-statement-for-multiple-conditions-book4
Sheet: Sheet1

 |  |  | Salaries | 80000 | 75000 | 72500
District | Location | Department | Headcount | Employee1 | Employee2 | Employee3 |  | Employee1 | Employee2 | Employee3
Boise | BOISE | Body Shop | 6 |  |  |  |  | Boise | Elko | Las Vegas
Boise | BOISE | NewTrucks | 1 |  |  |  |  | Caldwell | [NAME] | Salina
Boise | CALDWELL | Parts | 6 |  |  |  |  | Ontario | [NAME] | Vernal
Boise | CALDWELL | Service | 3 |  |  |  |  | Pocatello | Idaho Falls | Price
Boise | ONTARIO | Parts | 7
Boise | ONTARIO | Service | 25
[NAME] | ELKO | Parts | 22
[NAME] | ELKO | Service | 3
[NAME] | HEYBURN | Parts | 22
[NAME] | HEYBURN | Service | 28
[NAME] | JEROME | Body Shop | 6
[NAME] | JEROME | NewTrucks | 12
[NAME] | JEROME | Parts | 7
[NAME] | JEROME | Service | 5
[NAME] | JEROME | UsedTrucks | 6
Las Vegas | LASVEGAS | Parts | 7
Las Vegas | LASVEGAS | Service | 4
Las Vegas | LASVEGAS | UsedTrucks | 1
Las Vegas | SALINA | Parts | 3
Las Vegas | SALINA | Service | 16
Las Vegas | SALINA | Body Shop | 4
Spreadsheet: 197799d1354562228-numbers-are-disappearing-when-linking-to-another-worksheet-workbook130
Sheet: REPARTEE B

5 | 1.722222222222222
11 | 2.055555555555556
13 | 2.916666666666667
17 | 2.777777777777778
19 | 3.333333333333333
21 | 2.5
23 | 3.75
27 | 5
29 | 2.055555555555556
31 | 2.222222222222222
33 | 5
39
43 | 2.5
45 | 3.333333333333333
47 | 2.777777777777778
49 | 2.5
51 | 2.5
53 | 5
57 | 3.75
59 | 1.944444444444445
71 | 3.333333333333333
75 | 7.5
Spreadsheet: 94305d1294158146-commission-report-incorporating-accelerator-calculations-commission-example
Sheet: Sheet1

 |  |  |  | Rev YTD | GP Quota | GP Achieved to Date | YTD % of Quota Achieved |  | Current Commission Rate | Comm. Earned up to 100% | Comm. Earned with 1st Accelerator | Earned with 2nd Accelerator | Earned with 3rd Acc |  | comm rate |  |  |  | rate times this  accel
 |  |  |  | 13047506.8715 | 10500000 | 6871118.886348347 | 0.6543922748903188 |  | 0.01381 |  |  |  |  |  | 0.01381 | 1 | 100 | 120 | 1.5 | 120 | 99999999 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 1427688.245 | 900000 | 791672.4942000001 | 0.8796361046666668 |  | 0.09667 |  |  |  |  |  | 0.09667 | 1 | 100 | 110 | 1.1 | 110 | 120 | 1.2 | 120 | 130 | 1.5 | 130 | 140 | 1.75 | 140 | 150 | 2 | 150 | 99999999
 |  |  |  | 695153.3554 | 850000 | 366018.7683499999 | 0.4306103157058823 |  | 0.08471 |  |  |  |  |  | 0.08471 | 1 | 100 | 110 | 1.1 | 110 | 120 | 1.2 | 120 | 130 | 1.5 | 130 | 140 | 1.75 | 140 | 150 | 2 | 150 | 99999999
 |  |  |  | 0 | 850000 | 0 | 0 |  | 0
 |  |  |  | 651207.0099999999 | 800000 | 275205.1768 | 0.344006471 |  | 0.09 |  |  |  |  |  | 0.09 | 1 | 100 | 110 | 1.1 | 110 | 120 | 1.2 | 120 | 130 | 1.5 | 130 | 140 | 1.75 | 140 | 150 | 2 | 150 | 99999999
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | For the 1st REP (row 2) from 100% to 120% GP, Rep makes 1.5 times 1.381% (2.072%)on GP, what formulas should I use with the yellow cells?
Spreadsheet: craig_dean__4381__MDEA P&L Report
Sheet: May8

Profit Sharing Summary
Operation Day: |  | 2001-05-08 00:00:00
 |  | 2001-05-09 00:00:00 |  | Gen Cost Reference |  |  | Gross Savings |  | Net Share of Savings (Per Agreement) |  |  |  | Costs by each party |  |  |  |  | Net Profit/Savings Summary
 | Day-Ahead Transactions |  |  |  |  |  | MDEA Gross Savings | MDEA Gross Savings | EPMI Share | MDEA Share | EPMI Share | MDEA Share | Per Mwh |  | Cost * Mwh
 |  |  |  | Day-Ahead | Day-Ahead | Day-Ahead Gen | (BEFORE EPMI Share) | (BEFORE EPMI Share) | 40% Pk,$1 OffPk | 60% Share Pk* | 40% Share Pk | 60% Share Pk |  |  |  | (EPMI to bill MDEA) |  | EPMI | MDEA
Date | Hour | Qty | Delivered Market Price | Gas Cdale | Gas Yazoo City | Gen Cost | [NAME] vs. [NAME] (per Mwh) | Per Mwh Savings * Mwhs | Per Mwh | Per Mwh | Per Mwh Savings * Mwhs | Per Mwh Savings * Mwhs | EPMI | MDEA | EPMI | MDEA |  | (Profit) | (Savings)
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | match value
 |  |  |  | Gen Cost Reference |  |  | Gross Savings |  | Net Share of Savings (Per Agreement) |  |  |  | Costs by each party |  |  |  |  | Net Profit/Savings Summary
 | Real-Time Transactions |  |  |  |  |  | MDEA Gross Savings | MDEA Gross Savings | EPMI Share | MDEA Share | EPMI Share | MDEA Share | Per Mwh |  | Cost * Mwh
 |  |  |  | Day-Ahead | Day-Ahead | Day-Ahead Gen | (BEFORE EPMI Share) | (BEFORE EPMI Share) | 40% Pk,$1 OffPk | 60% Share Pk* | 40% Share Pk | 60% Share Pk |  |  |  | (EPMI to bill MDEA) |  | EPMI | MDEA
Date | Hour | Qty | Delivered Market Price | Gas Cdale | Gas Yazoo City | Gen Cost | [NAME] vs. [NAME] (per Mwh) | Per Mwh Savings * Mwhs | Per Mwh | Per Mwh | Per Mwh Savings * Mwhs | Per Mwh Savings * Mwhs | EPMI | MDEA | EPMI | MDEA |  | (Profit) | (Savings)
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | match value
Spreadsheet: 745158d1629788904-conditional-format-highlight-delivery-dates-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | 2021-08-01 00:00:00 |  | 2021-09-01 00:00:00 |  | 2021-10-01 00:00:00
Stock Code | Name | SOH | Forecast | Demand | Usage MTD | 3mth Ave. | mth LY 3 months | Supply Months | Date Cover | Delivery |  | Delivery |  | Delivery
GP001B | A1000 | 16.384 | 11.485 |  | 12.102 | 13.138 | 14.843 | 1.2 | 2021-09-05 00:00:00 | 21.6 | 2021-08-30 00:00:00 | 21.6 | 2021-09-18 00:00:00 | 21.6 | 2021-10-30 00:00:00
GP001C | [NAME] | 3.855 | 2.61 |  | 3.475 | 3.666 | 2.838 | 1.1 | 2021-09-24 00:00:00 |  |  | 5 | 2021-09-06 00:00:00
GP001D | [NAME] | 0.02 | 0.088 |  | 0.12 | 0.153 | 0.093 | 0.1 | 2021-08-27 00:00:00 | 1.6 | 2021-08-23 00:00:00
I am trying to figure out how i can use conditional formatting to highlight if a delivery date in column L,N & P is within 7 days of Column J.
If it is not then it would highlight column J cell. I have tried to use a custom formula but cant get it to work.
Example sheet attached. So in this example, [NAME] would be highlighted as cell L5 is only 4 days before cell J5. Anything more than 7 days will not be highlighted
Spreadsheet: 774205d1648300059-if-and-statements-budget-for-retirement-ver-2-updated-3-26-2022
Sheet: Tax Calc

Drop Down List For Frequency Colunm | Tax Calculation Table | GROSS | GROSS YEARLY | 10% RATE | 12% RATE | 22.14% RATE | 0.24% RATE | Social Security Funds | NET | NET | NET AFTER |  | NET YEARLY |  |  | NET MONTHLY
 |  | MONTHLY | SOCIAL SECURITY | 0.00 ---> $10,276. | $10,276. ---> $41,775. | $41,775 ---> $89075 | $89075 ---> |  | YEARLY | MONTHLY | MEDICARE |  | Person #1                  10% Rate |  |  | Person #1                  10% Rate
 |  | SS |  | AMOUNT OF TAX TO BE PAID BASED ON RATES |  |  |  |  |  |  | DEDUCTIONS |  | Person #1                  12% Rate |  |  | Person #1                  12% Rate
Select From List | Person #1 B4 Tax on SS |  |  |  |  |  |  | AFTER TAX ---> | 21293.6 |  |  |  | Person #1                  22.14% Rate |  |  | Person #1                  22.14% Rate
 | Person #2 B4 Tax on SS |  |  |  |  |  |  | AFTER TAX ---> | 0 |  |  |  | Person #1                  24% Rate |  |  | Person #1                  24% Rate
Weekly | Other Income #1 |  |  |  |  |  |  |  |  |  |  |  | = NULL | 0 |  | = NULL | 0
Monthly | Other Income #2
Annually
 |  |  |  |  |  |  |  |  |  |  |  |  | NET YRLY
 |  |  |  |  |  |  |  |  |  |  |  |  | Person #2                  10% Rate |  |  | Person #2                  10% Rate
 |  |  |  |  |  |  |  |  |  |  |  |  | Person #2                  12% Rate |  |  | Person #2                  12% Rate
 |  |  |  |  |  |  |  |  |  |  |  |  | Person #2                  22.14% Rate |  |  | Person #2                  22.14% Rate
 |  |  |  |  |  |  |  |  |  |  |  |  | Person #2                  24% Rate |  |  | Person #2                  24% Rate
 |  |  |  |  |  |  |  |  |  |  |  |  | = NULL | 0 |  | = NULL | 0
Spreadsheet: jeff_dasovich__14062__PEP_OAT_KO financials and ratios
Sheet: Pepsi Financials

Balance Sheet Statement ($ [NAME])
Fiscal Year End | 36861 | 36495 | 36130 | 35765
Assets
Cash & Equivalent | 864 | 964 | 311 | 1928
Receivables | 1799 | 1704 | 2453 | 2150
Inventories | 905 | 899 | 1016 | 732
Other Cur Assets | 1036 | 606 | 582 | 1441
Total Cur Assets | 4604 | 4173 | 4362 | 6251
Gr Fixed Assets | 9539 | 11058 | 13110 | 11294
Accum Depr & Depl | 4101 | 5792 | 5792 | 5033
Net Fixed Assets | 5438 | 5266 | 7318 | 6261
Intangibles | 4485 | 4735 | 8996 | 5855
Oth Non-Cur Asset | 3812 | 3377 | 1984 | 1734
Tot Non-Cur Asset | 13735 | 13378 | 18298 | 13850
Total Assets | 18339 | 17551 | 22660 | 20101
Liabilities
Accounts Payable | 3815 | 3399 | 3870 | 3617
Short-Term Debt | 72 | 233 | 3921 | 0
Other Cur Liab | 48 | 156 | 123 | 640
Total [NAME] | 3935 | 3788 | 7914 | 4257
Long-Term Debt | 2346 | 2812 | 4028 | 4946
Defer Inc Taxes | 1361 | 1209 | 2003 | 1697
[NAME] | 3448 | 2861 | 2314 | 2265
Minority Interest | 0 | 0 | 0 | 0
[NAME] | 7155 | 6882 | 8345 | 8908
Total Liabilities | 11090 | 10670 | 16259 | 13165
Preferred Equity | 0 | 0 | 0 | 0
Common Equity | 7249 | 6881 | 6401 | 6936
[NAME] | 15448 | 14066 | 12800 | 11567
Total Equity | 7249 | 6881 | 6401 | 6936
Tot Liab & Stk Eq | 18339 | 17551 | 22660 | 20101
Income Statement ($ [NAME])
Fiscal Year End | 2000-12-01 00:00:00 | 1999-12-01 00:00:00 | 1998-12-01 00:00:00 | 1997-12-01 00:00:00
Revenues/Sales | 20438 | 20367 | 22348 | 20917
Cost of Sales | 7121 | 7349 | 8318 | 7618
Gr Oper Profit | 13317 | 13018 | 14030 | 13299
S, G & A Expenses | 9132 | 9103 | 9924 | 9241
Other Taxes | 0 | 0 | 0 | 0
[NAME] bef [NAME] | 4185 | 3915 | 4106 | 4058
Deprec & Amort | 960 | 1032 | 1234 | 1106
Oper Inc aft Depr | 3225 | 2883 | 2872 | 2952
Other Income, Net | 206 | 1201 | 74 | 125
[NAME] for Int | 3431 | 4019 | 2658 | 2787
Interest Expense | 221 | 363 | 395 | 478
Minority Interest | 0 | 0 | 0 | 0
Pretax Income | 3210 | 3656 | 2263 | 2309
Income Taxes | 1027 | 1606 | 270 | 818
Net Inc Cont Ops | 2183 | 2050 | 1993 | 1491
Net Inc Disc Ops | 0 | 0 | 0 | 651
Net Inc Tot Ops | 2183 | 2050 | 1993 | 2142
Special Inc/Chrg | 0 | -65 | -288 | -290
Normalized Income | 2183 | 2115 | 2281 | 1781
Extra Inc (Loss) | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0
Inc Tax Loss Cfwd | 0 | 0 | 0 | 0
[NAME] (Loss) | 0 | 0 | 0 | 0
Total Net Income | 2183 | 2050 | 1993 | 2142
Preferred Div | 0 | 0 | 0 | 0
Net Inc Avail Com | 2183 | 2050 | 1993 | 1491
Spreadsheet: ec88d62f-7cb8-41d5-a10b-2e0b68f613f6
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4340 | 10334 | [NAME] | Smyers | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:00:00