tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 811870d1672845190-need-help-to-look-in-and-out-latest-entry-revised-example-1-1-
Sheet: Data

Emp. Number | Emp. Name | Designation | Department | Date | Time | Status |  | Expected Results |  |  |  |  | IN |  |  |  | OUT
123 | ABC | SUPERVISOR | [NAME] | 2022-11-24 00:00:00 | 08:05:00 | I |  | On Time IN |  |  |  |  | Start | End | Description |  | Start | End | Description
123 | ABC | SUPERVISOR | [NAME] | 2022-11-24 00:00:00 | 20:08:00 | O |  | On Time Out |  |  |  |  | 07:00:00 |  | On Time IN |  | 12:00:00 | 16:00:00 | Early Out
234 | ABCDE | SUPERVISOR | Store | 2022-11-24 00:00:00 | 08:02:44 | I |  | On Time IN |  |  |  |  | 08:31:00 | 11:59:00 | Late Arrivals |  | 16:01:00 | 22:00:00 | On Time Out
234 | ABCDE | SUPERVISOR | Store | 2022-11-24 00:00:00 | 12:06:43 | O |  | Early Out
345 | AB | SUPERVISOR | QA | 2022-11-24 00:00:00 | 08:02:09 | I |  | Double Entry
345 | AB | SUPERVISOR | QA | 2022-11-24 00:00:00 | 08:22:02 | O |  | Double Entry
345 | AB | SUPERVISOR | QA | 2022-11-24 00:00:00 | 08:23:48 | I |  | On Time IN |  |  |  |  | I= | IN
345 | AB | SUPERVISOR | QA | 2022-11-24 00:00:00 | 19:03:24 | O |  | On Time Out |  |  |  |  | O= | OUT
567 | [NAME] | HELPER | Finishing | 2022-11-24 00:00:00 | 07:45:38 | I |  | Double Entry
567 | [NAME] | HELPER | Finishing | 2022-11-24 00:00:00 | 07:53:01 | O |  | Double Entry |  |  |  |  | [NAME] first check by Employee Number that have both IN and OUT in the same date. Then show that the employee is on time or not. IF there are more than one entries of this type then the last entry should be considered like I highligted with [NAME]. If IN or OUT is missing then formula show me that this employee in this date one entry is missing
567 | [NAME] | HELPER | Finishing | 2022-11-24 00:00:00 | 07:56:32 | I |  | On Time IN
567 | [NAME] | HELPER | Finishing | 2022-11-24 00:00:00 | 19:00:47 | O |  | On Time Out
648 | ADON | SAMPLE MAKER | Sample | 2022-11-25 00:00:00 | 09:51:21 | I |  | Late Arrivals
648 | ADON | SAMPLE MAKER | Sample | 2022-11-25 00:00:00 | 17:00:32 | O |  | On Time Out
714 | KHAMI | SUPERVISOR | [NAME] | 2022-11-25 00:00:00 | 08:06:37 | I |  | On Time IN
714 | KHAMI | SUPERVISOR | [NAME] | 2022-11-25 00:00:00 | 19:57:12 | O |  | On Time Out
567 | [NAME] | HELPER | Finishing | 2022-11-25 00:00:00 | 07:56:32 | I |  | On Time IN
567 | [NAME] | HELPER | Finishing | 2022-11-25 00:00:00 | 13:00:00 | O |  | Early Out
345 | [NAME] | HELPER | Finishing | 2022-11-26 00:00:00 | 17:00:00 | O |  | On Time Out
345 | [NAME] | HELPER | Finishing | 2022-11-26 00:00:00 | 08:04:00 | I |  | On Time IN
714 | KHAMI | SUPERVISOR | [NAME] | 2022-11-26 00:00:00 | 08:06:37 | I |  | On Time IN
Spreadsheet: 8289e7f7-cc15-40d8-9b99-905e1f416edd
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7469 | 57792 | Makoto | Shinsei | JPN | 0 | 00:20:04 | 00:01:58 | 01:21:17 | 00:01:53 | [NAME] | 1 | 03:06:17
Spreadsheet: 883806d1732536658-looking-for-match-index-formula-test-file
Sheet: To achieve

