tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 737056d1624083001-match-data-from-multiple-sheet-test
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | RESULT
 | APPLE |  |  |  |  |  |  | CC |  | 3
 | ORANGE |  |  |  |  |  |  | DD |  | 4
 | KIWI |  |  |  |  |  |  | EE |  | 5
 | WATERMELON |  |  |  |  |  |  | FF |  | 6
 | BIKE |  |  |  |  |  |  | DD |  | 16
 | SOFA |  |  |  |  |  |  | WW |  | 17
 | BUS |  |  |  |  |  |  | QQ |  | 18
 | GREEN |  |  |  |  |  |  | GREEN |  | 14
 | BLUE |  |  |  |  |  |  | BLUE |  | 15
 | PEAR |  |  |  |  |  |  | GG |  | 7
 | ORANGE |  |  |  |  |  |  | HH |  | 8
Spreadsheet: 172025d1343956717-sumif-with-match-functionality-sumif-and-match-day92
Sheet: Sheet1

 |  | DATA |  |  |  |  |  |  |  | Final Report
 |  | Name | 2012-01-01 00:00:00 | 2012-04-15 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 |  |  | Name | 2012-01-01 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-04-15 00:00:00
 |  | [NAME] | 45 | 50 | 50 | 50 | 50 |  |  | [NAME]
 |  | [NAME] | 50 | 55 | 55 | 55 | 55 |  |  | [NAME]
 |  | Sue | 55 | 60 | 50 | 60 | 60 |  |  | Sue
 |  | [NAME] | 60 | 45 | 55 | 45 | 45
 |  | [NAME] | 45 | 50 | 60 | 50 | 50 |  |  | I am looking for an equation that allows me to sumif the category name in column K from column C but also add the functionality of matching the dates in row 3 versus just dragging the equation over.  I can do the sumif but not sure where to add in the match to the equation to ensure I am pulling over the correct date.  Any other suggestions would be much appreciated.  Thank you
 |  | [NAME] | 50 | 55 | 45 | 55 | 55
 |  | Sue | 55 | 60 | 50 | 60 | 60
 |  | [NAME] | 60 | 45 | 55 | 55 | 50
 |  | [NAME] | 45 | 50 | 60 | 60 | 55
 |  | [NAME] | 50 | 55 | 45 | 45 | 50
 |  | Sue | 55 | 60 | 50 | 50 | 55
 |  | [NAME] | 60 | 55 | 55 | 55 | 60
Spreadsheet: 216920d1361920154-count-number-of-hours-someone-worked-between-two-times-test
Sheet: Sheet1

Day | Start Time | End Time | How Many Hours Did They Work From 7pm to Midnight? | How Many Hours Did They Work From Midnight to 7am?
Mon | 20 | 1
Tue | 16 | 6
Wed | 14 | 7
Thu | 13 | 23
Fri | 4 | 15
Sat | 5 | 13.5
Sun | 5 | 13.5
Spreadsheet: 6fc0898b-e906-420b-a14e-20541bcfe149
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  |  |  |  |  |  | Devastated quake-hit prefectures(Iwate, Miyagi and [NAME]) are not included in the figures.
 |  |  |  |  |  |  |  |  | Table 26 | Household by type and number of employed persons
 |  |  |  |  |  |  | December 2011 |  |  |  |  |  |  |  |  |  | (Ten thousand households)
 |  |  |  |  |  |  | Number of employed persons in household |  | Total | Number of employed persons in household
 |  |  |  |  |  |  |  |  |  | Average number of employed persons in household (persons) | 0 | 1 | 2 | 3 | 4 | 5 persons or more | Number of employed persons in household unknown
 |  |  |  |  |  |  | Type of household |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
