tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2c06cd12-4dba-45ba-a6f9-f0c942f253f5
Sheet: Page 1

Permit No.: |  |  | WQ0024320 |  |  | Facility Name: |  | Rockbridge Subdivision |  |  |  |  |  | County: | Wake |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 1 |  | Field Name: |  | 2A |  | Field Name: |  | 2B-1 |  | Field Name: |  | 2B-2
 |  |  |  |  |  | Area (acres): |  | 5.14 |  | Area (acres): |  | 3.58 |  | Area (acres): |  | 0.53 |  | Area (acres): |  | 0.32
 |  |  |  |  |  | Cover Crop: |  | Fescue |  | Cover Crop: |  | Fescue |  | Cover Crop: |  | Fescue |  | Cover Crop: |  | Fescue
 |  |  |  |  |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3
 |  |  |  |  |  | Annual Rate (in): |  | 48.7 |  | Annual Rate (in): |  | 48.7 |  | Annual Rate (in): |  | 37.3 |  | Annual Rate (in): |  | 37.3
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 197622d1354493222-array-problem-non-array-version-with-index-not-offset
Sheet: Lists

 | [NAME] |  | [NAME]
 | [NAME] |  | Fran |  | Enter guest names in column B
 | Cam |  | [NAME] |  | Columns C and D contain formulas
 | [NAME] |  | Herb
 | [NAME] | 5 | [NAME]
 | Fran | 6 | [NAME]
 | [NAME] | 7 | [NAME]
 | Herb | 8 | [NAME]
 | Ian |  | [NAME]
 | [NAME] | 10 | Ona
 | [NAME] | 11 | Pia
 | [NAME] | 12 | Quinn
 | [NAME] | 13 | [NAME]
 | [NAME] | 14 | Sue
 | Ona | 15 | [NAME]
 | Pia | 16 | Una
 | Quinn | 17 | Val
 | [NAME] | 18 | [NAME]
 | Sue | 19 | [NAME]
 | [NAME] | 20 | [NAME]
 | Una | 21 | [NAME]
 | Val | 22 | [NAME]
 | [NAME] | 23 | [NAME]
 | [NAME] | 24 | [NAME]
 | [NAME] | 25 | martin
 | [NAME] | 26 | qqq
 | [NAME] | 27 | qqq
 | [NAME] |  | qqq
 | [NAME] | 29 | qqq
 | [NAME] | 30 | qqq
 | [NAME] |  | qqq
 | martin | 32 | qqq
Spreadsheet: b622c7e1-0994-428b-b3db-0e8e0b41f70a
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
VDER | Test | VDER | Herpes Simplex Virus (HSV) and Varicella-Zoster Virus ([NAME]), Molecular Detection, PCR, Dermal | HSV and VZV PCR, Dermal | Detection of HSV and VZV by LightCycler Polymerase Chain Reaction (PCR) (PCR is utilized pursuant to a license agreement with Roche Molecular System, Inc.) This test distinguishes HSV-1 from HSV-2 genotypes. | Culture transport swab: CUTS |  |  |  | Varies | Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen.  [NAME] source is required.   Submit only 1 of the following specimens:   Preferred: [NAME] Sources: Preferred: Lesion and dermal specimen Acceptable: Anal/rectal, genital, eye/ocular, urethral Container/Tube: Culture transport swab [NAME] Volume: Swab Collection Instructions: Place swab back into swab cylinder.   Acceptable: [NAME] fluid Container/Tube: Amniotic fluid container [NAME]: 0.5 mL   Specimen Type: Body fluid or spinal fluid Container/Tube: Sterile container [NAME]: 0.5 mL   Specimen Type: Respiratory specimen (upper/lower) Container/Tube: Sterile container [NAME]: 1 mL   Specimen Type: Tissue Container/Tube: Sterile container [NAME]: Entire collection Collection Instructions: Collect fresh tissue specimen. |  | Hemolysis	NA Thawing	Warm OK; Cold OK  Lipemia	NA Icterus	NA Other	Calcium alginate-tipped swab, wood swab, transport swab containing gel | Not applicable | Monday through Sunday | 1 day | 3 days |  | Profile |  |  |  |  | Rochester
VDER | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
VDER | Order Question | SRC75 | [NAME] |  | Plain Text
VDER | Result | SRC75 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
VDER | Result | 82048 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33027-4
VDER | Result | 21085 | Special Information | Special Information | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48767-8
VDER | Result | 21086 | Report Status | Report Status | Alphanumeric
VDER | Billing Component | VDER |  | Varicella-Zoster by PCR |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 87798
VDER | Billing Component | VDER |  | Herpes Simplex Virus |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 87529
Spreadsheet: 816036d1675330500-multiple-lookup-and-transpose-data-lookup-and-transpose-1-
Sheet: Sheet1

 |  | Column1 | Column2 |  | 1 | 9 | 1 | 2 | 3 | 4
 |  | 1 | 9 |  | 2 | 2 | 1 | 3 | 7
 |  | 1 | 1 |  | 3 | 6 | 8 | 9 | 3
 |  | 1 | 2
 |  | 1 | 3
 |  | 1 | 4
 |  | 2 | 2
 |  | 2 | 1
 |  | 2 | 3
 |  | 2 | 7 |  | Column1 | [NAME] | Custom.2 | Custom.3 | Custom.4 | Custom.5
 |  | 3 | 6 |  | 1 | 9 | 1 | 2 | 3 | 4
 |  | 3 | 8 |  | 2 | 2 | 1 | 3 | 7
 |  | 3 | 9 |  | 3 | 6 | 8 | 9 | 3
 |  | 3 | 3
