tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 586881d1534706474-basketball-table-and-best-second-places-womens-eb-qualifier-tables
Sheet: GroupA

GROUP A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GP | W | D | L | GF | GA | [NAME] | PTS | rank
Team name | Bonus/penalty points
Slovakia
Montenegro
Bosnia
Iceland
ROUND 1 |  |  |  |  |  |  | Table
 |  |  | :
 |  | 76 | : | 55 |  |  |  | GP | W | D | L | GF | GA | [NAME] | PTS
 |  | 78 | : | 62
 |  | 79 | : | 67
 |  |  | :
 |  | 69 | : | 37
ROUND 2
 |  | 72 | : | 73
 |  |  | :
 |  |  | :
 |  | 100 | : | 95
 |  | 97 | : | 67
 |  | 62 | : | 84
Spreadsheet: 05c162b2-d358-470e-b6e2-e90ee72bc66c
Sheet: FACULTY INFORMATION FORM

Please use capital letters & no punctuation | EXAMPLE | class 1 info | class 2 info | class 3 info | class 4 info | class 5 info | class 6 info
Last Name | LOGAN
First Name | SARAH
MI | M
Printed Course Prefix (e.g. COMM, MM) and Number | PSY3303
Printed Date/Time (e.g. MW 08:00 AM, TR 12:30 PM or MWF 18:00 PM) | TR 18:00 PM
Bubbled in Meeting Days (MTWRFSN) NO [NAME] or Spaces | TR
In the Classroom = Face  OR  Online Course = Online | Face
Eight Week Course = Y (yes) or N (no).    If YES… 1 for first eight weeks or 2 for second eight weeks | Y-2
For On-line courses ONLY - Print course title. In addition, please provide a class roster with [NAME] "username@angelo .edu" with your FIF.  Dropped students can be withdrawn later. | Learning  and Cognition
Objectives:  (Scale - M = Minor or No Importance,  I = Important,                              E = Essential) | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E
1.  Gaining factual knowledge (terminology, classifications, methods,       trends) | E
2.  Learning fundamental principles, generalizations, or theories | E
3.  Learning to apply course material (to improve thinking, problem       solving,  and decisions) | E
4.  Developing specific skills, competencies, and points of view needed       by professionals in the field most closely related to this course | I
5.  Acquiring skills in working with others as a member of a team | I
6.  Developing creative capacities (writing, inventing, designing,       performing in art, music, drama, etc.) | M
7.  Gaining a broader understanding and appreciation of       intellectual/cultural activity (music, science, literature, etc.) | M
8.  Developing skill in expressing oneself orally or in writing | M
9.  Learning how to find and use resources for answering questions or       solving problems | M
10.  Developing a clearer understanding of, and commitment to, personal         values | M
11.  Learning to analyze and critically evaluate ideas, arguments,         and points of view | M
12.  Acquiring an interest in learning more by asking questions and        seeking answers | M
[NAME] (e.g. COMM, TH, MM) | PSY
Discipline codes: COMM = 0900               Mass Media = 0904                                                                  (4 digits) | 4200
[NAME] (e.g. 800, 1230, or 1800) | 800
Bubbled Course Number                                                            (4 digits) | 3303
Enrollment | 23
Local Code for COMM 2301 = 0100   Honors = 0101 MM 2345, COMM 2345 = 0200  Honors = 0201       (4 digits)
Long (L) or Short (S) Forms | L
Number of Additional Questions to be answered on the Survey  ([NAME]. number of Additional questions that can be asked for Long form = 19 & Short form = 10) | 12
Is this class [NAME]?   Y or N | N
Spreadsheet: 205213d1357757581-excel-query-calculating-result-based-on-three-possible-factors-example
Sheet: Sheet1