2600 | 86120 |  | 1 |  |  |  | Total | 1 | 4947 | 1.18 | 1407 | 1860 | 1223 | 329 | 109 | 16 | 1
2600 | 86120 |  | 1 |  |  |  | Two-or-more-person   household | 2 | 3389 | 1.5 | 571 | 1140 | 1223 | 329 | 109 | 16 | 1
2600 | 86120 |  | 1 |  |  |  | Relative household | 3 | 3382 | 1.5 | 570 | 1138 | 1219 | 329 | 109 | 16 | 1
2600 | 86120 |  | 1 |  |  |  | Nuclear family household | 4 | 2827 | 1.41 | 517 | 999 | 1021 | 220 | 63 | 6 | 0
2600 | 86120 |  | 1 |  |  |  | Other relative household | 5 | 555 | 1.99 | 52 | 138 | 199 | 109 | 46 | 11 | 1
2600 | 86120 |  | 1 |  |  |  | Non-relative household | 6 | 7 | 1.45 | 1 | 2 | 4 | - | - | - | -
2600 | 86120 |  | 1 |  |  |  | One-person household | 7 | 1558 | 0.46 | 837 | 721 | - | - | - | - | -
Spreadsheet: 681797d1591753498-return-answer-based-on-selected-criteria-sample
Sheet: Sheet1

Delivery Date | Customer | Number of item | Ice |  | Return Date | Customer | Number of item | Ice | Return
2020-06-20 00:00:00 | [NAME] | 1 | 20 |  | 2020-06-21 00:00:00 | [NAME] | 1 | 20 | Yes
2020-06-20 00:00:00 | May | 3 | 50
2020-06-20 00:00:00 | [NAME] | 4 | 21
2020-06-20 00:00:00 | Wonf | 5 | 100 |  | 2020-06-21 00:00:00 | Wonf | 5 | 100 | Yes
Spreadsheet: 194374d1353142741-decision-model-in-terms-of-resource-constraint-book2
Sheet: Sheet1

 | Machine Hours per Product |  |  |  | Optimum Monthly Hours | Monthly Demand | Contribution per unit
 | Product_1 | Product_2 | Product_3 | Product_4
Machine_1 | 4 | 2 | 5 | 1 |  | 600 | 6
Machine_2 | 3 | 7 | 8 | 1 |  | 500 | 8
Machine_3 | 6 | 5 | 7 | 2 |  | 750 | 2.5
Machine_4 | 3 | 5 | 6 | 3 |  | 350 | 10
Machine_5 | 4 | 2 | 2 | 2 |  | 450 | 7
Spreadsheet: 29595d1224683864-excel-2007-averaging-copy-of-xl0000005
Sheet: Sheet1

Name | Term - YRS | Rate | Balance
 | 6 | 0.05 |  | 0.049375
 | 5 | 0.05
 | 10 | 0.05
 | 5 | 0.035
 | 10 | 0.05
 | 15 | 0.05
 | 10 | 0.05
 | 5 | 0.05
 | 10/20 | 0.05
 | 4 | 0.0475
 | 10 | 0.0475
 | 2 | 0.0475
 | 10/25 | 0.05
 | 10/20 | 0.0475
 | 5 | 0.035
 | 5 | 0.035
 | 5 | 0.035
 | 5 | 0.035
 | 15 | 0.04
 | 15 | 0.04
 | 4 | 0.035
 | 4 | 0.035
 | 10 | 0.0375
 | 10 | 0.0375
 | 10 | 0.0375
 | 10 | 0.0375
 | 10/15 | 0.0375
 | 10 | 0.0375
 | 15 | 0.04
 | 8 | 0.0375
 | 15 | 0.04
 | 10 | 0.0375
 | 5 | 0.035
 | 10 | 0.0375
 | 15 | 0.04
 | 10/20 | 0.0375
 | 15 | 0.04
 | 10 | 0.0375
 | 5 | 0.035
 | 4 | 0.035
 | 4 | 0.035
 | 10 | 0.0375
 | 15 | 0.04
 | 15 | 0.04
 | 5 | 0.035
 | 15 | 0.04
Total
Cumulative Totals |  |  | Test Excel Function
TERM | Balance | Avg. Rate
1-5 Years (3.84%) | 0 | 0.03843750000000002 | 0.045625
6-10 Years (4.23%) | 0 | 0.04224999999999999
11-15 Years (4.11%) | 0 | 0.04111111111111111
Name | Term - YRS | Rate | Balance
 | 15 | 0.04
 | 10 | 0.0375
 | 15 | 0.04
 | 10 | 0.0375
 | 15 | 0.04
 | 10 | 0.0375
 | 15 | 0.04