Spreadsheet: 471347d1468962466-assigning-incremental-values-within-a-range-of-data-with-same-ids-if-a-criteria-is-met-countifs-restart-with-id
Sheet: Sheet1

ID | Decision | Count | [NAME]
1 | CAD | 0
1 | PFA | 1
1 | RCA | 0
1 | PFR | 2
1 | PCF | 0
1 | PFR | 3
1 | PCF | 0
2 | CAD | 0
2 | PFA | 1
2 | PCF | 0
2 | PCV | 0
2 | RCA | 0
2 | PFR | 2
2 | PCV | 0
2 | PCV | 0
2 | PFR | 3
2 | PBI | 0
2 | SIN | 0
2 | PFR | 4
Spreadsheet: 690416d1597089229-finding-min-and-max-values-corresponding-values-in-adjacent-cell-in-subsets-of-dataset-2020-08-10-oeldere-jnw_2020690412d1597087801-finding-min-and-max-values-correponding-values-i
Sheet: PT

 | Kolomlabels
 | 07 |  | 08
Rijlabels | [NAME] | Min van Level2 | [NAME] | Min van Level2
:00 |  |  | 317.495236665076 | 316.6301157373221
:15 |  |  | 317.6735763641156 | 317.4879482700015
:30 | 316.4121985334342 | 316.38629956925
:45 | 316.5710853910216 | 316.3677945194755
Spreadsheet: 135796d1326234051-lookup-unsorted-data-unsorted-lookup-table
Sheet: Sheet1

x | y | z |  | [NAME] | [NAME] | [NAME] |  | xy load | xz load | yz load |  |  |  | x | y | z | Magnitude
10 | 8 | 5 |  | 0 | 0 | 0 |  |  |  |  |  |  | XZ Load
5 | 5 | 3 |  | 0 | 0 | 0 |  |  |  |  |  |  | xy load
14 | 6 | 8 |  | 0 | 0 | 0 |  |  |  |  |  |  | yz load
7 | 2 | 4 |  | 0 | 0 | 0
3 | 23 | 6 |  | 0 | 0 | 0
6 | 3 | 4 |  | 0 | 0 | 0
Spreadsheet: 740071d1626173124-avoid-circular-reference-in-lookup-example-1-
Sheet: Sheet1

