tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 807454d1669907494-index-match-data-from-two-tables-test1
Sheet: Sheet1

 | TABLE 1 |  |  |  |  |  |  |  |  |  |  |  |  | TABLE 2 |  |  |  |  |  |  | TABLE 3 - DESIRED ANSWER
Doc Number | R1 Baseline | R1 Forecast | R1 Actual | R1 Cancelled | [NAME] | [NAME] | A1 Actual | A1 Cancelled | [NAME] | [NAME] | C1 Actual | [NAME] |  | Planned  IDC | Forecast  IDC | Planned  AFC | Forecast  AFC | Planned  IFU | Forecast  IFU |  | Planned  IDC | Forecast  IDC | Planned  AFC | Forecast  AFC | Planned  IFU | Forecast  IFU
110-001 | A | H |  |  | O | V |  |  | CC | JJ |  |  |  | R1 Baseline | R1 Forecast | [NAME] | [NAME] | [NAME] | [NAME]
110-002 | B | I |  |  | P | W |  |  | DD | KK |  |  |  | R1 Baseline | R1 Forecast | [NAME] | [NAME] | [NAME] | [NAME]
110-003 | C | J |  |  | Q | X |  |  | EE | LL |  |  |  | [NAME] | [NAME] | R1 Baseline | R1 Forecast | [NAME] | [NAME]
110-004 | D | K |  |  | R | Y |  |  | FF | MM |  |  |  | [NAME] | [NAME] | R1 Baseline | R1 Forecast | [NAME] | [NAME]
110-005 | E | L |  |  | S | Z |  |  | GG | NN |  |  |  | [NAME] | [NAME] | R1 Baseline | R1 Forecast | [NAME] | [NAME]
110-006 | F | M |  |  | T | AA |  |  | HH | OO |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
110-007 | G | N |  |  | U | BB |  |  | II | PP |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Spreadsheet: ee5baa53-b6c4-4e2c-8379-6440bbc638cf
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
6504 | 41151 | [NAME] | Wersy | FRA | 562 | 00:23:50 | 00:01:43 | 00:46:06 | 00:01:37 | 00:09:09 | 1 | 01:22:23
6504 | 42399 | [NAME] | Smyth | IRL | 561 | 00:27:49 | 00:02:30 | 00:41:56 | 00:02:15 | 00:11:26 | 2 | 01:25:56
6504 | 40000 | [NAME] | [NAME] | GBR | 567 | 00:37:09 | 00:02:01 | 00:49:05 | 00:02:16 | 00:14:38 | 3 | 01:45:08
Spreadsheet: 816493d1675668341-vlookup-with-multiple-criteria-without-a-helper-column-test-vlookup
Sheet: Sheet1