New Dept ID | Old Dept ID | Old Manager | New Manager | Old Job Code | New Job Code | Old Status | New Status | Dept Change | Manager | Job Code | Status
RT465 | RT465 | [NAME] | FRED ADAMS | 4875 | 4890 | EMP | EMP
GY123 | [NAME] | [NAME] | ANDY BOND | 5362 | 7635 | EMP | EMP
[NAME] | [NAME] | ANDY MANTLE | ANDY MANTLE | 8908 | 8908 | CTR | EMP
PO908 | PO908 | MARY HALL | MARY HALL | 7564 | 1943 | EMP | EMP
FT7546 | FT7564 | SARAH HILL | TANYA SMALL | 6746 | 6746 | EMP | EMP
Spreadsheet: 156063d1337168309-want-to-count-number-of-student-grades-in-each-group-and-subject-assessment_2011-12
Sheet: Teachers

Subject | Teacher 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
English Language | A | B | C | D | E | F | G | H | I | J | K | L
Maths | A | B | C | D | E | F | G | H | I | J | K | L
Subject | Teacher | Group 1 | Group 2 | Group 3 | Group 4
English Language | A | 11y/En1
English Language | B | 11x/En1
English Language | C | 11y/En2
English Language | D | 11y/En3 | 11x/En2
English Language | E | 11x/En3
English Language | F | 11y/En4
English Language | G | 11x/En4
English Language | H | 11x/En5
English Language | I | 11y/En5
Maths | A | 11Y8/Ma
Maths | B | 11Y7/Ma
Maths | C | 11YC/Ma | 11X4/Ma
Maths | D | 114X/Ma
Maths | E | 11X1/Ma
Maths | F | 11Y6/Ma | 11X2/Ma
Maths | G | 11YH/Ma
Maths | H | 11Y9/Ma
Maths | I | 11X3/Ma
Maths | J | 11GMX/Ma
Maths | K | 11Y5/Ma
Maths | L | 11GMY/Ma
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R28

Ime artikla
Spreadsheet: 146606d1332269324-probl-me-excel-2007-essais
Sheet: Pointages

 |  | entré | pause | reprise | depart
Lundi | 2012-02-02 00:00:00
Mardi |  | 06:00:00 | 12:00:00 | 13:00:00 | 17:00:00
Mercredi |  | 05:00:00 | 12:00:00 | 12:30:00 | 16:00:00
Jeudi |  | 05:00:00 | 12:00:00 | 13:00:00 | 15:45:00
Vendredi |  | 07:30:00 | 12:00:00 | 12:30:00 | 15:30:00
 |  | Bonjour,
 |  | Je vous laisse mon problème car cela déjà un bon moment que je suis dessus
 |  | Et pas de solution
 |  | J’explique j’ais voulue  cacher mes formules
 |  | 1)      [NAME] affichage [NAME] je protège [NAME]
 |  | Mais quand on clics deux sur une des cellules police rouge les formules s’affiche
 |  | 2)      Fait les manipes que j’ais trouver [NAME] me bloc aussi les [NAME]
 |  | Car cela on a besoin. |  |  |  | Format cellule protection masqué
 |  | Ceci et une fiche de pointage travail
 |  | Ma demande ci possible de faire cela et comment
 |  | En vous remercient
07:00:00
08:00:00
06:00:00
4
06:00:00
Spreadsheet: 162432d1339868009-the-old-dreaded-inconsistant-formula-error-but-only-when-sorted-euro-challenge-2012
Sheet: Sheet2

 | 1 | 2 | 3 | Q | S | F | total |  |  |  | NAME | 1 | 2 | 3 | 4 | 5 | TOTAL
HOL | 0 | 1 |  |  |  |  |  |  |  | 1 | CAZ
SPA | 3 | 9 |  |  |  |  |  |  |  |  | GREG
GER | 6 | 7 |  |  |  |  |  |  |  |  | STEVE
ENG | 3 | 8 |  |  |  |  |  |  |  |  | [NAME]
ITA | 3 | 3 |  |  |  |  |  |  |  |  | BRAD
POR | 0 | 8 |  |  |  |  |  |  |  |  | VICKY
FRA | 3 | 7 |  |  |  |  |  |  |  |  | SUE + LEWIS
DEN | 6 | 2 |  |  |  |  |  |  |  |  | PHIL
RUS | 9 | 3 |  |  |  |  |  |  |  |  | DAN
SWE | 1 | 1 |  |  |  |  |  |  |  |  | IAN
CRO | 8 | 3 |  |  |  |  |  |  |  |  | FAZ
POL | 3 | 3 |  |  |  |  |  |  |  |  | [NAME]
UKR | 7 | 7 |  |  |  |  |  |  |  |  | PETE + EMILY
GRE | 3 | 1 |  |  |  |  |  |  |  |  | DAVE
IRE | 1 | 0 |  |  |  |  |  |  |  |  | JO
CZE | 2 | 7
SCORING -
TEAM WIN | 5
TEAM DRAW | 2
GOAL SCORED | 1
HATRICK SCORED | 3
WIN ON PENALTIES | 2
PENALTY MISS | -1
SENDING OFF | -3
Spreadsheet: 729774d1619336950-solver-error-linearity-condition-not-satisfied-solver-issue-hydr2-
Sheet: Funding Curve-wo SOFR Floor