Date | ID | Received? |  | Desire result: if any ID is received for a given date, then mark them all as YES
2021-07-02 00:00:00 | 1
2021-07-02 00:00:00 | 2
2021-07-02 00:00:00 | 3
2021-07-02 00:00:00 | 4
2021-07-02 00:00:00 | 5
2021-07-02 00:00:00 | 6
2021-07-02 00:00:00 | 7
2021-07-02 00:00:00 | 8
2021-07-02 00:00:00 | 9
2021-07-09 00:00:00 | 1
2021-07-09 00:00:00 | 2
2021-07-09 00:00:00 | 3
2021-07-09 00:00:00 | 4
2021-07-09 00:00:00 | 5
2021-07-09 00:00:00 | 6
2021-07-09 00:00:00 | 7
2021-07-09 00:00:00 | 8
2021-07-09 00:00:00 | 9
2021-07-09 00:00:00 | 10
2021-07-09 00:00:00 | 11
Spreadsheet: 58095d1258408116-compare-and-sum-totals-between-worksheets-inv_ttl
Sheet: System

Part ID | Description | On Hand
1000116 | Velcro Belt Xsmall | 15
1000117 | Velcro Belt Small | 7
1000118 | Velcro Belt Medium | 9
1000118 | Velcro Belt Medium | 0
1000119 | Velcro Belt Large | 20
1000120 | Velcro Belt Xlarge | 23
1000121 | Velcro Belt XX Large | 6
1000122 | Velcro Belt XXX Large | 7
1000123 | Velcro Belt XXXX Large | 7
 | Computer system says we have these in stock
Spreadsheet: 66554d1267193240-lookup-on-multiple-entries-chemistification-customer-load-analysis
Sheet: Using Pivot Table

Count of Cycle |  | Cycle
date | loc code | 8 | (blank) | Grand Total
2010-02-24 00:00:00 | WR1011 | 1 |  | 1
24-Feb Total |  | 1 |  | 1
2010-02-25 00:00:00 | WR1011 | 2 |  | 2
25-Feb Total |  | 2 |  | 2
(blank) | (blank)
(blank) Total
Grand Total |  | 3 |  | 3
Spreadsheet: 164178d1340676211-trouble-in-separating-data-sample-data
Sheet: Sheet1

name | pickup date
alice | 2012-01-03 00:00:00
barney | 2012-01-03 00:00:00
hector | 2012-01-04 00:00:00
alice | 2012-01-05 00:00:00
[NAME] | 2012-01-06 00:00:00
eugene | 2012-01-07 00:00:00
barney | 2012-01-07 00:00:00
ian | 2012-01-09 00:00:00
alice | 2012-01-10 00:00:00
eugene | 2012-01-11 00:00:00
dean | 2012-01-11 00:00:00
barney | 2012-01-11 00:00:00
Spreadsheet: 851836d1701964650-add-the-lowest-of-the-rows-addlowestofrows
Sheet: Sheet1

 |  |  | Supllier 1 | Supplier 2 | Supplier 3 | Supplier 4
 |  | Item 1
 |  | Item 2
 |  | Item 3
 |  | Item 4
 |  | Item 5
 |  | Item 6
 |  | Item 7
 |  | Item 8
 |  | Item 9
 |  | Item 10
 |  | Item 11
 |  | Item 12
 |  | Item 13 |  |  |  | 6.5
 |  | Item 14 |  |  |  | 40.3
 |  | Item 15 |  |  |  | 4.32
 |  | Item 16
 |  | Item 17
 |  | Item 18
 |  | Item 19
 |  | Item 20
 |  | Sum Of Lowest
Spreadsheet: 371768d1421817621-how-to-count-consecutive-dates-for-each-employee-from-a-listing-of-absence-dates-how-to-count-consecutive-dates-for-each-employee-from-a-listing-of-absence-dates-book1
Sheet: Sheet1