Article number | W33, 2024 | W36, 2024 | W37, 2024 | W39, 2024 | W40, 2024 | W41, 2024 | W42, 2024 | W43, 2024 | W44, 2024 | W45, 2024 | W46, 2024 | W47, 2024 | W48, 2024 | W49, 2024 | W50, 2024 | W51, 2024 | W52, 2024
6645
6938
1131
1948
1854
1275
3095
2079
1987
2265
6193
760
2898
1824
5776
5109
1449
1097
4802
3149
3142
6764
2236
2438
4087
4220
4216
1216
4070
5429
4857
841
2706
748
5616
5706
2237
1876
3141
6859
3136
2739
6423
2594
2779
1253
3251
2138
3736
4080
6346
1757
5854
3302
2008
6144
6160
3398
4587
747
2576
3723
3153
4700
3191
2677
3371
6978
5609
729
4577
863
6981
1910
6023
2362
3200
1959
2737
5673
4213
1551
1738
4855
2632
5608
2758
2902
5371
6877
2729
5948
6960
1169
6091
3335
3642
4196
3705
Spreadsheet: 837579d1690269672-add-hours-that-cross-midnight-test
Sheet: Sheet1

 | Employee enters Start Time | Employee enters End Time |  | Adds B and C for duration |  | Employee makes a choice | Employee makes a choice | Subtracts F from G and H
 | Travel Times |  | Reason for Stop | Travel Hours | Did you work? | Hours | Meal Period | Travel Comp Hours
 | Start | Stop |  |  |  | Worked
 | 04:35:00 | 22:17:00 | Awaiting Transportation |  | Yes | 08:00:00 | 00:30:00
 |  | 0:30:00 | Waiting Period
 |  | 2:43:00
 |  |  | Waiting Period
 |  |  | Waiting Period
Spreadsheet: 157719d1337856249-index-match-vlookup-returning-values-from-worksheets-based-upon-matching-cells-ef99_test1
Sheet: Sheet5

MATCHES | [NAME] | Material | Short Text | OPEN QUANTITY | DEL. DATE | LATEST COMMENT (Col I)
Spreadsheet: 06e4ca5e-d985-4ca7-a04d-44f351ed6a9b
Sheet: Sheet1