Total
Cumulative Totals
TERM | Balance | Avg. Rate
1-5 Years (3.84%) | 0 | 0.03843750000000002
6-10 Years (4.16%) | 0 | 0.04163043478260868
11-15 Years (4.08%) | 0 | 0.04076923076923077
Name | Term - YRS | Rate | Balance
 | 15 | 0.04
 | 15 | 0.04
 | 15 | 0.04
 | 15 | 0.04
 | 15 | 0.04
 | 5 | 0.035
 | 10 | 0.0375
 | 10 | 0.0375
 | 15 | 0.04
 | 10 | 0.0375
 | 10 | 0.0375
 | 15 | 0.04
 | 10 | 0.0375
Total
TERM | Balance | Avg. Rate
1-5 Years (3.82%) | 0 | 0.03823529411764708
6-10 Years (4.09%) | 0 | 0.04089285714285714
11-15 Years (4.05%) | 0 | 0.04047619047619049
Spreadsheet: 5dfebdf1-1603-499f-926d-d8e0c6d1278c
Sheet: Sheet1

Unnamed: 0 | SVG Coater and [NAME] Use Only | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Week of Mar. 3 - Mar. 7
 |  | 1um | 1.6um | 7um | 1um | 1.6um | 3um | 1um | 1um | 1um
SVG                         Coater | Date (Coat) | 2008-03-07 00:00:00 | 2008-03-07 00:00:00 | 2008-03-07 00:00:00 | 2008-03-07 00:00:00 | 2008-03-07 00:00:00 | 2008-03-07 00:00:00
 | Track | 1 | 1 | 1 | 2 | 2 | 2
 | Prime Program | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven
 | Coat Program | 7 | 8 | 4 | 7 | 8 | 4
 | Oven Program | 1 | 2 | 3 | 1 | 2 | 3
 | Problems
Thickness Measurements                                (NanoSpec) | Date (Measurement) | 2008-03-08 00:00:00 | 2008-03-08 00:00:00 | 2008-03-08 00:00:00 | 2008-03-08 00:00:00 | 2008-03-08 00:00:00 | 2008-03-08 00:00:00 | - | - | -
 | Top (A) | 10503 | 17494 | 73529 | 10421 | 17170 | 30552 | - | - | -
 | Center (A) | 10473 | 17460 | 73646 | 10414 | 17160 | 30298 | - | - | -
 | Flat (A) | 10487 | 17502 | 73561 | 10435 | 17190 | 30604 | - | - | -
 | Left  (A) | 10506 | 17487 | 73377 | 10436 | 17187 | 30453 | - | - | -
 | Right (A) | 10488 | 17504 | 73466 | 10429 | 17186 | 30645 | - | - | -
 | Average (A) | 10491 | 17489 | 73516 | 10427 | 17179 | 30510 | - | - | -
 | [NAME]  (A) | 13 | 18 | 101 | 9 | 13 | 139 | - | - | -
 | Comments |  |  | poor uniformity | edgebead too small | edgebead too small | edgebead too small
Exposure | Date (Exposure) | 2008-03-08 00:00:00 | 2008-03-08 00:00:00 | 2008-03-08 00:00:00 | 2008-03-08 00:00:00 | 2008-03-08 00:00:00 | 2008-03-08 00:00:00
 | Tool | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | EValign | EValign | EValign
 | Contact Type | Vac. | Vac. | Vac. | Vac. | Vac. | Vac.
 | Exposure Time | 1.0s | 1.6s | 3.0s x2 | 1.0s | 1.6s | 3.0s
 | Problems
SVG                            Developer | Date (Develop) | 2008-03-08 00:00:00 | 2008-03-08 00:00:00 | 2008-03-08 00:00:00 | 2008-03-08 00:00:00 | 2008-03-08 00:00:00 | 2008-03-08 00:00:00
 | Track | 2 | 1 | 1 | 2 | 2 | 2
 | Pre-bake Program | 1 | 2 | none | 1 | 2 | none
 | Develop Program | 3 | 4 | 6 | 3 | 4 | 7
 | Post-base Program | 1 | 2 | none | 1 | 2 | none
 | Problems