Months | Days |  | Lowest yield for the tenor | Funding |  |  | 3m Gap | 12m Gap
 |  | Overnight
 |  | 1 Week
 |  | 2 Week |  |  |  |  |  |  |  |  |  |  | Total Asset | 12m gap | 3m gap |  | 12m gap limit | 3m gap limit
 |  | 3 Week |  | cont vars | [NAME] | constr |  |  |  |  |  |  | E39+E36 | E45-sum(E7:E14) | E44-sum(E7:E9)
1 | 30 | 1 Month | 0.1499921880970589 | 0 | 0 |  |  |  |  | 0.99999999 | -0.315 | -0.165
2 | 60 | 2 Month | 0.05142535743754958 | 0 | 0
3 | 90 | 3 Month | 0.0415358656226362 | 2899578.337327957 | 1
4 | 120 | 4 Month | 0.05178505055405636 | 1797100421.662672 | 1
5 | 150 | 5 Month | 0.05341400000000011 | 0 | 0
6 | 180 | 6 Month | 0.05805846866577311 | 0 | 0
9 | 270 | 9 Month | 0.06113831128176777 | 0 | 0
12 | 360 | 12 Month | 0.06532952543854087 | 0 | 0
15 | 450 | 15 Month | 0.07764567626600562 | 0 | 0
18 | 540 | 1.5 Year | 0.09473121382073554 | 0 | 0
21 | 630 | 21 Month | 0.1166139807313168 | 0 | 0
24 | 720 | 2 Year | 0.1460715967314424 | 0 | 0
27 | 810 | 2.25 Year | 0.1990664705169304 | 0 | 0
30 | 900 | 2.5 Year | 0.2415960313319841 | 0 | 0
33 | 990 | 2.75 Year | 0.2829875848385338 | 0 | 0
36 | 1080 | 3 Year | 0.3253200870459851 | 0 | 0
42 | 1260 | 3.5 Year | 0.4688626149360396 | 0 | 0
48 | 1440 | 4 Year | 0.610853980699978 | 0 | 0
 |  |  | Total Funding
 |  |  | Total Count
 |  |  | Total Cost
 |  |  | Mission Asset Ratio | 0.724
 |  |  | 3m [NAME] | -0.1683
 |  |  | 12m [NAME] | -0.2804
 |  |  | Funding needs | 1800000000
 |  |  | Assets | 89121339897.78
 |  |  | COs | 79683360000
 |  |  | UST | 1811487395.43
 |  |  | Advances | 48737128947.36
 |  |  | 3m Gap | -14999121504.79637
 |  |  | 12m Gap | -24989623707.33751
Spreadsheet: 883416d1732037704-formula-to-count-conditionally-formatted-cells-formula-to-get-count-conditionally-formatted-cells
Sheet: Sheet1

Resource | Variable | WD+5 | Mid-Month | WD-7 | WD-3 | WD+0 | [NAME]
- | resource cost | 0 | 0 | 0 | 0 | 0 | 0
- | sales rate | 0 | 0 | 0 | 0 | 0 | 0
- | Sum of P1 Resource Usage (Delivery) | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0
A | resource cost | 61.73 | 61.73 | 60 | 61.73 | 61.73 | 2
A | sales rate | 0 | 0 | 0 | 0 | 0 | 0
A | Sum of P1 Resource Usage (Delivery) | 19 | 19 | 19 | 19 | 19 | 0
 |  |  |  |  |  |  | 0