Leaves List by Employee
Employee: | Employee ID | Start | End |  |  |  |  |  | Is a period | #periods
[NAME] | 11111 | 2014-06-16 00:00:00 | 2014-06-16 00:00:00
[NAME] | 11111 | 2014-06-17 00:00:00 | 2014-06-17 00:00:00
[NAME] | 22222 | 2014-04-04 00:00:00 | 2014-04-04 00:00:00
[NAME] | 22222 | 2014-04-05 00:00:00 | 2014-04-05 00:00:00
[NAME] | 22222 | 2014-04-06 00:00:00 | 2014-04-06 00:00:00
[NAME] | 22222 | 2014-05-02 00:00:00 | 2014-05-02 00:00:00
[NAME] | 33333 | 2014-04-04 00:00:00 | 2014-04-04 00:00:00
[NAME] | 33333 | 2014-04-05 00:00:00 | 2014-04-05 00:00:00
[NAME] | 33333 | 2014-04-06 00:00:00 | 2014-04-06 00:00:00
[NAME] | 33333 | 2014-04-07 00:00:00 | 2014-04-07 00:00:00
[NAME] | 33333 | 2014-04-11 00:00:00 | 2014-04-11 00:00:00
[NAME] | 33333 | 2014-04-12 00:00:00 | 2014-04-12 00:00:00
[NAME] | 33333 | 2014-04-13 00:00:00 | 2014-04-13 00:00:00
[NAME] | 33333 | 2014-04-14 00:00:00 | 2014-04-14 00:00:00
DJ | 44444 | 2014-12-12 00:00:00 | 2014-12-12 00:00:00
DJ | 44444 | 2014-12-13 00:00:00 | 2014-12-13 00:00:00
DJ | 44444 | 2014-12-14 00:00:00 | 2014-12-14 00:00:00
Spreadsheet: 858276d1707010739-find-exact-match-in-two-worksheets-and-highlight-the-exact-match-in-worksheet1-exact-match-highlight
Sheet: Sheet1

10
12
11
9
8
7
6
5
22
34
12
43
Spreadsheet: 746122d1630514303-vlookup-depending-on-cell-value-example-workbook
Sheet: Targets

Product # | 2021 Target
M162500 | 18.64
01103VPD | 2.97
8313AWBGR | 3.28
8325AWBBG | 1.23
AWES3 | 3.2
FWMLES3 | 1.03
HFINS5PK | 1.92
HFINS5PKGRINAGER | 2
HFINS5PRUPDQE | 5.25
HH11PDQGRAINGER | 2.94
HM07019VP | 2.94
TW10PK48BON-U | 2.94
[NAME] | 12.08
M161900 | 50.4
M161920 | 9.8
M161930 | 6.04
M1621100 | 11.9
Spreadsheet: 859286d1707732158-conference-room-calendar-untitled-spreadsheettest-version-3-
Sheet: Calendar

 | 2024-02-01 00:00:00
 | Sunday |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 |  |  |  |  |  | 2024-02-01 00:00:00 | 2024-02-02 00:00:00 | 3
 | 4 |  | 2024-02-05 00:00:00 | 2024-02-06 00:00:00 | 2024-02-07 00:00:00 | 2024-02-08 00:00:00 | 2024-02-09 00:00:00 | 10
 |  |  |  |  | •  12:00AM to 12:00AM - | • R1 02:00PM to 03:00PM - CVSP MEETING WITH THE POD
 |  |  |  |  | •  12:00AM to 12:00AM -
 |  |  |  |  | •  12:00AM to 12:00AM -
 |  |  |  |  | •  12:00AM to 12:00AM -
 | 11 |  | 2024-02-12 00:00:00 | 1900-01-13 00:00:00 | 1900-01-14 00:00:00 | 2024-02-15 00:00:00 | 2024-02-16 00:00:00 | 17
 | 18 |  | 1900-01-19 00:00:00 | 1900-01-20 00:00:00 | 1900-01-21 00:00:00 | 1900-01-22 00:00:00 | 1900-01-23 00:00:00 | 24
 | 25 |  | 1900-01-26 00:00:00 | 1900-01-27 00:00:00 | 1900-01-28 00:00:00 | 1900-01-29 00:00:00
 | As of