Resolution                         Measurements | Date (Measurement) | 2008-03-09 00:00:00 | 2008-03-09 00:00:00 | 2008-03-09 00:00:00 | 2008-03-09 00:00:00 | 2008-03-09 00:00:00 | 2008-03-09 00:00:00
 | Top (H/V) (um) | 1.5 / 1.5 | 1.5 / 1.5 | 2.5 / 2.5 | 1.5 / 1.5 | 1.5 / 1.5 | 2 / 2.5
 | Center (H/V) (um) | 1.5 / 1.5 | 1.5 / 1.5 | 2.5 / 2.5 | 1.5 / 1.5 | 1.5 / 1.5 | 2 / 2.5
 | Flat (H/V) (um) | 1.5 / 1.5 | 1.5 / 1.5 | 2.5 / 2.5 | 1 / 1.5 | 1.5 / 1.5 | 2.5 / 2.5
 | Left (H/V) (um) | 1.5 / 1.5 | 1.5 / 2 | 2.5 / 2.5 | 1 / 1.5 | 1.5 / 1.5 | 2 / 2.5
 | Right (H/V) (um) | 1.5 / 1.5 | 1.5 / 1.5 | 2 / 2.5 | 1 / 1.5 | 1.5 / 1.5 | 2 / 2.5
 | Comments
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Ann Pugh

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
I am a faculty member at UVM and an AFT member
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
No response
Health Care: Continuing System Reform
I'd like to explain my position
Explain your health care reform position, if you choose
Under the new federal law many plans such as those of VT-NEA would be grandfathered.  I
continue to support the right of union members to negotiate for higher or more robust benefits or
insulation from an potential changes as part their contract.
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
As someone who teaches at UVM
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
No response
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 67 [NAME], South Burlington, VT 05403 | State Representative Chittenden (South Burlington) 7-2 | Yes |  | Chittenden
Spreadsheet: 67085d1267713025-adding-data-over-existing-chart-720326
Sheet: Marie-Ève

Lundi le 8 Mars 2010
# | Joueurs | $$$ | Consommation
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
Par: _______________________________
Spreadsheet: 707420d1607261797-using-a-list-to-reduce-worksheets-midshires-master-ans
Sheet: FM

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 703601d1605081381-count-values-in-a-column-based-on-data-with-blanks-in-another-column-excel-question
Sheet: ProductBatch

DOM | Product Batch No. | RawBatch No. | [NAME]
2020-12-15 00:00:00 |  | A-011 | 2021-01-01 00:00:00
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-011
 |  | A-012 | 2021-03-01 00:00:00
 |  | A-012
 |  | A-012
 |  | A-012
 |  | A-012
 |  | A-012
 |  | A-012
 |  | A-012
 |  | A-012
 |  | A-012
 |  | A-012
 |  | A-012
 |  | A-012
 |  | A-012
 |  | A-012
 |  | A-012
Spreadsheet: 289440d1389584201-how-to-do-cartesian-join-that-is-based-on-the-selected-cell-value-bk1
Sheet: TBL1

A | B
1 | a
2
3
4
5
6
7
8
9
10
11 | b
12
13
14
15
16 | c
17
18
19 | d
20 | e
Spreadsheet: 148985d1333639734-compare-two-columns-from-one-sheet-to-two-columns-in-other-sheet-and-fill-third-column-experiment_vero02
Sheet: sheet2

Product | Customer | Market | Expected result
Type A | HUTCHINSON | parts | parts | Type A | HUTCHINSON
Type B | NP PODOLSKKABEL  OAO | auto | auto | Type B | NP PODOLSKKABEL  OAO
Type Z | TISSAN OOO | #N/A |  | #N/A | TISSAN OOO
Product A | INTELS OOO | #N/A |  | #N/A | INTELS OOO
Type B | ABC | #N/A |  | Type B | #N/A
Type V | TISSAN OOO | fuel line | fuel line | Type V | TISSAN OOO
XYZ | INTELS OOO | pipes | pipes | XYZ | INTELS OOO
Type A | INTELS OOO | parts |  | Type A | INTELS OOO
Product A | HUTCHINSON | #N/A |  | #N/A | HUTCHINSON
 |  | Is not expected ..
Spreadsheet: 7776bdbf-2afe-4e68-84f4-99c0f720a0ef
Sheet: Sheet1

WK | Monday | Tuesday | Wednesday | Thursday | FRIDAY
 | 2013-08-19 00:00:00