B | resource cost | 216.53 | 216.53 | 216.53 | 216.53 | 216.53 | 0
B | sales rate | 510 | 510 | 510 | 510 | 510 | 0
B | Sum of P1 Resource Usage (Delivery) | 19 | 19 | 19 | 19 | 19 | 0
 |  |  |  |  |  |  | 0
C | resource cost | 324.52 | 324.52 | 324.52 | 324.52 | 275 | 1
C | sales rate | 0 | 0 | 0 | 0 | 0 | 0
C | Sum of P1 Resource Usage (Delivery) | 19.88 | 19.88 | 19.88 | 19.88 | 19.88 | 0
 |  |  |  |  |  |  | 0
D | resource cost | 516.4300000000001 | 516.4300000000001 | 490.56 | 495.56 | 516.4300000000001 | 3
D | sales rate | 930 | 930 | 930 | 930 | 930 | 0
D | Sum of P1 Resource Usage (Delivery) | 21.25 | 21.25 | 21.25 | 21.25 | 21.25 | 0
 |  |  |  |  |  |  | 0
E | resource cost | 1391.45 | 1391.45 | 1391.45 | 1391.45 | 1391.45 | 0
E | sales rate | 675 | 675 | 675 | 675 | 675 | 0
E | Sum of P1 Resource Usage (Delivery) | 6.39 | 6.39 | 6.39 | 6.39 | 6.39 | 0
 |  |  |  |  |  |  | 0
F | resource cost | 167.21 | 167.21 | 167.21 | 167.21 | 159 | 1
F | sales rate | 405 | 405 | 405 | 405 | 405 | 0
F | Sum of P1 Resource Usage (Delivery) | 19 | 19 | 19 | 19 | 19 | 0
 |  |  |  |  |  |  | 0
G | resource cost | 507.79 | 507.79 | 507.79 | 515 | 507.79 | 2
G | sales rate | 675 | 675 | 675 | 675 | 675 | 0
G | Sum of P1 Resource Usage (Delivery) | 19 | 19 | 19 | 19 | 19 | 0
 |  |  |  |  |  |  | 0
H | resource cost | 773.28 | 773.28 | 724.22 | 773.28 | 701.06 | 3
H | sales rate | 2006.44 | 2006.44 | 2006.44 | 2006.44 | 2006.44 | 0
H | Sum of P1 Resource Usage (Delivery) | 20.88 | 20.88 | 20.88 | 20.88 | 20.88 | 0
 |  |  |  |  |  |  | 0
I | resource cost | 206.05 | 206.05 | 206.05 | 206.05 | 206.05 | 0
I | sales rate | 0 | 0 | 0 | 0 | 0 | 0
I | Sum of P1 Resource Usage (Delivery) | 19 | 19 | 19 | 19 | 19 | 0
Spreadsheet: 827892d1683107928-distribute-automatically-and-equitly-on-excel-in-a-certain-number-of-cells-the-result-o-distribute-automatically-and-equitly-on-excel-in-a-certain-number-of-cells-the-result-0
Sheet: bsalv