Spreadsheet: 884576d1733816013-calculating-wage-salary-increase-dexter2-efsalary-365-aligw
Sheet: Sheet1

 |  |  |  |  |  | 0.025 |  | 17.85
 |  |  |  |  |  | 0.025 |  | 18.3
 |  |  |  |  |  | 0.025 |  | 18.76
 |  |  |  |  |  | 0.025 |  | 19.23
 |  |  |  |  |  | 0.025 |  | 19.72
 |  |  |  |  |  | 0.03 |  | 20.32
 |  |  |  |  |  | 0.03 |  | 20.93
 |  |  |  |  |  | 0.035 |  | 21.67
 |  |  |  |  |  | 0.02 |  | 22.11
 |  |  |  |  |  | 0.01 |  | 22.34
 |  |  |  |  |  | 0.035 |  | 23.14
 |  |  |  |  |  | 0.015 |  | 23.49
 |  |  |  |  |  | 0.015 |  | 23.84
 |  |  |  |  |  | 0.015 |  | 24.2
 |  |  |  |  |  | 0.02 |  | 24.69
 |  |  |  |  |  | 0.03 |  | 25.45
 |  |  |  |  |  | 0.03 |  | 26.21
 |  |  |  |  |  | 0.03 |  | 27
 |  |  |  |  |  | 0.05 |  | 28.35
 |  |  |  |  |  | 0 |  | 28.35
 |  |  |  |  |  | 0.06 |  | 30.05
 |  |  |  |  |  | 0.0325 |  | 31.03
 |  |  |  |  |  | 0.03 |  | 31.96
 |  |  |  |  |  | 0.03 |  | 32.92
Spreadsheet: 887362d1737598577-due-dates-formula-for-month-end-close-calendar-month-end-close-due-dates-bvj-
Sheet: Feb Close Schedule

 | 2025 | SUN | MON | TUE | WED | THU | FRI | SAT
 |  |  |  |  |  |  |  | 2025-02-01 00:00:00
 | FEB
 |  |  | DAY 1 | DAY 2 | DAY 3 | DAY 4 | DAY 5
 |  |  | DAY 6 | DAY 7 | DAY 8 | DAY 9 | DAY 10
 |  |  |  | DAY 11 | DAY 12 | DAY 13 | DAY 14
 |  |  | Holiday
 |  |  | DAY 15 | DAY 16 | DAY 17 | DAY 18 | DAY 19
Spreadsheet: 7d7f0dff-b30b-4f69-86b1-154d2da72a9d
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
FRECM | Test | FRECM | Recombx MaTa Antibody Test | Recombx MaTa Antibody | Western blot | Plain, Red-Top Tube: Red |  |  | 2 | mL | Collect red-top no additive blood, separate and submit 2 mL serum in screw cap plastic vial, shipped ambient.  Note: Collection date is required. | 1 mL | Specimens other than	Serum Anticoagulants other than	Plain red-top Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | A final report will be faxed under separate cover.   Test Performed by: Athena Diagnostics                                        377 Plantation Street                                        Four Biotech Park                                        Worcester, MA 01605 |  | 7 - 14 days | 9 - 16 days | 1 | 84182 |  |  |  |  | Athena Diagnostics
FRECM | [NAME] | SRED | Serum Red |  |  |  | Ambient
FRECM | Result | Z2038 | Recombx MaTa Antibody | Recombx MaTa Antibody | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: craig_dean__4361__12-24act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: 90375d1290109793-if-and-vlookup-book1_n1
Sheet: N1

668 | [NAME] | Monday | 07:00:04
832 | [NAME] | Monday | 07:27:33
838 | [NAME] | Monday | 10:58:58
350 | [NAME] | Tuesday | 10:59:57
351 | [NAME] | Tuesday | 14:53:55
352 | [NAME] | Tuesday | 10:00:19
668 | [NAME] | Tuesday | 07:00:04
832 | [NAME] | Tuesday | 07:27:33
838 | [NAME] | Tuesday | 10:58:58
838 | [NAME] | Wednesday | 11:58:58
838 | [NAME] | Thursday | 12:58:58
838 | [NAME] | Friday | 13:58:58
838 | [NAME] | Saturday | 14:58:58
Spreadsheet: 680911d1591252979-combining-2-lists-in-2-separate-sheet-into-1-list-on-the-third-sheet-example-2-
Sheet: Summary