1 |  |  |  | Orientations 9:30-11:30am
2 | Orientations 12:30-2:30pm | Orientations  4-7pm | Orientations  4-6pm | Orientations 9:30-11:30am
3 | LAB CLOSED - LABOR DAY | JJ-Instructor Hours  4-7pm | CC-Instructor Hours  4-6pm | CC-Instructor Hours  9:30-11:30am
4 | CC-Instructor Hours 12:30-2:30pm | JJ-Instructor Hours  4-7pm | CC-Instructor Hours  4-6pm | CC-Instructor Hours  9:30-11:30am
5 | CC-Instructor Hours 12:30-2:30pm | JJ-Instructor Hours  4-7pm | CC-Instructor Hours  4-6pm | CC-Instructor Hours  9:30-11:30am
6 | CC-Instructor Hours 12:30-2:30pm | JJ-Instructor Hours  4-7pm | CC-Instructor Hours  4-6pm | CC-Instructor Hours  9:30-11:30am
7 | CC-Instructor Hours 12:30-2:30pm | JJ-Instructor Hours  4-7pm | CC-Instructor Hours  4-6pm | CC-Instructor Hours  9:30-11:30am
8 | CC-Instructor Hours 12:30-2:30pm | JJ-Instructor Hours  4-7pm | CC-Instructor Hours  4-6pm | CC-Instructor Hours  9:30-11:30am
9 | CC-Instructor Hours 12:30-2:30pm | JJ-Instructor Hours  4-7pm | CC-Instructor Hours  4-6pm | CC-Instructor Hours  9:30-11:30am | 50% Mark of Semester
10 | CC-Instructor Hours 12:30-2:30pm | JJ-Instructor Hours  4-7pm | CC-Instructor Hours  4-6pm | CC-Instructor Hours  9:30-11:30am
11 | CC-Instructor Hours 12:30-2:30pm | JJ-Instructor Hours  4-7pm | CC-Instructor Hours  4-6pm | CC-Instructor Hours  9:30-11:30am
WK | Monday | Tuesday | Wednesday | Thursday | FRIDAY
12 | CC-Instructor Hours 12:30-2:30pm | JJ-Instructor Hours  4-7pm | CC-Instructor Hours  4-6pm | CC-Instructor Hours  9:30-11:30am
13 | CC-Instructor Hours 12:30-2:30pm | JJ-Instructor Hours  4-7pm | CC-Instructor Hours  4-6pm | CC-Instructor Hours  9:30-11:30am
14 | CC-Instructor Hours 12:30-2:30pm | JJ-Instructor Hours  4-7pm | CC-Instructor Hours  4-6pm | CC-Instructor Hours  9:30-11:30am
15 | CC-Instructor Hours 12:30-2:30pm | JJ-Instructor Hours  4-7pm | CC-Instructor Hours  4-6pm | LAB CLOSED - THANKSGIVING | LAB CLOSED
16 | CC-Instructor Hours 12:30-2:30pm | JJ-Instructor Hours  4-7pm | CC-Instructor Hours  4-6pm | CC-Instructor Hours  9:30-11:30am
17 | CC-Instructor Hours 12:30-2:30pm | JJ-Instructor Hours  4-7pm | CC-Instructor Hours  4-6pm | CC-Instructor Hours  9:30-11:30am
18 | CC-Instructor Hours 12:30-2:30pm | JJ-Instructor Hours  4-7pm | LAST DAY OF SEMESTER CC-Instructor Hours  4-6pm
 | LAB HOURS:  MONDAY – THURSDAY 8:00 a.m. – 8:00 p.m.         FRIDAY 8:00 A.M. – NOON
 | HOURS WHEN INSTRUCTORS ARE PRESENT:
 | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY
 |  |  |  | [NAME]
 |  |  |  | 9:30-11:30am
 | [NAME] |  |  |  | LAB CLOSES AT NOON
 | 12:30-2:30pm
 |  | [NAME] | [NAME]
 |  | 4:00-7:00pm | 4:00-6:00pm
This schedule is subject to change during the semester.
Spreadsheet: 217123d1361989368-count-number-of-events-per-month-in-a-range-datecount-example-cpots13-oeldere-
Sheet: pivot table