Products | Cost | Shipping Cost | TOTAL
Product A | 19.99
Product B | 19.99
Product C | 160.99
Product D | 160.99
Product E | 12.95
Product F | 12.95
Total of shipping cost | Quantity of product | Shipping cost for each product | extra
14.6 | 6
Spreadsheet: 794755d1662298324-count-the-number-of-days-from-arrival-to-current-date-sample
Sheet: Sheet1

 | FORMULA HERE | AUGUST 2022 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEPTEMBER 2022
 | # of days (from arrival to current date) | 2022-08-01 00:00:00 | 2022-08-02 00:00:00 | 2022-08-03 00:00:00 | 2022-08-04 00:00:00 | 2022-08-05 00:00:00 | 2022-08-06 00:00:00 | 2022-08-07 00:00:00 | 2022-08-08 00:00:00 | 2022-08-09 00:00:00 | 2022-08-10 00:00:00 | 2022-08-11 00:00:00 | 2022-08-12 00:00:00 | 2022-08-13 00:00:00 | 2022-08-14 00:00:00 | 2022-08-15 00:00:00 | 2022-08-16 00:00:00 | 2022-08-17 00:00:00 | 2022-08-18 00:00:00 | 2022-08-19 00:00:00 | 2022-08-20 00:00:00 | 2022-08-21 00:00:00 | 2022-08-22 00:00:00 | 2022-08-23 00:00:00 | 2022-08-24 00:00:00 | 2022-08-25 00:00:00 | 2022-08-26 00:00:00 | 2022-08-27 00:00:00 | 2022-08-28 00:00:00 | 2022-08-29 00:00:00 | 2022-08-30 00:00:00 | 2022-08-31 00:00:00 | 2022-09-01 00:00:00 | 2022-09-02 00:00:00 | 2022-09-03 00:00:00 | 2022-09-04 00:00:00 | 2022-09-05 00:00:00 | 2022-09-06 00:00:00 | 2022-09-07 00:00:00 | 2022-09-08 00:00:00 | 2022-09-09 00:00:00 | 2022-09-10 00:00:00 | 2022-09-11 00:00:00 | 2022-09-12 00:00:00 | 2022-09-13 00:00:00 | 2022-09-14 00:00:00 | 2022-09-15 00:00:00 | 2022-09-16 00:00:00 | 2022-09-17 00:00:00 | 2022-09-18 00:00:00 | 2022-09-19 00:00:00 | 2022-09-20 00:00:00 | 2022-09-21 00:00:00 | 2022-09-22 00:00:00 | 2022-09-23 00:00:00 | 2022-09-24 00:00:00 | 2022-09-25 00:00:00 | 2022-09-26 00:00:00 | 2022-09-27 00:00:00 | 2022-09-28 00:00:00 | 2022-09-29 00:00:00 | 2022-09-30 00:00:00
Adams | 12 |  | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
[NAME] | 0 |  | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 1
[NAME] | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 3 | 3 | 3 | 3 | 3
[NAME] | 6 | 3 | 3 | 3 | 3 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 3 | 3 | 3 | 3
Evans | 4 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 1 |  |  |  |  |  | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 1 |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 3 | 3
[NAME] | 0
[NAME] | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 1
Hills | 35 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
1 | DEPART
2 | [NAME]
3 | WHOLE DAY
Spreadsheet: 82860d1282856571-scan-schedule-and-populate-cells-with-names-scheduleanswer
Sheet: Sheet1

This will be a workbook by itself
 |  |  |  |  |  |  |  |  | This is a separate workbook
 | Topleft | 2010-08-27 00:00:00 | 2010-08-28 00:00:00 | 2010-08-29 00:00:00
 | Mark | Day |  | Eve |  |  |  |  |  | Who is working : |  | 2010-08-28 00:00:00
 | [NAME] | Eve | Eve | Night
 | [NAME] | Night | Night |  |  |  |  |  |  | Day | [NAME]
 | [NAME] |  | Day | Day
 |  |  |  |  |  |  |  |  |  | Eve | [NAME]
 |  |  |  |  |  |  |  |  |  | Night | [NAME]
 |  | 2010-08-27 00:00:00 | 2010-08-28 00:00:00 | 2010-08-29 00:00:00
 | Day | Mark | [NAME] | [NAME]
 | Eve | [NAME] | [NAME] | Mark
 | Night | [NAME] | [NAME] | [NAME] |  |  |  |  |  | #N/A
 | I need a formula that populates cell L9, L11 and [NAME] with employee names.
 | I would like to input a formula into [NAME] that populates itself with the name of the person working.
 | To find out who is working the formula would have to search column C7:C10 and look for the word "Day"
 | Once it finds the word "Day" it needs to take the name associated with the row. In this case '[NAME]' and populate [NAME] with that name.
 | same for eve and night
 | Example)
 | Find Evening shift on 28th. ***
 | Scan Column D7:D10 for word 'Eve'. |  |  |  |  |  |  |  |  |  |  |  | vvvvv   Pivot Tables didn't work.
 | Since Eve is located at D8. It needs to send the string located at B8 to cell [NAME].
 | *** Bonus Code:
 | By entering a date into M7, the code would know which column to scan between C6 : E6
 |  | I'm sure I could do it with a little code.  To a different sheet?