Grid Screen MPD (HR2-215) - Scoring Sheet | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Sample: |  | 1 [NAME] |  | 6 Needles 1D
Buffer: |  | 2 Phase Separation |  | 7 Plates 2D
Reservoir Volume: |  | 3 Regular Granular Precipitate |  | 8 Xtal <0.2 mm
[NAME]: |  | 4 Birefringent Precipitate |  | 9 Xtal >0.2 mm
Temperature: |  | 5 Spherulites
[NAME]:
Temperature: |  | Date | Date | Date
A1.  0.1 M Citric Acid pH 4.0, 10% MPD
A2.  0.1 M Sodium Acetate pH 5.0, 10% MPD
A3.  0.1 M MES pH 6.0, 10% MPD
A4.  0.1 M HEPES pH 7.0, 10% MPD
A5.  0.1 M Tris pH 8.0, 10% MPD
A6.  0.1 M Bicine pH 9.0, 10% MPD
B1.  0.1 M Citric Acid pH 4.0, 20% MPD
B2.  0.1 M Sodium Acetate pH 5.0, 20% MPD
B3.  0.1 M MES pH 6.0, 20% MPD
B4.  0.1 M HEPES pH 7.0, 20% MPD
B5.  0.1 M Tris pH 8.0, 20% MPD
B6.  0.1 M Bicine pH 9.0, 20% MPD
C1.  0.1 M Citric Acid pH 4.0, 40% MPD
C2.  0.1 M Sodium Acetate pH 5.0, 40% MPD
[NAME]0.1 M MES pH 6.0, 40% MPD
C4.  0.1 M HEPES pH 7.0, 40% MPD
C5.  0.1 M Tris pH 8.0, 40% MPD
C6.  0.1 M Bicine pH 9.0, 40% MPD
D1.  0.1 M Citric Acid pH 4.0, 65% MPD
D2.  0.1 M Sodium Acetate pH 5.0, 65% MPD
D3.  0.1 M MES pH 6.0, 65% MPD
D4.  0.1 M HEPES pH 7.0, 65% MPD
D5.  0.1 M Tris pH 8.0, 65% MPD
D6.  0.1 M Bicine pH 9.0, 65% MPD
Spreadsheet: 876732d1723472081-excel-tables-question-tables2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | TRY 1 |  |  | TRY 2
 | Hdr A | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  |  | Return A | Return C |  | Return A | Return C
 | 6 | ACD | Elm | Why not |  | 425T |  |  |  |  |  |  | Elm
 | 11 | EDF | Maple | Because | Some blank | R342 |  |  |  |  |  | 11 | Maple
 | 156 | GHS | Elm | Maybe |  | 425T |  |  |  |  |  | 156 | Elm
 | 5 | TIF | Birch | I said so | But not | TR4 |  |  |  |  |  | 5 | Birch
 | 54 | KFSD | Pine | No | here | XSD |  |  |  |  |  | 54 | Pine
 | 21 | SF | Oak | Definitely not |  | 3860 |  |  |  |  |  | 21 | Oak
 | 33 | CEP | Elm | OK | Or | 425T |  |  |  |  |  | 33 | Elm
 | 4 | SF | Hickory | Fine | here | dfs |  |  |  |  |  | 4 | Hickory
 |  |  |  |  |  |  |  |  | TRY1A (Manual) |  |  | TRY 1A ([NAME])
 |  |  |  |  |  |  |  |  | Return C | Return F |  | Return C | Return F
 |  |  |  |  |  |  |  |  | Elm | 425T
 |  |  |  |  |  |  |  |  | Maple | R342
 |  |  |  |  |  |  |  |  | Birch | TR4
 |  |  |  |  |  |  |  |  | Pine | XSD
 |  |  |  |  |  |  |  |  | Oak | 3860
 |  |  |  |  |  |  |  |  | Hickory | dfs
Spreadsheet: 357079d1415295100-need-to-adjust-totals-proportionally-sample-workbook
Sheet: Sheet2

Sum of Hours |  |  | Date
Last name First name | Project definition | WBS Element | 10/6/2014 - 10/12/2014 | 10/13/2014 - 10/19/2014 | 10/20/2014 - 10/26/2014 | 10/27/2014 - 11/1/2014
LAST,FIRST1 |  |  | 40 | 40 | 40 | 40
 | Project1 |  | 36 | 40 | 40 | 12
 |  | P-2014-9001-02-01-01-B | 32 | 32 | 20 | 8
 |  | P-2014-9001-02-01-01-D | 4 | 8 |  | 4
 |  | P-2014-9001-02-01-01-F |  |  | 20
 | Project2 |  | 4
 |  | P-2012-0084-01-01-02 | 4
 | Project3 |  |  |  |  | 28
 |  | P-2014-0009-01-01-02 |  |  |  | 28
LAST,[NAME] |  |  | 40 | 68 | 60
 | Project4 |  | 40 | 68 | 60
 |  | P-2014-9030-02-01-30-D |  | 60 | 52
 |  | P-2014-9030-02-01-30-H | 40 | 8 | 8