helper | Desc | Val | st |  | line | a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z | Status
 | a | 18 | 1 |  | 1 | 18 | 2 | 2 | 3 | 0 | 2 | 1 | 2 | 1 | 3 | 1 | 2 | 1 | 3 | 26 | 2 | 0 | 22 | 0 | 22 | 2 | 32 | 2 | 4 | 2 | 2
 | a | 20 | 1 |  | 2 | 20 | 2 | 2 | 2 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 2 | 1 | 4 | 24 | 0 | 0 | 2 | 0 | 2 | 1 | 3 | 2 | 5 | 0 | 0
 | a | 10 | 1 |  | 3 | 10 | 2 | 2 | 222 | 0 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 24 | 0 | 2 | 2 | 0 | 2 | 1 | 3 | 1 | 5 | 0 | 2
 | a | 12 | 1 |  | 4 | 12 | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 0 | 0 | 0 | 0 | 22 | 1 | 4 | 2 | 0
 | a | 15 | 0 |  | 5 | 15 | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 2 | 0 | 2 | 1 | 22 | 1 | 4 | 2 | 0
 | a | 8 | 1 |  | 6 | 20 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 1 | 4 | 20 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 2 | 4 | 2 | 0
 | a | 14 | 1 |  | 7 | 15 | 2 | 2 | 22 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 1 | 2 | 21 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 2 | 4 | 2 | 0
 | a | 24 | 0 |  | 8 | 18 | 2 | 2 | 22 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 1 | 4 | 2 | 0
 | a | 22 | 0 |  | 9 | 8 | 2 | 0 | 22 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 24 | 0 | 0 | 2 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 2
 | b | 2 | 1 |  | 10 | 14 | 2 | 2 | 3 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 12 | 0 | 2 | 22 | 0 | 2 | 1 | 22 | 2 | 3 | 0 | 2
 | c | 2 | 1 |  | 11 | 14 | 2 | 0 | 22 | 0 | 22 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 4 | 0 | 22
 | c | 0 | 1 |  | 12 | 18 | 2 | 0 | 22 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 28 | 2 | 0 | 2 | 0 | 2 | 1 | 32 | 2 | 5 | 2 | 2
 | d | 3 | 0 |  | 13 | 20 | 2 | 0 | 22 | 0 | 22 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 25 | 0 | 0 | 22 | 0 | 2 | 1 | 2 | 1 | 4 | 0 | 22
 | d | 2 | 1 |  | 14 | 24 | 2 | 2 | 222 | 0 | 22 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 15 | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 22
 | d | 222 | 0 |  | 15 | 8 | 2 | 0 | 3 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 22 | 0 | 0 | 2 | 0 | 2 | 1 | 2 | 1 | 4 | 0 | 2
 | d | 22 | 0 |  | 16 | 18 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 1 | 4 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 0
 | d | 0 | 1 |  | 17 | 22 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 2 | 2 | 4 | 20 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 0 | 0
 | e | 0 | 1 |  | 18 | 24 | 2 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 3 | 2 | 5 | 21 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 0
 | f | 2 | 1 |  | 19 | 22 | 2 | 2 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 2 | 2 | 4 | 16 | 2 | 2 | 22 | 0 | 0 | 0 | 22 | 1 | 3 | 2 | 0
 | f | 0 | 0
 | f | 22 | 1
 | g | 1 | 1
 | g | 0 | 0
 | g | 2 | 0
 | h | 2 | 1
 | h | 0 | 1
 | h | 3 | 1
 | i | 1 | 0
 | i | 2 | 1
 | j | 3 | 0
 | j | 4 | 0
 | j | 2 | 1
 | j | 5 | 1
Spreadsheet: 91953d1291649593-match-with-multiple-criteria-match
Sheet: Sheet1

Table trying to compare |  |  |  |  |  | Lookup Table
User ID | RT | ACCT |  |  |  | User ID | RT | ACCT
1 | 214565 | 354 |  |  |  | 1 | 214565 | 354
3 | 34623 | 64868 |  |  |  | 2 | 32155 | 541
4 | 3264514 | 14684 |  |  |  | 3 | 34623 | 64868
6 | 251454 | 68415 |  |  |  | 5 | 6245 | 151336
 |  |  |  |  |  | 4 | 3264514 | 14684
 |  |  |  |  |  | 6 | 251454 | 68415
Dessired Results
User ID | RT | ACCT |  |  |  | User ID | RT | ACCT
1 | 214565 | 354 | 18 |  |  | 1 | 214565 | 354
3 | 34623 | 64868 | 20 |  |  | 2 | 32155 | 541
13 | 6254 | 954 | #NA |  |  | 3 | 34623 | 64868
4 | 3264514 | 14684 | 22 |  |  | 5 | 6245 | 151336
6 | 251454 | 68415 | 23 |  |  | 4 | 3264514 | 14684
 |  |  |  |  |  | 6 | 251454 | 68415