Date/Shift | Day | Eve | Night | <<<<< These formulas worked a little.
2010-08-27 00:00:00 | Mark | [NAME] | [NAME] | I need to look at one of those fancy [NAME] formulas
2010-08-28 00:00:00 | [NAME] | [NAME] | [NAME]
2010-08-29 00:00:00 | [NAME] | Mark | [NAME]
Spreadsheet: 159412d1338626564-sort-data-with-formula-example-sorting-table-2-
Sheet: Sheet1

 | Supplier name | Shipment number | Date | Volume |  |  |  | Date | Supplier name | Volume
 | Supplier 1 | Shipment 1 | Jan | 10 |  |  |  | Jan | Supplier 1 | 10
 | Supplier 1 | Shipment 2 | Mar | 12 |  |  |  | Feb | Supplier 3 | 6
 | Supplier 1 | Shipment 3 | Apr | 8 |  |  |  | Mar | Supplier 1 | 12
 | Supplier 1 | Shipment 4 | Dec | 7 |  |  |  | Apr | Supplier 1 | 8
 | Supplier 2 | Shipment 1 | Jan 13 | 5 |  |  |  | May
 | Supplier 2 | Shipment 2 | Apr | 3 |  |  |  | Jun
 | Supplier 3 | Shipment 1 | Feb | 6 |  |  |  | Jul
 | Supplier 3 | Shipment 2 | Mar | 9 |  |  |  | Aug
 | Supplier 3 | Shipment 3 | Apr | 10 |  |  |  | Sep
 | Supplier 3 | Shipment 4 | Nov | 20 |  |  |  | Oct
 | Supplier 3 | Shipment 5 | Dec | 2 |  |  |  | Nov | Supplier 3 | 20
 | Supplier 6 |  | Mar | 66 |  |  |  | Dec | Supplier 1 | 7
 |  |  |  |  |  |  |  | Date | Supplier name | Volume
 |  |  |  |  |  |  |  | Mar | Supplier 1 | 12
 |  |  |  |  |  |  |  |  | Supplier 3 | 9
 |  |  |  |  |  |  |  |  | Supplier 6 | 66
Spreadsheet: eric_saibi__9726__010902R
Sheet: Hatch 02

Owner Name |  | Georgia Power Company
Station Name |  | Edwin I Hatch Nuclear Power Station
Unit Name |  | Hatch 02
NERC Region |  | SERC
State |  | GA
Fuel Type |  | Nuclear
Capacity |  | 865
Start Date |  | 2001-12-25 00:00:00
End Date |  | 2002-01-11 00:00:00
Prv. Start Date |  | 2001-12-25 00:00:00
Prv. End Date |  | 2002-01-09 00:00:00
Comments |  | Problem with the steam bypass valve. Plan to test unit tomorrow and be back online Friday.
SIC |  | 4911
Plant ID |  | 1012040
Unit ID |  | 1004272
Outage ID |  | 19297
Spreadsheet: 72467d1273154710-filter-by-intersecting-columns-emails
Sheet: Valid emails

[NAME]
[NAME]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[NAME]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
Spreadsheet: 65665672-18b4-4d7a-acd1-ec51c5681bf9
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259731 | 12798 | Carolina | [NAME] | BRA | 1 | [NAME] | 00:00:29 | 01:11:27 | [NAME] | 00:36:44 | 1 | 02:10:45
259731 | 30828 | [NAME] | [NAME] | GUA | 3 | [NAME] | 00:00:29 | 01:11:17 | 00:00:22 | 00:37:57 | 2 | 02:11:52
259731 | 22214 | [NAME] | [NAME] | CHI | 4 | 00:26:30 | 00:00:32 | 01:11:26 | 00:00:20 | 00:45:06 | 3 | 02:18:54
259731 | 75362 | Cecilia | Laconi | ARG | 5 | 00:32:10 | 00:00:54 | 01:15:50 | 00:00:24 | 00:40:56 | 4 | 02:25:14
Spreadsheet: 163921d1340546608-repeat-data-set-when-time-changes-1to35-with-time
Sheet: Sheet1