LAST,FIRST3 |  |  | 42.5 | 40 | 42 | 42
 | Project5 |  | 42.5 | 40 | 42 | 42
 |  | P-2014-9039-02-01-39-D | 42.5 | 36 | 42 | 39
 |  | P-2014-9040-02-01-40-C |  |  |  | 3
 |  | P-2014-9040-02-01-40-H |  | 4
Spreadsheet: 93531d1293107076-excel-2007-need-help-with-a-concatenate-issue-upload-sample-bigd-
Sheet: Sheet1

 | Model | YR | Alpha | Serial # |  | Desired Results |  |  | What I am getting |  | BigD
 | 740 | 2008 | FB | 10059 |  | 740-08-FB10059 |  |  | 7408FB10059 |  | 740-08-FB10059
 | 540 | 2008 | A | 6035 |  | 540-08-A06035 |  |  | 5408A6035 |  | 540-08-A6035
 | 540 | 2008 | A | 6036 |  | 540-08-A06036 |  |  | 5408A6036 |  | 540-08-A6036
 | 740 | 2009 | CB | 10193 |  | 740-09-CB10193 |  |  | [NAME] |  | 740-09-CB10193
 | 420 | 2010 |  | 14682 |  | 420-10-14682 |  |  | 4201014682 |  | 420-10-14682
 | SA | 2010 |  | 14683 |  | SA-10-14683 |  |  | SA01014683 |  | SA-10-14683
Spreadsheet: 4ddac819-7724-4ba3-bddf-8437987d6d64
Sheet: Sheet1

Name of Unit | Degree | Professional | Current | Predicted | Difference | Performance | Director | Recommendation | Unnamed: 9 | Total | % Increase
 |  | Service | Salary | Salary |  | Rating |  |  |  | Salary
 |  |  |  |  |  |  | COLA | Merit | Equity
Agents |  | 2015-01-01 00:00:00 |  |  |  |  | 0 | Increase | Increase
 |  |  |  |  | 0 |  | 0 |  |  | 0
 |  |  |  |  | 0 |  | 0 |  |  | 0
 |  |  |  |  | 0 |  | 0 |  |  | 0
 |  |  |  |  | 0 |  | 0 |  |  | 0
 |  |  |  |  | 0 |  | 0 |  |  | 0
 |  |  |  |  | 0 |  | 0 |  |  | 0
 |  |  |  |  | 0 |  | 0 |  |  | 0
 |  |  |  |  | 0 |  | 0 |  |  | 0
 |  |  |  |  | 0 |  | 0 |  |  | 0
 |  |  |  |  | 0 |  | 0 |  |  | 0
 |  |  |  |  | 0 |  | 0 |  |  | 0
 |  |  |  |  | 0 |  | 0 |  |  | 0
Total Agent Salaries |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0
 | Professional |  |  |  |  |  | Hourly
 | Service | Annual | Hourly | Annual | COLA | Performance | Merit/Equity | New Hourly | Total | Total $ | % Increase
Staff | 2015-01-01 00:00:00 | Hours | Salary | Salary | 0 | Rating | Increase | Salary | Salary | Increase
 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0
Total Staff Salaries |  |  |  | 0 |  |  |  |  | 0 | 0
 |  |  | Agents | Staff | Total
Total Salaries |  |  | 0 | 0 | 0
Total Budgeted Salary Dollars |  |  | 0 |  | Additional Amount available --------> |  |  | 0
KSU 8-37 (November 2014)
Spreadsheet: 800198d1665534089-count-and-display-duplicates-in-an-array-display_duplicates-tms-ipad
Sheet: display_duplicates (3)