Spreadsheet: 881576d1729683606-placing-two-columns-value-into-one-hl-to-forum
Sheet: Sheet1

 |  |  |  |  | High | Low |  | High | Low | High | Low
 |  |  |  |  |  |  |  |  | -5.5 |  | 6
 |  |  |  |  |  |  |  |  |  | 3.900000000000091
 |  |  |  |  |  |  |  |  | -4.400000000000091 |  | 3.799999999999727
 |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  | 62
 |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  | 18.59999999999991
 |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  | 35.5
 |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  | -6.400000000000091
 |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  | 7.5
 |  |  |  |  |  |  |  | -44.5
 |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  | -2.800000000000182
 |  |  |  |  |  |  |  |  | -4 |  | 6.5
 |  |  |  |  |  |  |  |  |  | 9.600000000000364
 |  |  |  |  |  |  |  | -29
 |  |  |  |  |  |  |  | -56.40000000000009
 |  |  |  |  |  |  |  |  |  | 20.20000000000027
 |  |  |  |  |  |  |  |  |  | 21.59999999999991
Spreadsheet: 182768d1348597654-indicate-duplicate-with-small-time-span-id-start-date-stop-date-columns-duplicates-with-varying-date-ranges
Sheet: Sheet1

ID # | Start Date | Stop Date | Helper | Min in Row No | ID # | Start Date | Stop Date
1 | 2012-08-01 00:00:00 | 2012-08-01 00:00:00 | 1.002 | 3 | 1 | 2012-08-01 00:00:00 | 2012-08-01 00:00:00
2 | 2012-08-03 00:00:00 | 2012-08-05 00:00:00 | 2.002002 | 4 | 2 | 2012-08-03 00:00:00 | 2012-08-05 00:00:00
4 | 2012-08-01 00:00:00 | 2012-08-12 00:00:00 | 4.001011 | 5 | 4 | 2012-08-01 00:00:00 | 2012-08-12 00:00:00
5 | 2012-08-01 00:00:00 | 2012-08-16 00:00:00 | 5.002015 |  | 3 | 2012-08-19 00:00:00 | 2012-08-24 00:00:00
3 | 2012-08-19 00:00:00 | 2012-08-24 00:00:00 | 3.002005 | 7 | 7 | 2012-08-30 00:00:00 | 2012-08-31 00:00:00
2 | 2012-08-01 00:00:00 | 2012-08-05 00:00:00 | 2.002004 |  | 8 | 2012-09-01 00:00:00 | 2012-09-03 00:00:00
7 | 2012-08-30 00:00:00 | 2012-08-31 00:00:00 | 7.002001 | 9 | 5 | 2012-08-01 00:00:00 | 2012-08-03 00:00:00
3 | 2012-08-15 00:00:00 | 2012-09-01 00:00:00 | 3.002017
8 | 2012-09-01 00:00:00 | 2012-09-03 00:00:00 | 8.001002 | 11
5 | 2012-08-01 00:00:00 | 2012-08-03 00:00:00 | 5.002002 | 12
7 | 2012-08-28 00:00:00 | 2012-08-30 00:00:00 | 7.002002
1 | 2012-08-01 00:00:00 | 2012-08-11 00:00:00 | 1.00201
I have a data set where certain ID #s appear twice.
I need to write a formula in Column D that will indicate the row, that if the
ID # is a duplicate, has the lower amount of days between start date and stop date.
Thanks all!
Spreadsheet: 752542d1634823235-trying-to-extract-the-value-from-a-worksheet-with-a-given-address-efh-1
Sheet: List

Account | Name | [NAME] | Serv | Lab
C-001 | Name 1 | Add 1 | Serv 1 | Lab 1
C-002 | Name 2 | Add 2 | Serv 2 | Lab 2
C-003 | Name 3 | Add 3 | Serv 3 | Lab 3
C-004 | Name 4 | Add 4 | Serv 4 | Lab 4
C-005 | Name 5 | Add 5 | Serv 5 | Lab 5
C-006 | Name 6 | Add 6 | Serv 6 | Lab 6
C-007 | Name 7 | Add 7 | Serv 7 | Lab 7
C-008 | Name 8 | Add 8 | Serv 8 | Lab 8
C-009 | Name 9 | Add 9 | Serv 9 | Lab 9
C-010 | Name 10 | Add 10 | Serv 10 | Lab 10
Spreadsheet: 119701d1314673183-sum-rank-and-return-rank-and-return
Sheet: Master