Aantal [NAME] | Kolomlabels
Rijlabels | Day Shift | Night Shift | Eindtotaal
2012 | 92 | 63 | 155
1 | 6 | 5 | 11
2 | 8 | 2 | 10
3 | 6 | 3 | 9
4 | 5 | 3 | 8
5 | 3 | 5 | 8
6 | 8 | 10 | 18
7 | 12 | 6 | 18
8 | 15 | 8 | 23
9 | 6 | 4 | 10
10 | 6 | 5 | 11
11 | 7 | 8 | 15
12 | 10 | 4 | 14
2013 | 12 | 10 | 22
1 | 12 | 10 | 22
Eindtotaal | 104 | 73 | 177
Spreadsheet: 600704d1543920371-not-sure-formula-to-use-for-index-match-or-vlookup-multiple-criteria-sample-spreadsheet-for-formula
Sheet: DATA2

 | [NAME] | Week no | SumOfQTY | SumOfSALESVAL | SumOfMargin | Margin (%)
Spreadsheet: 36a3bf14-5bac-4cba-8cb4-f5afa031ec77
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
2480 | 13353 | [NAME] | Barfoot | NZL | 0 | 00:34:56 | [NAME] | 00:08:00 | 00:22:44 | 02:20:55 | 1 | 03:37:34
2480 | 7518 | Rosi | Suter | SUI | 0 | 00:51:30 | 00:12:45 | 00:08:23 | 00:25:10 | 02:33:19 | 2 | 04:11:04
2480 | 13352 | [NAME] | Hall | GBR | 0 | 00:57:32 | 00:18:30 | 00:10:25 | [NAME] | 03:32:50 | 3 | 05:30:55
Spreadsheet: 330414d1404741986-counting-formula-count
Sheet: Sheet1

Weight | Pallet |  | Weight | Pallet |  | Total Pallets Available
290 | 1 |  | 232 | 1
352 | 2 |  | 245 | 2
272 | 3 |  | 290 | 3
290 | 4 |  | 206 | 4
246 | 5 |  |  | 5
226 | 6 |  |  | 6
302 | 7 |  |  | 7
250 | 8 |  |  | 8
263 | 9 |  |  | 9
260 | 10 |  |  | 10
200 | 11 |  |  | 11
187 | 12 |  |  | 12
196 | 13 |  |  | 13
265 | 14 |  |  | 14
280 | 15 |  |  | 15
213 | 16 |  |  | 16
213 | 17 |  |  | 17
70 | 18 |  |  | 18
 | 19 |  |  | 19
 | 20 |  |  | 20
 | 21 |  |  | 21
 | 22 |  |  | 22
 | 23 |  |  | 23
 | 24 |  |  | 24
 | 25 |  |  | 25
 | 26 |  |  | 26
 | 27 |  |  | 27
 | 28 |  |  | 28
 | 29 |  |  | 29
 | 30 |  |  | 30
 | 31 |  |  | 31
 | 32 |  |  | 32
 | 33 |  |  | 33
 | 34 |  |  | 34
 | 35 |  |  | 35
 | 36 |  |  | 36
 | 37 |  |  | 37
 | 38 |  |  | 38
 | 39 |  |  | 39
 | 40 |  |  | 40
Spreadsheet: 157255d1337685533-table-issues-reverse-lookup-help-with-my-workbook-table-example
Sheet: Sheet1

 |  |  |  |  |  |  | 2030-01-10 00:00:00 | 2012-12-02 00:00:00 | 2000-10-09 00:00:00 |  |  | e.g. | [NAME] | Jojo
 |  |  |  |  |  | [NAME] | 1 | 0 | 1 |  |  |  | 2030-01-10 00:00:00 | 2030-01-10 00:00:00
 |  |  |  |  |  | [NAME] | 1 | 1 | 0 |  |  |  | 2000-10-09 00:00:00
 |  |  |  |  |  | Jojo | 1 | 0 | 0
Spreadsheet: 586581d1534446308-excel-multiply-multiple-drop-down-list-boxes-calearoson-drop-box-times-drop-boxes
Sheet: Sheet1

2
 |  |  | CS3/CS4 LENCO RATIO CALCULATOR
 |  |  |  | What answer would be with selected
 | Box 1 |  | [NAME]