COUNT AND DISPLAY DUPLICATES OF A COLUMN |  |  | (case-sensitive)
array: | =A8:A30 | =A8:A1280
formula: |  |  |  | =LET(col, $A:$A, rng, $A$8:$A$1280, TEXTJOIN(", ", TRUE, UNIQUE(BYROW(rng, LAMBDA(rw, LET(a, INDEX(col, [NAME])), sp, SUMPRODUCT(- -EXACT(rng, a)),  IF(a="", "", IF(sp=1,"", sp &" " & a))))))))
expected result: | 2 A, 3 B, 2 b |  |  | =LET(rng, $A$8:$A$1280, [NAME], COUNTIF(rng, rng), [NAME](", ",TRUE,UNIQUE(IF(ci<2, "", ci & " " & rng))))
 |  |  |  | =LET(t,FILTER($A$8:$A$1000,$A$8:$A$1000<>""),z,MAKEARRAY(ROWS(t),1,LAMBDA(r,c,SUMPRODUCT(--EXACT(INDEX(t,r),t)))),ROWS(FILTER(t,z>1)))
grade | Count
B
C
D
E
a
B
F
z
b
B
G
1
xx
2
H
I
3
x
4
T
R
Z
5
6
7
8
9
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
Spreadsheet: sally_beck__35151__MgmtSum-Q3-0914_Global
Sheet: GM-WklyChnge

ENRON GLOBAL MARKETS
3RD QUARTER 2000 DETAIL OF GROSS MARGIN - WEEKLY CHANGE
Results based on activity through September 14, 2000
 |  |  |  |  |  |  | Actual | Deals | Forecast | Total
Business Team |  | DPR(1) | MPR | Accruals | Other | FTA | Margin | Identified | Margin | Margin
Liquids |  | 874 | 0 | 0 | 0 | 0 | 874 | 0 | 0 | 874
Coal |  | 2131 | -7463.598 | -12.834 | 0 | 0 | -5345.432 | 0 | 7000 | 1654.568
Emissions |  | 735 | 0 | 0 | 0 | 0 | 735 | 0 | 0 | 735
Weather |  | 258.8 | 0 | 0 | 0 | 0 | 258.8 | 0 | 0 | 258.8
Global Risk Markets |  | 0 | 229.707 | 0 | 0 | 0 | 229.707 | 0 | 0 | 229.707
Equity Trading |  | 1409.539000000001 | 0 | 0 | 0 | 0 | 1409.539000000001 | 0 | 0 | 1409.539000000001
FX / Int Rate Trading |  | 276 | 0 | 0 | 0 | 0 | 276 | 0 | 0 | 276
Subtotal Financial Trading |  | 1685.539000000001 | 0 | 0 | 0 | 0 | 1685.539000000001 | 0 | 0 | 1685.539000000001
Soft Commodities Trading |  | -4.69 | 0 | 0 | 0 | 0 | -4.69 | 0 | 0 | -4.69
Grain Trading |  | 26.33299999999999 | 0 | 0 | 0 | 0 | 26.33299999999999 | 0 | 0 | 26.33299999999999
Meat Trading |  | -0.351 | 0 | 0 | 0 | 0 | -0.351 | 0 | 0 | -0.351
Subtotal Agricultural Trading |  | 21.29199999999999 | 0 | 0 | 0 | 0 | 21.29199999999999 | 0 | 0 | 21.29199999999999
Office of the Chairman |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Overview |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Commercial |  | 5705.631000000001 | -7233.891 | -12.834 | 0 | 0 | -1541.093999999999 | 0 | 7000 | 5458.906000000002
Other Interest Related Charges |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Global Markets Pre-tax Income |  | 5705.631000000001 | -7233.891 | -12.834 | 0 | 0 | -1541.093999999998 | 0 | 7000 | 5458.906000000002
(1) Excludes Cap. Charge & Operating Costs
Spreadsheet: 673299d1587306569-formula-for-concurrent-activity-example
Sheet: Example