Project Number | GL | Funding Category | Total Expenditure | Rank
11345 | 1344142 | Community1 | 52410.2
11347 | 6626312 | Community1 | 30000
11349 | 6264652 | Community1 | 212000
11351 | 6626312 | Community1 | 9000
11353 | 6626312 | Community1 | 24000
11355 | 6626312 | Community1 | 18000
11357 | 6626472 | Community1 | 6750
11359 | 6626472 | Community1 | 18000
11361 | 6626472 | Community1 | 13500
11363 | 6626312 | Community1 | 20000
11365 | 6626472 | Community1 | 22500
11367 | 6626312 | Community1 | 6000
11369 | 6626312 | Community1 | 11000
11371 | 6626312 | Community1 | 10000
11373 | 6626312 | Community1 | 82000
11375 | 6626312 | Community1 | 23000
11377 | 6626312 | Community1 | 17000
11379 | 6626312 | Community1 | 33372.78
11381 | 6626312 | Community1 | 12000
11383 | 6626312 | Community1 | 3000
11385 | 6626312 | Community1 | 3999.98
11387 | 6626472 | Community1 | 9000
11389 | 6626472 | Community1 | 2250
11391 | 6626472 | Community1 | 3000
11393 | 1345142 | Community1 | 5600
11395 | 1345142 | Community2 | 716671.55
11397 | 6626542 | Community2 | 9175
11399 | 1345142 | Community2 | 9175.01
11401 | 1345142 | Community3 | 231312.16
11403 | 1345142 | Community3 | 768633.56
11405 | 1345142 | Community4 | 675436.35
11407 | 1345142 | Community4 | 261327.45
11409 | 1348556 | Community4 | 691288.77
11411 | 1345142 | Community4 | 197772.58
11413 | 1345142 | Community4 | 263905.8
11415 | 1345142 | Community4 | 324968.79
11417 | 1345142 | Community4 | 297509.78
11419 | 1345142 | Community14 | 814929.95
11528 | 6626542 | Community15 | 120
Spreadsheet: 770684d1646224578-dropdown-see-text-from-column-a-but-return-value-from-column-b-sample
Sheet: Sheet2