1 | 2
 | [NAME] |  | [NAME]
 | 2
 | Box 3 |  | Box 3 X Box 4
 | 4
 | [NAME] |  | Box 4 Selected Value
 | 2
 | 1.102 | 1.102 | 1.102 | 1.102
 | 1.125 | 1.125 | 1.125 | 1.125
 | 1.136 | 1.136 | 1.136 | 1.136
 | 1.175 | 1.175 | 1.175 | 1.175
 | 1.195 | 1.195 | 1.195 | 1.195
 | 1.225 | 1.225 | 1.225 | 1.225
 | 1.245 | 1.245 | 1.245 | 1.245
 | 1.265 | 1.265 | 1.265 | 1.265
 | 1.272 | 1.272 | 1.272 | 1.272
 | 1.285 | 1.285 | 1.285 | 1.285
 | 1.297 | 1.297 | 1.297 | 1.297
 | 1.301 | 1.301 | 1.301 | 1.301
 | 1.325 | 1.325 | 1.325 | 1.325
 | 1.345 | 1.345 | 1.345 | 1.345
 | 1.362 | 1.362 | 1.362 | 1.362
 | 1.375 | 1.375 | 1.375 | 1.375
 | 1.398 | 1.398 | 1.398 | 1.398
 | 1.409 | 1.409 | 1.409 | 1.409
 | 1.426 | 1.426 | 1.426 | 1.426
 | 1.456 | 1.456 | 1.456 | 1.456
Spreadsheet: 832720d1686564383-transforming-data-from-vertical-to-horizontal-using-excel-function-excel1
Sheet: Sheet1

Option A |  |  |  |  |  | Option B (what I want)
Source | Target |  |  |  |  | TargetA |  |  |  | TargetB
TargetA | Evaporation |  |  |  |  | Rain | Flowin | Evaporation | SOTP | Rain | Flowin | Evaporation | SQPE
TargetA | SOTP
Rain | TargetA
Flowin | TargetA |  |  |  | nth appearance of Target x | 3 | 4 | 1 | 2 | 1 | 2 | 3 | 4
Rain | TargetB |  |  |  | column of desired result | 1 | 1 | 2 | 2 | 1 | 1 | 2 | 2
Flowin | TargetB
TargetB | Evaporation
TargetB | SQPE
Spreadsheet: 92288d1291904151-average-random-cells-no-array-bypassing-cells-with-zeros-example-2010-2011
Sheet: DeFeb11

2011-02-01 00:00:00
Product Technician | Project Name | Branch / Salesperson | Complexity Level | Date Received | [NAME] | Number Of Line Items | Notes | Potential Points | Earned Points
Submitted Projects - East
Kirchgessner |  |  | 0 |  |  | No BOM
Kirchgessner |  |  |  |  |  | No BOM
Kirchgessner |  |  |  |  |  | No BOM
 | 0
Morris |  |  | 0 |  |  | No BOM
Morris |  |  |  |  |  | No BOM
Morris |  |  |  |  |  | No BOM
 | 0
McGill |  |  | 0 |  |  | No BOM
McGill |  |  |  |  |  | No BOM
McGill
 | 0
[NAME] |  |  | 0 |  |  | No BOM |  | 40 | 40
[NAME] |  |  |  |  |  | No BOM
[NAME] |  |  |  |  |  | No BOM
 | 0
Submitted Projects - West/Central
Spaw |  |  | 0 |  |  | No BOM
Spaw |  |  |  |  |  | No BOM
Spaw |  |  |  |  |  | No BOM
 | 0
Wilson |  |  | 0 |  |  | No BOM
Wilson |  |  |  |  |  | No BOM
Wilson |  |  |  |  |  | No BOM
 | 0
DeYoung |  |  | 0 |  |  | No BOM
DeYoung |  |  |  |  |  | No BOM
DeYoung |  |  |  |  |  | No BOM
 | 0
Karger |  |  | 0 |  |  | No BOM
Karger |  |  |  |  |  | No BOM
Karger |  |  |  |  |  | No BOM
 | 0
Completed Projects - East
Kirchgessner |  |  | 0
Kirchgessner
Kirchgessner
 | 0
Morris |  |  | 0
Morris
Morris
 | 0
McGill |  |  | 0
McGill
McGill
 | 0
[NAME] |  |  | 0
[NAME]
[NAME]
 | 0
Completed Projects - West/Central
Spaw |  |  | 0
Spaw
Spaw
 | 0
Wilson |  |  | 0
Wilson
Wilson
 | 0
DeYoung |  |  | 0
DeYoung
DeYoung
 | 0
Karger |  |  | 0
Karger
Karger
 | 0
 | Group totals for the Month: |  |  |  |  | Total Line Items:
Submitted: |  |  | Average difficulty:
Completed: |  |  | Average difficulty:
Group Errors
Spreadsheet: 758410d1638859098-count-of-non-numerical-cells-new-microsoft-office-excel-2007-workbook
Sheet: Sheet1

 |  | Section 1 | Section 2 | Section 3 | Section 4
Wed | 2021-12-01 00:00:00 | George
Thu | 2021-12-02 00:00:00 | George |  |  | Harold
Fri | 2021-12-03 00:00:00 | George |  | [NAME] | Harold
Sat | 2021-12-04 00:00:00 | George |  | [NAME] | Harold
Sun | 2021-12-05 00:00:00 | George | [NAME] | [NAME]
Mon | 2021-12-06 00:00:00 | George | [NAME] | [NAME]
[NAME] | 2021-12-07 00:00:00 |  | [NAME]
Wed | 2021-12-08 00:00:00 |  | [NAME] |  | Harold
Thu | 2021-12-09 00:00:00 |  | [NAME] |  | Harold
Fri | 2021-12-10 00:00:00 |  | [NAME] | [NAME] | Harold
Sat | 2021-12-11 00:00:00 | Adam | [NAME] | [NAME]
Sun | 2021-12-12 00:00:00 | Adam |  | [NAME]
Mon | 2021-12-13 00:00:00 | Adam |  | [NAME]
[NAME] | 2021-12-14 00:00:00 | Adam |  | [NAME]
Wed | 2021-12-15 00:00:00 | Adam |  | [NAME]
Thu | 2021-12-16 00:00:00
Fri | 2021-12-17 00:00:00 |  | Fred
Sat | 2021-12-18 00:00:00 |  | Fred
Spreadsheet: 889870d1740846387-conditional-formatting-based-on-cross-reference-cond_formatting
Sheet: Matrix

MEASURE | DATA ELEMENT (DE) #1 | DATA ELEMENT (DE) #2 | DATA ELEMENT (DE) #3 | DATA ELEMENT (DE) #4 | DATA ELEMENT (DE) #5
ABC | [NAME] | Kilo
DEF | Delta
GHI | Bravo | [NAME]
KLM | Lima | Echo | India | Alpha
XYZ | November | Golf | [NAME] | [NAME] | Hotel
Spreadsheet: drew_fossum__8992__Fixed3
Sheet: ENA_11

[NAME]
FUEL HEDGING BOOK
Enron North America_11
Prod. | Contract | Contract | Fixed |  | Fuel | Settled | Futures | (Gains) and Losses
Date | Number | Name | Price |  | Dth | Price | Price | Total | Realized | Unrealized
 |  |  |  |  |  | El Paso Prmn |  | (4) | (4) | (4)
2001-01-01 00:00:00 |  | ENA | 3.74
2001-02-01 00:00:00 |  | ENA | 3.74
2001-03-01 00:00:00 |  | ENA | 3.74
2001-04-01 00:00:00 |  | ENA | 3.74
2001-05-01 00:00:00 |  | ENA | 3.74
2001-06-01 00:00:00 |  | ENA | 3.74
2001-07-01 00:00:00 |  | ENA | 3.74
2001-08-01 00:00:00 |  | ENA | 3.74
2001-09-01 00:00:00 |  | ENA | 3.74
2001-10-01 00:00:00 |  | ENA | 3.74
2001-11-01 00:00:00 |  | ENA | 3.74
2001-12-01 00:00:00 |  | ENA | 3.74
 |  |  |  |  |  | TW Index
2001-01-01 00:00:00 |  | Over-retention | 3.74
2001-02-01 00:00:00 |  | Over-retention | 3.74
2001-03-01 00:00:00 |  | Over-retention | 3.74
2001-04-01 00:00:00 |  | Over-retention | 3.74
2001-05-01 00:00:00 |  | Over-retention | 3.74
2001-06-01 00:00:00 |  | Over-retention | 3.74
2001-07-01 00:00:00 |  | Over-retention | 3.74
2001-08-01 00:00:00 |  | Over-retention | 3.74
2001-09-01 00:00:00 |  | Over-retention | 3.74
2001-10-01 00:00:00 |  | Over-retention | 3.74
2001-11-01 00:00:00 |  | Over-retention | 3.74
2001-12-01 00:00:00 |  | Over-retention | 3.74
(4)Gain and [NAME] are a measurement of the effectiveness of meeting the stated hedge objective.