Row | Activity | Platform | Feature | User | Machine | COUNT
1 | OUT | Platform A | Feature B | User A | Machine C | 1
2 | OUT | Platform A | Feature A | User A | Machine C | 1
3 | IN | Platform A | Feature A | User A | Machine C | 1
4 | IN | Platform A | Feature B | User A | Machine C | 0
5 | OUT | Platform A | Feature B | User A | Machine C | 1
6 | out | Platform A | Feature B | User A | Machine C | 1
7 | OUT | Platform A | Feature A | User A | Machine C | 1
8 | out | Platform A | Feature B | User A | Machine C | 1
9 | in | Platform A | Feature B | User A | Machine C | 1
10 | OUT | Platform A | Feature B | User A | Machine A | 2
11 | OUT | Platform A | Feature A | User A | Machine A | 2
12 | out | Platform A | Feature B | User A | Machine A | 2
13 | in | Platform A | Feature B | User A | Machine C | 2
14 | OUT | Platform A | Feature C | User A | Machine B | 3
15 | out | Platform A | Feature C | User A | Machine B | 3
16 | out | Platform A | Feature C | User A | Machine B | 3
17 | out | Platform A | Feature C | User A | Machine B | 3
18 | in | Platform A | Feature B | User A | Machine A | 3
19 | in | Platform A | Feature C | User A | Machine B | 3
20 | in | Platform A | Feature C | User A | Machine B | 3
21 | in | Platform A | Feature C | User A | Machine B | 3
22 | OUT | Platform A | Feature B | User A | Machine B | 3
23 | OUT | Platform A | Feature A | User A | Machine B | 3
24 | IN | Platform A | Feature C | User A | Machine B | 3
25 | IN | Platform A | Feature A | User A | Machine C | 3
26 | IN | Platform A | Feature B | User A | Machine C | 2
27 | IN | Platform A | Feature A | User A | Machine A | 2
28 | IN | Platform A | Feature B | User A | Machine A | 1
29 | IN | Platform A | Feature A | User A | Machine B | 1
30 | IN | Platform A | Feature B | User A | Machine B | 0
Spreadsheet: 686c6258-6ace-493f-9bec-d753ac81b39c
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
POTA | Test | POTA | White Potato, IgE | White Potato, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
POTA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
POTA | Result | POTA | White Potato, IgE | White Potato, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6220-8
Spreadsheet: 0f27ccfd-3e3c-4954-8b96-44f92ff2ab59
Sheet: Sheet1

Unnamed: 0 | IMPERIAL VALLEY COLLEGE | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | MEN'S SOCCER SCHEDULE
 | FALL 2013
DAY | DATE | OPPONENT | PLACE | TIME
AUG 30 | FRIDAY | RIVERSIDE COLLEGE | RCC | 11:00:00
AUG 30 | FRIDAY | VICTOR VALLEY COLLEGE | VC | 16:00:00
SEPT 4 | WEDNESDAY | COLLEGE OF THE DESERT-Cancelled | IVC | 16:00:00
SEPT 21 | SATURDAY | ARIZONA WESTERN COLLEGE | IVC | 13:00:00
OCT 1 | TUESDAY | *CUYAMACA COLLEGE | CC | 15:15:00
OCT 2 | WEDNESDAY | COLLEGE OF THE DESERT | IVC | 5:00PM
OCT 4 | FRIDAY | *MIRA COSTA COLLEGE | MC | 15:15:00
OCT 8 | TUESDAY | *PALOMAR COLLEGE | IVC | 15:15:00
OCT 11 | FRIDAY | *SOUTHWESTERN COLLEGE | SW | 15:15:00
OCT 15 | TUESDAY | BYE | TBA | TBA
OCT 18 | FRIDAY | *SAN DIEGO CITY COLLEGE | SDCC | 15:15:00
OCT 22 | TUESDAY | *SAN DIEGO MESA COLLEGE | MC | 18:00:00
OCT 25 | FRIDAY | *CUYAMACA COLLEGE | IVC | 15:00:00
OCT 29 | TUESDAY | *MIRA COSTA COLLEGE | IVC | 15:00:00
NOV 1 | FRIDAY | *PALOMAR COLLEGE | PC | 15:00:00
NOV 5 | TUESDAY | *SOUTHWESTERN COLLEGE | IVC | 15:00:00
NOV 8 | FRIDAY | BYE | TBA | TBA
NOV 12 | TUESDAY | *SAN DIEGO CITY COLLEGE | IVC | 15:00:00
NOV 14 | THURSDAY | CHAFFEY COLLEGE | CC | 15:00:00
NOV 15 | FRIDAY | *SAN DIEGO MESA COLLEGE | IVC | TBA
* Denotes Conference Games |  | DH Denotes Double Headers
[NAME], Head Coach |  | (760) 355 - 6325
[NAME], Asst. Coach |  | (760) 355 - 6325
[NAME], Athletic Director |  | (760) 355 - 6341
[NAME], Secretary |  | (760) 355 - 6325
[NAME], [NAME] |  | (760) 355 - 6329
Athletic Fax |  | (760) 355 - 6514 |  | 2013-09-16 00:00:00
ATHLETICS DEPARTMENT 380 E. ATEN ROAD, IMPRIAL, CA 92251
Spreadsheet: 687533d1595263650-lookup-formula-to-output-all-values-tied-to-one-value-2020-07-20-oeldere-roaml-687530d1595261371-lookup-formula-to-output-all-values-tied-to-one-v
Sheet: Sheet1