Description | Rate
Smith & Co regular hours
Smith & Co afternoon shift finishing 2000-0000
Smith & Co night shift commencing / finishing 0000-0600
Smith & Co Saturday hours
Smith & Co Sunday hours
Smith & Co public holiday hours
Jones Ltd regular hours
Jones Ltd afternoon shift, commencing 1000-1300
Jones Ltd afternoon shift, commencing 1300-1600
Jones Ltd night shift commencing 1600-0400
Jones Ltd night shift commencing 0400-0600
Jones Ltd Saturday hours
Jones Ltd Sunday hours
Jones Ltd public holiday hours
Spreadsheet: 377985d1424236171-how-to-lock-cells-in-a-protected-worksheet-analyst-appraisal-form
Sheet: Analysts

 | 1) | Project Performance
 |  |  |  | Self | Manager 1 | Manager 2 | Manager 3 | Manager 4 |  | Self | Manager |  | Rating Scale
 |  | Project Type | # of projects | Score | Score | Score | Score | Score |  | Comments | Comments
 |  | Hot Lead Handover |  |  |  |  |  |  |  |  |  | 4 | Significantly exceeded targets
 |  | Newsletter |  |  |  |  |  |  |  |  |  | 3 | Targets exceeded
 |  | Accepted [NAME] |  |  |  |  |  |  |  |  |  | 2 | Targets met
 |  | Profiling / Appt Setting / Trials / Databuil |  |  |  |  |  |  |  |  |  | 1 | Targets not met
 |  | [NAME]
 | 2) | Targets
 |  |  |  | Self | Manager 1 | Manager 2 | Manager 3 | Manager 4 |  | Self | Manager
 |  | Project Name |  | Score | Score | Score | Score | Score |  | Comments | Comments
 |  |  |  | 2 |  |  |  |  |  |  |  | 4 | Significantly exceeded targets
 |  |  |  | 1 |  |  |  |  |  |  |  | 3 | Targets exceeded
 |  |  |  | 3 |  |  |  |  |  |  |  | 2 | Targets met
 |  |  |  | 4 |  |  |  |  |  |  |  | 1 | Targets not met
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 3
 |  |  |  | 2
 |  |  |  | 1
 |  |  |  | 2
 | 3) | Value / Acceptance
 |  |  |  | Self | Manager 1 | Manager 2 | Manager 3 | Manager 4 |  | Self | Manager
 |  | Project Name |  | Score | Score | Score | Score | Score |  | Comments | Comments | 3 | Exceeded expected value to be generated / acceptance rate
 |  |  |  |  |  |  |  |  |  |  |  | 2 | Met
 |  |  |  |  |  |  |  |  |  |  |  | 1 | Under
 |  |  |  |  |  |  |  |  |  |  |  | NA | NA
 |  |  |  |  |  |  |  |  |  | Self
 | 4) | Number of planned leaves
 |  | Number of unplanned leaves
 |  |  |  | Self | Manager 1 | Manager 2 | Manager 3 | Manager 4 |  | Self | Manager
 | 5) | Extra work taken on |  |  |  |  |  |  |  |  |  | 4 | Often
 |  |  |  |  |  |  |  |  |  |  |  | 3 | Occasionally
 |  |  |  |  |  |  |  |  |  |  |  | 2 | Rarely
 |  |  |  |  |  |  |  |  |  |  |  | 1 | Never
Spreadsheet: 269745d1381264715-sort-team-totals-2013-10-07-excel-forum-oeldere-
Sheet: Blad1

Teams | Totals | helpcolumn | rank |  | rank | team | totals
1 | 7
2 | 21
3 | 6
4 | 8
5 | 7
6 | 2
7 | 6
8 | 6
Spreadsheet: 0a8791de-84e4-4eb4-bfac-22483612972b
Sheet: Automotive Tech

AUTOMOTIVE TECHNOLOGY                                   Student Name:
Diploma - Automotive Technician                          ID #
General Education | Semester | Grade
___ Area I Written Communication, Oral communications or Humanities/Heritage (3)
___ Area II Social/Behavioral Sciences, Natural Sciences or Quantitative Reasoning (3)
___ CIT 105 (3) Introduction to Computers OR ___ IC3 Computer Literacy Exam
Program Courses
___ ADX 120 (3) Basic Automotive Electricity
AND ___ ADX 121 (2) Basic Automitive Electricity Lab
OR ___ BEX 100 (3) Basic Electricity for Non-majors
AND ___ BEX 101 (2) Basic Electricity for Non-majors Lab
___ ADX 150 (3) Engine Repair
___ ADX 151 (2) Engine Repair Lab
___ ADX 170 (3) Climate Control
___ ADX 171 (1) Climate Control Lab
___ ADX 260 (3) Electrical Systems
___ ADX 261 (2) Electrical Systems Lab
___ AUT 110 (3) Brake Systems
___ AUT 111 (2) Brake Systems Lab
___ AUT 130 (3) Manual Transmissions
___ AUT 131 (2) Manual Transmissions Lab
___ AUT 140 (3) Basic Fuel & Ignition Systems
___ AUT 141 (2) Basic Fuel & Ignition Systems Lab
___ AUT 142 (3) Emission Systems
___ AUT 143 (2) Emissions Systems Lab
___ AUT 160 (3) Suspension & Steering
___ AUT 161 (2) Suspension & Steering Lab
___ AUT 180 (3) Automatic Transmission Transaxle
___ AUT 181 (2) Automatic Transmission Transaxle Lab
___ AUT 240 (3) Computer Control Systems & Diagnosis
___ AUT 241 (2) Computer Control Systems & Diagnosis Lab
___ COE 199 (1) Cooperative Education Program
OR ___ AUT 198 (1) Practicum
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 880798d1728649129-advanced-filter-advancedfilter
Sheet: Advanced Filter