2019 & 2020 Sales Comparison
Client# | Product # | 2019 Sales | 2020 Sales
 |  |  |  |  |  |  |  | I am trying to make a list of 2019 and 2020 sales numbers.
 |  |  |  |  |  |  |  | I have 2 sheets, one with results for 2019 and one with results for 2020.
 |  |  |  |  |  |  |  | I would like to combine these 2 sheets into summary sheet where I can show 2019 and 2020 sales together.
 |  |  |  |  |  |  |  | There is several parameters that is not allowing me for simple solution.
 |  |  |  |  |  |  |  | 1. There are 2 no-unique keys per data. Client# and Product#.
 |  |  |  |  |  |  |  | 2. Some Client/Products were in 2019 but are not in 2020 and we have new clients and product for 2020 which is not in 2019.
2019 & 2020 Sales Comparison |  |  |  |  |  |  |  | Now for the sample attached it is easy to go through the list in 2019 and 2020 and make a list of unique client, product combination and putting it in the first sheert.
 |  |  |  |  |  |  |  | But imagine having 100s of clients and products and so creating the unique client/product list on the main sheet by hand is hard.
Client# | Product # | 2019 Sales | 2020 Sales |  |  |  |  | Also on top of that once I get the list of client/product, I need to do a vlookup, but stupid me cannot figure out how to do 'AND' vlookup. ie. [NAME] if this client# & this product#.
A | A1 | 10 | 10
A | A2 | 15 | 15
B | A1 | 50 | 0 |  |  |  |  | Is there a way to auto make the combined list on the first page so that it combines the 2 list making sure that unique values only in one or the other sheet is added?
B | A2 | 20 | 0
C | A1 | 5 | 5 |  |  |  |  | My solution in the past was to paste both list into main sheet, sort by Client then by product and combining duplicates that had sales both in 2019 and 2020.
C | A2 | 1 | 1 |  |  |  |  | Ideally this report should be done on the database level into a nice report but the company IT has no idea what they are doing and I can only get report for one year at a time and only if it has value.
C | A3 | 21 | 5 |  |  |  |  | (no sales = no show up on the report... thus the issue above of having to combine)
D | A2 | 0 | 10
D | A3 | 0 | 5 |  |  |  |  | I hope the question is clear enough and I have a feeling this is not easy solution with just formula and maybe need VBA....
 |  |  |  |  |  |  |  | Thank you in advance for your help.
Spreadsheet: 845667d1697080830-how-to-calculate-penalty-time-if-work-finishes-after-midnight-early-late-penalty-calculator
Sheet: Pay Calculator

Employee Name : |  |  |  |  |  |  |  |  |  |  |  |  |  | THIS SHOULD BE LINKED TO TIME NOT AMOUNT |  |  |  |  | THIS SHOULD BE LINKED TO TIME NOT AMOUNT
Employee Staff # : |  |  |  | PROBLEM - when you work a public holiday this should be zero PLUS ADOC, AND CHECK ALL OTHER ENTRIES |  | TO SOLVE THE PROBLEM INSERT A NEW COLUMN AND LINK TO THE DROP DOWN BOX, THEN NORMAL HOURS PAID LINKED TO THAT COLUMN TO SHOW ZEROSHOULD BE ZERO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | THIS SHOULD BE LINKED TO TIME NOT AMOUNT
 |  |  |  |  |  |  |  |  | PENALTY AWARDS and ADDITIONS
DATE | DAY | SHIFT [NAME] |  | NORMAL HOURS PAID $ |  | [NAME] |  |  | LATE/EARLY PENALTY | BROKEN SHIFT |  | HIGH CAPACITY ALLOWANCE | TRAVELLING TIME |  | PUBLIC HOLIDAY |  |  |  | ROSTERED DAY OFF CANCELLED (RDOC) |  | ADO | ALLOCATED DAY OFF CANCELLED (ADOC) |  |  |  | ANNUAL LEAVE | ANNUAL LEAVE LOADING | SICK DAY
 |  |  |  |  |  | 1½ | DOUBLE |  | 1st. HALF | 0.5 | 1 |  |  |  | WORK | +  PUBLIC HOLIDAY | NO WORK |  | 1st. 3 hrs | After 3hrs |  | ADO Default | 1st. 3 hrs | After 3hrs