[NAME] |  | Shift |  |  |  | Array
2012 | 1 | N |  |  |  | 1 | N
 | 2 | N |  |  |  | 2 | N
 | 3 | N |  |  |  | 3 | N
 | 4 |  |  |  |  | 4
 | 5 | V |  |  |  | 5 | V
 | 6 | V |  |  |  | 6 | V
 | 7 | V |  |  |  | 7 | V
 | 8 |  |  |  |  | 8
 | 9 |  |  |  |  | 9
 | 10 | L |  |  |  | 10 | L
 | 11 | L |  |  |  | 11 | L
 | 12 | L |  |  |  | 12 | L
 | 13 |  |  |  |  | 13
 | 14 | L |  |  |  | 14 | L
 | 15 | L |  |  |  | 15 | L
 | 16 | L |  |  |  | 16 | L
 | 17 |  |  |  |  | 17
 | 18 |  |  |  |  | 18
 | 19 | N |  |  |  | 19 | N
 | 20 | N |  |  |  | 20 | N
 | 21 | N |  |  |  | 21 | N
 | 22 |  |  |  |  | 22
 | 23 |  |  |  |  | 23
 | 24 | V |  |  |  | 24 | V
 | 25 | V |  |  |  | 25 | V
 | 26 | V |  |  |  | 26 | V
 | 27 |  |  |  |  | 27
 | 28 |  |  |  |  | 28
 | 29 | N |  |  |  | 29 | N
 | 30 | N |  |  |  | 30 | N
 | 31 | N |  |  |  | 31 | N
 | 32 |  |  |  |  | 32
 | 33 |  |  |  |  | 33
 | 34 |  |  |  |  | 34
 | 35 |  |  |  |  | 35
 | 1 | N
 | 2 | N
 | 3 | N
Spreadsheet: 223058d1364034678-2-different-data-bases-that-need-to-be-match-buy-there-memeber-number-jk34
Sheet: Sheet1

1 | a | b | 23 | 45 | 1 | a | b | 25 | 45 |  |  |  |  | 1 | a | b | 25 | 45
2 | d | d | 29 | 59 | 3 | b | f | 12 | 22 |  |  |  |  | 3 | b | f | 12 | 22
3 | a | a | 34 | 23 | 4 | q | f | 34 | 36 |  |  |  |  | 4 | q | f | 34 | 36
5 | a | a | 34 | 34 | 7 | q | r | 35 | 67 |  |  |  |  | 7 | q | r | 35 | 67
6 | r | m | 23 | 30 | 9 | w | n | 39 | 80 |  |  |  |  | 9 | w | n | 39 | 80
7 | a | b | 26 | 36 | 10 | d | d | 23 | 12 |  |  |  |  | 10 | d | d | 23 | 12
9 | w | n | 34 | 34 | 11 | e | t | 25 | 26 |  |  |  |  | 11 | e | t | 25 | 26
10 | e | g | 23 | 32 | 12 | k | l | 25 | 28 |  |  |  |  | 12 | k | l | 25 | 28
12 | l | p | 59 | 67 | 13 | j | k | 36 | 35 |  |  |  |  | 13 | j | k | 36 | 35
Spreadsheet: 839273d1691778653-if-match-then-pull-data-matchnamethenpull
Sheet: Sheet2