Month | Year | Cost |  |  |  |  | Month | Year | Cost
January | 2015 | 1050 |  |  |  |  | February | 2015 | 1350 |  |  |  | 2015 | 1350
May | 2015 | 1050 |  |  |  |  | March | 2015 | 1350 |  |  | March | 2015 | 1350
June | 2015 | 1050 |  |  |  |  | April | 2015 | 1350 |  |  | April | 2015 | 1350
June | 2015 | 1050 |  |  |  |  | July | 2015 | 1350 |  |  | July | 2015 | 1350
August | 2015 | 1050 |  |  |  |  | November | 2015 | 1350 |  |  | November | 2015 | 1350
January | 2015 | 1105 |  |  |  |  | February | 2015 | 1435 |  |  | February | 2015 | 1435
May | 2015 | 1105 |  |  |  |  | March | 2015 | 1435 |  |  | March | 2015 | 1435
June | 2015 | 1105 |  |  |  |  | April | 2015 | 1435 |  |  | April | 2015 | 1435
June | 2015 | 1105 |  |  |  |  | July | 2015 | 1435 |  |  | July | 2015 | 1435
August | 2015 | 1105 |  |  |  |  | November | 2015 | 1435 |  |  | November | 2015 | 1435
January | 2015 | 1200 |  |  |  |  | March | 2015 | 1672 |  |  | March | 2015 | 1672
February | 2015 | 1200 |  |  |  |  | April | 2015 | 1672 |  |  | April | 2015 | 1672
March | 2015 | 1200 |  |  |  |  | July | 2015 | 1672 |  |  | July | 2015 | 1672
April | 2015 | 1200 |  |  |  |  | January | 2015 | 1690 |  |  | January | 2015 | 1690
May | 2015 | 1200 |  |  |  |  | May | 2015 | 1690 |  |  | May | 2015 | 1690
June | 2015 | 1200 |  |  |  |  | June | 2015 | 1690 |  |  | June | 2015 | 1690
June | 2015 | 1200 |  |  |  |  | June | 2015 | 1690 |  |  | June | 2015 | 1690
July | 2015 | 1200 |  |  |  |  | August | 2015 | 1690 |  |  | August | 2015 | 1690
August | 2015 | 1200
November | 2015 | 1200
November | 2015 | 1211
February | 2015 | 1350
March | 2015 | 1350
April | 2015 | 1350
July | 2015 | 1350
November | 2015 | 1350
February | 2015 | 1435
March | 2015 | 1435
April | 2015 | 1435
July | 2015 | 1435
November | 2015 | 1435
February | 2015 | 1500
March | 2015 | 1672
April | 2015 | 1672
July | 2015 | 1672
January | 2015 | 1690
May | 2015 | 1690
June | 2015 | 1690
June | 2015 | 1690
August | 2015 | 1690
Spreadsheet: 682908d1592392234-formula-indice-corresp-exemplo
Sheet: Sub. 1 A

FICHA DE REGISTO DO DEPÓSITO
NÚMERO: Sub 1A                                                      CAPACIDADE (Litros): 90.920                                                TIPO: Subterrâneo
DATA | VOLUME (LITROS);(G/L) |  | Quantidade no depósito | PRODUTO | PROVENIÊNCIA | DESTINO | LOTE | Operação efectuada | OBSERVAÇÕES
 | ENTRADA | SAÍDA