WEEK 1
 |  |  |  |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 |  | Week 1 Totals :
WEEK 2
 |  |  |  |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 |  | Week 2 Totals :
 |  | COMBINED TOTAL :
Spreadsheet: chris_stokley__3917__0201 PGES2
Sheet: Total

 |  | EPMI Charges To Customers
Trans Type | (All)
 |  |  | Data
Customer | ID | Desc. | Expense | Revenue | Total | Volume
PGES | 111 | Spinning Reserve due ISO | -40.89 | 47183.87 | 47142.98 | -258.69
 | 487 | Allocation Excess Cost for IE | -26.1 | 0 | -26.1 | -37.07999977841974
 | 1010 | Neutrality Adj | -379.48 | 3822.89 | 3443.41 | -53501.14
 | 1030 | No Pay Market Refund | -20.112 | 0 | -20.112 | 4436.419800000001
 | 1210 | Existing Contract Neu Adj | -71238.9885 | 961.3472999999999 | -70277.64120000001 | -852212.1869999993
Grand Total |  |  | -71705.5705 | 51968.1073 | -19737.46320000001 | -901572.6771997778
Legend:
Sched Type PRA | Pro-Rata Adjustment; adjustments made to all participants in the market that are assessed
 | or credited under an ISO charge type.  Pro-rata adjustments are based on the customer's
 | percentage share of total volume at a given tie-point, zone, date and hour.
 | The amount of the pro-rata share is determined by variances between the amount
 | that EPMI has estimated for each customer, and the actual amount assessed
 | by the ISO.  These variances are allocated pro-rata.
Sched Type EPMIM | An entry into the system that calculates a customer's charge or payment through
 | the use of a manual tool.  Amounts are estimates using best-known metered or
 | scheduled data and information retrieved from the ISO web site.  Volume represents the
 | customer's percentage of the total amount scheduled, according to the terms of the deal.
Sched Type ISOIe | This represents amounts assessed using an automatic calculation engine, based on a customer's
 | scheduled import or export volume and best-known data retrieved from the ISO website.
 | ISOIe stands for ISO Import/Export.
[NAME] | The Production Month for which the charges or credits are assessed.
ID | The charge type identifier used by the ISO.
How to read this report:  The values presented here are from the perspective of EPMI.  An amount in the Expense column represents
payments to the customer, and an amount in the Revenue column represents payments or adjustments back to EPMI (and ultimately, back to the ISO).
The DetailData tab reflects a breakdown, by date, hour, charge type, zone, etc., of the total amounts found on the Total tab.
Spreadsheet: 94906d1294673723-auto-updating-workbooks-yarn-testing-summary
Sheet: Hualon

 | 75-36 SD Text |  |  |  |  |  |  | 100-36 Text |  |  |  |  |  |  | 160-36 SD Text
 | [NAME]. Denier | Elongation | Tenacity | Interlace Nodes/M | Oil Extraction | [NAME] |  | [NAME]. Denier | Elongation | Tenacity | Interlace Nodes/M | Oil Extraction | [NAME] |  | [NAME]. Denier | Elongation | Tenacity | Interlace Nodes/M | Oil Extraction | [NAME]
 | 76.28999999999999 | 20.3491368 | 4.522399999999999 | 48.319 |  |  |  | #N/A | #N/A | #N/A | #N/A | 1.553415161368745 | 10.17013793366523 |  | 169.4306666666667 | 21.41556666666667 | 4.356433333333333 | 37.45266666666667 | 1.743864321187679 | 10.26728628654941
 | 76.13125 | 21.47846 | 4.2521 | 57.680375 | 2.015189825910755 | 6.458453420434173
 | 76.26 | 20.16486666666667 | 4.194066666666667 | 45.18666666666667
Average | 76.22708333333333 | 20.66415448888889 | 4.322855555555556 | 50.39534722222222 | 2.015189825910755 | 6.458453420434173 |  | #N/A | #N/A | #N/A | #N/A | 1.553415161368745 | 10.17013793366523 |  | 169.4306666666667 | 21.41556666666667 | 4.356433333333333 | 37.45266666666667 | 1.743864321187679 | 10.26728628654941