Project:
PR556000
Project Num | WO Num | Location | Submit Date
PR556000 | WO 3444 | Palm Springs | 2020-03-01 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-02 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-03 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-04 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-05 00:00:00
PR556000 | WO 3444 | Palm Springs | 2020-03-06 00:00:00
How do I get the output of all of the values assocaited with the project number listed in the "Project" field?
Spreadsheet: 8c7a19ff-e47f-4335-a9e1-c06fd33349bb
Sheet: Identifiable School Goal 2

 |  |  | Integration Revenue Budget Worksheet
 |  |  |  |  | FY14
 |  |  | Racially Identifiable School(s) Budget: Goal 2
District Number: |  |  |  | District Name:
Please insert Identifiable School integration goal from your district's desegregation plan. Include the
Racially Identifiable School(s) addressed by this goal:
Line Item Description |  | UFARS | Code | (Required) |  | Budgeted Amount |  | Actual Expenditures
 |  |  |  |  |  |  |  | Resubmit this form with
Provide a short description |  |  |  |  |  | Provide the total amount |  | the actual FY14
of the expenditure. |  | ORG | PROG | FIN | OBJ | budgeted for this line item |  | expenditures by 12/1/14.
TOTAL
PARTICIPATION INFORMATION |  |  |  |  |  | Projected (7/1/13) |  | Actual
 |  |  |  |  |  | Students | Staff | Students | Staff
Participation from the Identifiable School(s):
Participation from Other Schools in the District:
Total Program Participation:
Notes or Comments:
Spreadsheet: 852043d1702124449-max-function-to-increment-numbers-on-estimating-sheet-3lusive-example
Sheet: REDESIGN

 | 8 | Roofing
 | Ref | Description | Quant | Unit | Rate | Subtotal | Notes
 |  | Roofing
 |  | item 1 | 646 | m2
 |  | item 2 | 157 | m
 |  | item 2 | 35 | m
 |  | item 4 | 646 | m2
 |  | item 5 | 1 | item
 |  | item 6 | 33 | m
Spreadsheet: 42316d1240918699-multiple-if-statements-in-one-cell-test-test
Sheet: Geleverd

 |  |  | 0 |  |  | 0
<name>
n/a
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Marjory Marjoryson
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] | PO? | Date | PM | Code | Source | Type | Pag. | Task | Delivery date | Client | Delivered by | DL TRA | Product ready? | To client | DL revisie | Received? | Paid? | Notes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ref doc: CM 623202 + new DV 707481 & 717949 for title and part 1 + new point 7 + Annex. Note: The annex has to be translated.