2020-05-19 00:00:00 |  | 25000 | 65000 | VTN
2020-05-20 00:00:00 |  | 65000 | 1500 | VTUE
Spreadsheet: 869918d1716462895-index-and-match-multiple-rows-only-returning-top-row-gw_test3-aligw
Sheet: Sheet3

 | Dataset |  |  |  |  |  | Index and Match retrieve
 | Unique ID | Town | In the area? | Urban community | IMD 1 - 3 |  | Unique ID | In the area? | Urban community | IMD 1 - 3
 | A2G00043 | Bury | No | No | Yes |  |  |  |  |  |  |  | No | No | Yes
 | A2G00044 | Matlock | No | No | No |  | A2G00044 | Yes | No | Yes |  | A2G00044 | Yes | No | Yes
 | A2G00044 | Matlock | Yes | No | Yes |  | A2G00045 | No | No | No |  | A2G00045 | No | No | No
 | A2G00045 | [NAME] | No | No | No |  | A2G00052 | Yes | No | No |  | A2G00052 | Yes | No | No
 | A2G00052 | Rochdale | Yes | No | No |  | A2G00053 | Yes | No | No |  | A2G00053 | Yes | No | No
 | A2G00053 | Oldham | Yes | No | No |  | A2G00054 | Yes | No | No |  | A2G00054 | Yes | No | No
 | A2G00054 | Stockport | Yes | No | No |  | A2G00065 | No | No | No |  | A2G00065 | No | No | No
 | A2G00065 | [NAME] | No | No | No |  | A2G00067 | No | No | No |  | A2G00067 | No | No | No
 | A2G00067 | [NAME] | No | No | No |  | A2G00078 | Yes | Yes | Yes |  | A2G00078 | Yes | Yes | Yes
 | A2G00078 | Partington | No | Yes | No
 | A2G00078 | Partington | Yes | Yes | Yes
Spreadsheet: 0ea3d29a-db50-4906-b5ba-51c9c1cd38b6
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42761783 | 2014-08-17 15:29:07 | AXIS | 0 | 5 | 6 | 331242 | AdairC | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
42762053 | 2014-08-17 16:00:55 | ALLIES | 1 | 6 | 4 | 331242 | AdairC | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
42768282 | 2014-08-17 23:42:01 | AXIS | 0 | 4 | 6 | 256598 | sam1812 | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
42768832 | 2014-08-18 00:33:04 | ALLIES | 0 | 2 | 6 | 256598 | sam1812 | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
Spreadsheet: 843583d1695374238-divide-multiple-sums-of-cells-based-on-days-comasate-as-weeks-enel-distributie-excel
Sheet: Sheet1

Week end | Week start | week | Month | Area | Service | KPI Type | KPI | KPI ID | Weekly | Monthly |  | 2023-08-31 00:00:00
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6 |  |  | 64 | 7363 | 13652
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
Spreadsheet: 036e83d8-f6da-4151-b7d2-1535c93b6cb2
Sheet: Sheet1