What is your first name and last initial? |  |  |  |  | Backyard animal
Emily J |  |  |  |  | Raccoon
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | Chipmunks
Liam R |  |  |  |  | Bats
Sophia C |  |  |  |  | Squirrels
[NAME] T |  |  |  |  | Groundhog or [NAME]
Isabella C |  |  |  |  | [NAME]
[NAME] |  |  |  |  | Eastern Cottontail Rabbit
Ava D |  |  |  |  | Opossum
Noah T |  |  |  |  | Fox
Spreadsheet: 142989d1330110847-using-a-countif-formula-series-inputs-
Sheet: Sheet1

 | The Help needed - A formula to find how many times the content of a series is the same as the content of another series in their corresponding cells
 | the formula should work on numbers as well as alphabets
 |  |  |  |  |  |  |  |  | Series 1 | Series 2 | Series 3 | Series 4 | Series 5 | Series 6 | Series 7 | Series 8
 | Series 1 | 1 | 0 | 1 | 0 |  |  | No. of Times the Series  = Series 1 | 5 | 2 | 2 | 2
 | Series 2 | 1 | 1 | 1 | 1 |  |  | No. of Times the Series  = Series 2 |  | 5
 | Series 3 | 0 | 1 | 1 | 0 |  |  | No. of Times the Series  = Series 3 |  |  | 5
 | Series 4 | 1 | 0 | 0 | 1 |  |  | No. of Times the Series  = Series 4 |  |  |  | 5
 | Series 5 | 0 | 0 | 1 | 1 |  |  | No. of Times the Series  = Series 5 |  |  |  |  | 5
 | Series 6 | 1 | 0 | 1 | 0 |  |  | No. of Times the Series  = Series 6 |  |  |  |  |  | 5
 | Series 7 | 0 | 1 | 0 | 0 |  |  | No. of Times the Series  = Series 7 |  |  |  |  |  |  | 5
 | Series 8 | 0 | 1 | 1 | 0 |  |  | No. of Times the Series  = Series 8 |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  | Please input the formula in the cells shaded grey
 |  |  |  |  |  |  |  | I filled in the grey areas with some examples - The number of times Series 1 = Series 1 is 5 times. The  number of times Series 2 = Series 1 is 2,  Series 3 = Series 1 is 2 as well etc.
Spreadsheet: 154893d1336591618-lookup-value-from-row-and-return-higher-if-not-available-lookup-value-in-a-row-and-return-higher
Sheet: Sheet1

H
50
a | 81 | 16 | 51 | 9 | 63 | 59 | 39 | 30 | 21
b | 50 | 72 | 9 | 25 | 34 | 31 | 54 | 69 | 52
c | 6 | 30 | 60 | 30 | 31 | 6 | 38 | 72 | 44
d | 85 | 73 | 44 | 79 | 85 | 6 | 54 | 21 | 12
e | 59 | 56 | 69 | 82 | 68 | 23 | 72 | 44 | 88
f | 57 | 7 | 70 | 76 | 29 | 46 | 86 | 16 | 47
g | 64 | 28 | 35 | 60 | 46 | 30 | 25 | 23 | 59
h | 84 | 51 | 40 | 52 | 35 | 99 | 50 | 62 | 24
i | 82 | 90 | 66 | 83 | 13 | 31 | 41 | 10 | 34
j | 33 | 20 | 71 | 57 | 19 | 64 | 36 | 51 | 68
k | 59 | 49 | 50 | 35 | 48 | 64 | 66 | 54 | 85
l | 68 | 16 | 6 | 67 | 42 | 52 | 65 | 83 | 44
Spreadsheet: 39858d1238112099-inserting-a-line-on-my-reference-sheet-test-for-help
Sheet: Event Announcements

Event Announcements
Sponsor Company Name | Sponsor Company Contact Name | Sponsor Contact Email | Sponsor Address | Sponsor Phone | Description | Quantity | Column1 | Column2
1 | 1 | 1 | 1 | 1 | 15-sec Stage Advertising | 1
3 | 3 | 3 | 3 | 3 | 15-sec Stage Advertising | 1
4 | 4 | 4 | 4 | 4 | 15-sec Stage Advertising | 1
 |  |  |  |  | 0
 |  |  |  |  | 0
Spreadsheet: 726049d1617028515-pulling-data-at-the-end-of-a-business-day-sample2
Sheet: TalentDashboard

 |  | Talent [NAME]
 |  |  |  |  |  |  | Select Position Type to Update Data Below: |  | 1 | 2
 |  |  | Applications & Hiring |  |  | Applicants | Current Staff |  |  | Applicants | Current Staff
 |  | Total  Applicants |  | Unique Applicants |  | Age
 |  | Total Positions |  | Avg Days To Fill |  | Gender
 |  |  | Retention |  |  | Experience