BS/MS - EE | Unnamed: 1 | Name | Unnamed: 3 | [NAME] | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | BS Crdts | MS Crdts | Total
FRESHMAN -Fall | MATH 121 | UNIV 101 | CHEM 101 | ENGR 101 | ENGR 121 | ENGL 101 | [NAME] 100
2011 | Calc I |  | Chem/Bio | [NAME] | Comp Lab I
Credits | 4 | 1 | 3.5 | 2 | 2 | 3 | 1 | 16.5 |  | 16.5
FRESHMAN-Winter | MATH 122 | PHYS 101 | CHEM 102 | ENGR 102 | ENGR 122 | ENGL 102 | UNIV 101
2012 | [NAME] | Physics I | Chem II | Freshman Des II | Comp Lab II
Credits | 4 | 4 | 4.5 | 2 | 1 | 3 | 0.5 | 19 |  | 19
FRESHMAN-Spring | MATH 200 | PHYS 102 | BIO 141 | ENGR 103 |  | ENGL 103 | UNIV 101
2012 | [NAME] | Physics II | [NAME] | [NAME]
Credits | 4 | 4 | 4.5 | 2 |  | 3 | 0.5 | 18 |  | 18
SOPHOMORE-Fall | [NAME] 231 | PHYS 201 | [NAME] 220 | ECE 200 | ENGR 201
2012 | [NAME] | Physics III | Materials | Logic | [NAME]
Credits | 3 | 4 | 4 | 3 | 3 |  |  | 17 |  | 17
SOPHOMORE-Winter | [NAME] 232 | Choice* | ECE 203 | ECE 201 | ENGR 202 | General [NAME]
2013 | [NAME] |  | Prog Eng | Circuits | [NAME] | Elective
Credits | 3 | 3 | 3 | 3 | 3 | 3 |  | 18 |  | 18
CO-OP Spring | SOPHOMORE CO-OP
2013
CO-OP Summer
2013
PRE-JUNIOR-Fall | ECE 361 | ECES 301 | ECE Elective | ECEL 301 | General  [NAME] | General [NAME]
2013 | Probability | Trans Meth |  | ECE Lab I | Elective | Elective
Credits | 3 | 4 | 4 | 2 | 3 | 3 |  | 19 |  | 19
PRE-JUNIOR-Winter | MATH 291 | ECES 303 | ECE Elective | ECEL 302 | PHIL 315
2014 | [NAME] | Trans Methods II |  | ECE Lab II
Credits | 4 | 3 | 4 | 2 | 3 |  |  | 16 |  | 16
CO-OP Spring | PRE-JUNOR CO-OP
2014
CO-OP Summer
2014
JUNIOR-Fall | Free Elective | ECE Elective | ECE Elective | ECEL 303 | GRAD COURSE | GRAD COURSE
2014 |  |  |  | ECE Lab III
Credits | 3 | 3 | 4 | 2 | 3 | 3 |  | 12 | 6 | 18
JUNIOR-Winter | ECE 391 | ECE Elective | ECE Elective | ECEL 304 | GRAD COURSE | GRAD COURSE
2015 | Intro to Design |  |  | ECE LAB IV
Credits | 1 | 4 | 3 | 2 | 3 | 3 |  | 9 | 6 | 15
JUNIOR-Spring | FREE ELECT | General [NAME] | General [NAME] | ECE Elective | GRAD COURSE 4 | GRAD COURSE
2015 |  | Elective | Elective
Credits | 3 | 3 | 3 | 3 | 3 | 3 |  | 12 | 6 | 18
JUNIOR-Summer
2015
Credits |  |  |  |  |  |  |  | 0 | 0 | 0
SENIOR-Fall | ECE 491 | ECE Elective | FREE ELECT | GRAD COURSE | GRAD COURSE | GRAD COURSE
2015 | SR DESIGN I | 400 level
Credits | 2 | 3 | 3 | 3 | 3 | 3 |  | 8 | 9 | 17
SENIOR-Winter | ECE 492 | ECE Elective | FREE ELECT | GRAD COURSE | GRAD COURSE | GRAD COURSE
2016 | SR DESIGN II | 400 level
Credits | 2 | 4 | 3 | 3 | 3 | 3 |  | 9 | 9 | 18
SENIOR-Spring | ECE 493 | ECE Elective |  | GRAD COURSE | GRAD COURSE | GRAD COURSE
2016 | SR DESIGN III | 400 level
Credits | 4 | 3 |  | 3 | 3 | 3 |  | 7 | 9 | 16
Undergraduate Advisor Signature__________________________ |  |  |  | Graduate Advisor Signature__________________________ |  |  |  | 180.5 | 45 | 225.5
Spreadsheet: 850658d1701072258-could-you-please-look-at-my-code-sumif-not-working-for-me-budget-tracker-to-upload
Sheet: Staff Members

 | 2023-09-01 00:00:00
Person 1
Person 2
Person 3
Person 4
Person 5